Red Gate has the dependency tool that will allow you to find out what is linked to what.

However if you are expecting to right click on an piece of code...

I don't know a lot of people using Resource Governor, but they have been successful. It is a little more complicated to setup and understand, but it does do a...

Run the query for the top 20 and then loop through it, running additional queries.

In T-SQL, I'm not sure how easy this is. In SSIS, you can create a new...

If you use formal parameters, and you're not concatenating user input with code, then I think you are safe for the most part. I wouldn't say that you're completely safe,...

Is there an error when you put it in? If you've registered with the new email already, or it's in the system, it won't change. The error message sometimes isn't...

I tend to follow Gail's advice. 2 Full backups + all logs.

Going back more than a couple days is almost always impractical for any system. For auditing purposes, I'd rather...

Job is the way to do this. You're scheduling something.

However I'd make it fairly generic. Run it every day, enable/disable people based on a day of the month. Building...

First, please post in the appropriate forum. Moving to Integration Services since you mentioned a package.

Second, please include the error. If you have an error, give the text. If you...

Doh! so close. Burress showing up at all might have helped.

Congrats to my British competitor for the win.

I tend to agree with Gilamonster's advice. The one thing I'd add about appending is that if something happens to the backup file, then you lose not only one, but...

SQL Kiwi (12/10/2011)

Yes, I had an email today saying it would be republished on that date (no doubt you saw my...

Good for Pujols. I heard the Angels owner say they expected him to bring in about half a billion over the next ten years with revenue changes and promotions. Plus,...

Brandie?

http://www.youtube.com/watch?v=CplUqjQqTq0

Transactional replication is the best way to do this. The regular disconnections required by Log Shipping are no end of frustration for end users.

Keep in mind, however, that you need...

I whacked our movie channels to save $20/mo when we got Netflix streaming. A month later my wife was upset with me. Not enough of a selection for her on...