Nope - a login is a login. MS SQL does not allow you to restrict a loging to a specific application, and certainly not by default to part of...

The Red-Gate software is good. If you are going to be doing regular comparisons, spend the money. They are also nice enough to sponsor this community for us,...

See the following in BOL:

sp_xp_cmdshell_proxy_account

If you are using Enterprise Edition, you can create a data-driven subscription. This allows you to use a select statement to determine your recipient list. If you use...

This is really worth looking at:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/olapdbpssas2005.mspx

Even the 2K to 2K5 ugrade wizard for Analysis Services is a POS way of doing things. It was nice that they gave us something, but if you don't...

Not that I have seen.

I would expect this to not work. The AS backup strategy is to copy the files from the file system and basically zip them. ...

Did you add your columns at the end of the table, or between other fields?

If you added it at the end of the table, Management Studio will often issue an...

Ok, being as smooth as I could, here is a table and a function that will auto-generate files for you.

You then just need to insert a default value and return...

"Severely Hamper Performance" is an open-ended statement. Performance of what? You can use a blob field and upload the document into it and it will not hurt database...

That's a great document link - start there.

As an aside, if you have not used Service Broker for anything, you are now. The new mail procedures use service broker. Look at the procedure text to...

Since it is using SMTP, you may run into some other issues. I do not know what security is in Lotus Notes these days (luckily I don't have to...

SQL Mail is not looking for the Lotus Notes mail server, it is looking for an SMTP server. If your lotus notes server is configured as an SMTP relay...

You can use lock escalation hints to cause any select statement to take a shared lock on an entire table. Check books online (TABLOCK). You could also make...