I'm pro DRI, and support the arguments presented above. One con I haven't seen mentioned is that sometimes you need to index the FK in the table with the...

Follow-up: Eswar tried to copy the service master key backup file local to his test server before restoring it, and he was not able to do that--access denied. ...

I've never seen that error but it seems to be saying it thinks your master key file is corrupt or something. You're using BACKUP SERVICE MASTER KEY, then...

Roy, I neglected to say "nice article" in my previous post.... Thanks, I did enjoy it!

jcrawf02, that was true a long time ago, but for many years...

I agree with Jack Corbett's post, you need to look at the locking impact. Many years ago a team I worked with came to the opposite conclusion due to...

Wow. I think you've got the impact right, if they really want to change the keys. The data is encrypted by the key, so if the key changes,...

I agree. Not sure there is an argument against, it was just the way Rich originally phrased things "Profiler aside..."

Here's what I've figured out so far:

BOL wording "can be one of these values" is wrong. @flags values are definitely meant to be combined.

Undocumented value 32 = "include...

Try using sys.dm_db_index_usage_stats DMV? I'm not sure how long info stays here, but certainly is retained through service stops & starts (caveat: I haven't actually used this in...

Server traces don't have to involve "profiler" ... I'm probably being nitpicky though? You could readily write something like this, ensure your server trace always running, periodically dump output...

Thanks, Bob.  I figured as much, just shot in the dark to see if anyone had figured out a way (maybe found some undocumented functionality). 

If anyone with input to MS reads this.......

1.  You got the point, but I think Rasheesh used somewhat poor choice of words above.  Checkpoint does not really "commit the uncommited transactions", rather it flushes committed transactions to...

I agree with Noel. 

Only time multiple filegroups have ever proven helpful to me in past was when I had medium sized DB (100-250GB), and had to temporarily take it...

Rudy & Noel, just want to say "thanks" for your replies.  I've stopped trying to treat this as a SQL Server problem, involved our domain admins.  No news yet, might be...

Thanks for reply.  I thought same thing, that's why part of my test was a PING run simultaneously with the OSQL command that failed to login.  The results are in...