May be a network problem where that server is located. I had this happen for a week on a transactional replication I had and turned out to be someone who...

I like it for the most part, but considering the antitrust case I am surprised Microsoft is being given such a pivotal product as it basically leads everything into proprietary...

Keep in mind, never assume your first query for anything is optimal, and learn to understand the execution plan.

Biggest OPPS, renamed a table on a major production site and forgot...

Cost of the program and wanted to break from my job at the time.

Personally I enjoy taking what I or others have done already and try to look at the sql code from various angles and try to revamp it until I can...

Just a note as a why. @dGetDT is a local variable and when you built the string and executed the string variable it created another process not in the same...

I didn't notice any major change when I added the one for deadlock and lock extended details. There is some overhead, and the best way I can tell you is...

Actually you can in regards to making data case-sensitive, by default it is not. It is available under custom. As you go thru custom it will get to the point...

Opps, that was not using SQL Mail but programming a DTS pack to access smtp servers cdonts and send.

The key is the server has to be MAPI, notes will not accept even if thru Outlook. We cheated inhouse by installing smtp server and using it to send to...

Just a silly thought, but when SQL 6.5 was reinstalled, did they remember to reapply all service packs. (I vaguely remember this in an early fix but it has been...

You may also want to check some of the download sites for freeware as far as comparing two scripted files all you have to do is find a freeware editor...

If you want to email as I don't know what the rules are on posting links here. I will be glad to send you several help and usefull links to...

Also I would look at creating NT groups that you can place these folks in where the groups have already been assigned proper access inside SQL. Avoid adding peoples accounts...

And if this is coming from a backup set then you just start SQL server and create the databases then in EM you can restore directly over them to...