you try deny delete on the table and wait for error to occur - depends upon your level of authority of course, but this would be one of my routes.

index defrag is not the same as rebuilding indexes. cxpacket waits are always bad news - generally what happens is that the cost of the query evokes a parallel plan...

you might want to check the net name   , you could have just changed the netname to allow the links to work using sp_setnetname.  Could be the connections are still...

no it wasn't that article is was a microsoft publication - I usually copy ms kbs etc. into my own docs as ms have a habit of changing ref numbers...

I think it's always difficult to get this point across about cursors and how transactions work! I totally agree ( with Andy ).

Sorry to burst the bubble but a cursor...

the service pack adds an extra step for configuration, I can't find the doc I wrote, only a screen shot!

from the console root components, follow computer properties, msdtc and...

it doesn't work that way - a sql login is a sql login, an ad/nt login is what it is.

one mdf made up of one file per socket or core. 6 disks have twice the throughput of 3 disks. I've rarely had to resort to using multiple mdf files...

I think you should publish the name of the vendor so we can all have a laugh - and avoid their products!!!

Agree with Steve - not feasable - multi cpu's...

apologies if I'm double posting - may have closed wrong window!

I've normally only had to do this

In command line, execute "unlodctr MSSQLServer" (Without quotation, the same as below)

 Reloading the...

I'd echo that, the index tuning wiz in sql2k is rubbish. Try using the advisor in 2005. I've seen some really bad decisions made with output from the tuning wizard.

Kalen...

generally row locking will be the default, but depending upon the query this may change, this is sometimes typical for a secondary integer index for example where a page can...

any database compare tool will do the job, SQL Compare, Kentico sql compare , dbghost etc.

In certain circumstances the database schema will not be identical, depends upon the source of course...

AND and OR are different and provide different functionality, properly optimised either can be fast.

Always worries me when dot net devs need help with database design and query writing, I'd always...

you need to understand the difference between roles, users and permissions. This is well covered in BOL.  I'm not sure you understand these concepts so maybe a training course would...