This is BOL saysExplanationThis error occurs when the nonclustered index indicated by the index ID is in error. The corruption is detected when a process tries to delete a nonexistent row.ActionExecute DBCC CHECKDB without a repair clause to determine the extent of the damage. Then, execute DBCC CHECKDB with REPAIR_REBUILD clause to correct the damage. […]
2004-03-01
What do you mean by 'clean up the indexes'?Are you looking for UPDATE/DROP STATISTICS...
2004-03-01
And what about sa for 'normal users' ? I am a such a user as I'm not in the IT department at all.
2004-02-26
Are you creating the dimension from the fact table or from a separate table/view? I've run into this when dimensions are sourced from the fact table (normally a view for me) and that view is complex and takes some time to return results. If you are sourcing the dimension members from the fact table, I […]
2004-02-24
I gave you a little extra context, Line 151 is where the error is at which there is nothing there, the code actually starts at Line 152. http://www.macrotransport.com/availableload.asp that is the error I am talking about, one out of the two I have, everything was fine untill the upgrade, seems like an MDAC thing, it's all new […]
2004-01-30
1 reads
Hi, I'm evaluating a service where I will need to call a stored procedure which will check available balance through a micro payment service which runs over a secure website. The call looks similar to:https://webpage.clearinghouse.com/app/?user=me&password=mypassword This returns a basic results like: ok;{credit available}; Does anybody know of an existing XP that would return the result of a web […]
2004-01-30
Spark up BOL and look for sp_create_removable in the index. This will present you with several topics on creating a db for usage on a cd-rom, dvd, etc... Vik
2003-12-23
Been there, done this...leads to too many users requesting the same thing - then you get a comm bottleneck and complex jobs... We had a need for this and ended up writing a service (similar to weatherbug) that lives in the tray... try not to use sendmail in an sproc though. good luck
2003-07-21
Hi maxwell, quote: I need to trace changes made to my production database by developers. I can't deny them dbowner permission, so I need a script or a little tool to investigate db and fing what they have modified. I haven't done this before, but take a look at BOL for 'c2 audit mode option' […]
2003-07-07
Thanks When I look at the Memory tab of Server Properties in SQL Enterprise Manager, it looks as though I can allocate up to the full amount of memory on the server. I suppose that's just a bluff
2003-06-30
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers