I like automated solutions. As much as I think Sugesh' is the simplest solution, if something doesn't work, then replication gets frustrating to work with.

Or it has in the...

The comments are crazy. You should search it out on Slashdot for some good humor.

I agree with you. Everything is a tool. Heck, I don't even care about the Mac...

If this is 2005, set a DDL trigger on the ALTER STORED PROCEDURE statement and log which stored procedures are changed and by who.

Logins aren't mapped to databases. Logins are mapped to users, which are in each database.

You need to scan the users in each database and relate those back to the login.

My guess is the clustered index is faster, but it's a guess. It provides a more ordered way for the optimizer to find the rows and delete them, but it...

Are you connected to it in the Registered Servers window? How are you connecting?

Documenting is hard, often because there's no good place to keep documentation handy. I prefer ER diagrams, but you really need some snippets from Word or someplace handy to note...

Wow, great replies and thanks for the debate. Looks like most of you are probably better with this than I am.

Peter, didn't know that. Where is this in Outlook?

William, it's...

Phil,

I feel for you and you have some sympathies.

First, get that diagram up on the wall where you can see it.

Now, as you look over the app, report, or whatever...

A little late here, but throwing tables together is database design. Not good design, but it's design.

Doing a design well means looking at the things Jeff has mentioned. I'd mention...

Best of luck and sorry, that was what I got from someone at MS. My guess is there's a redirect somewhere that's popping SP4 regular.

A good reason to always keep...

Might check out this:

http://www.sswug.org/sswugtv/seeshow.asp

Mock interview series on the right

The reservations are probably cheap knowing Antares. It will be the shipping cost of heating oil and power you'll have to worry about 😛

http://www.microsoft.com/downloads/details.aspx?FamilyId=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en\

That is interesting. Sounds like diesel submarine technology.

Wonder if there's a snorkel if you hit deep sand 🙂