The VSTS tool is Red Gate's under license.

There are other compare tools, but there is no best one. Try one or two, pick the one that works for you.

It's possible, but not necessarily. You'd have to check on what the load is on the server and if there are enough writes to cause a problem.

It's also a poor...

The key is dependent on which instance you are looking at. SSMS should read it from the registry, so I'm thinking that you're looking at the wrong key. Whatever is...

How are you checking this? The error log?

What is the setting in SSMS? All logins?

Telecommuting can go either way. I think I get more done at home than in an office.

Could there be a deny in there somewhere?

Can you add the specific user? Can you create a new user and a new group in AD, then add them? I'm not...

I think the "Law of Job Titles" says that we'll always have more. They'll definitely be replaced!

Some of this is here, some isn't. Now users don't necessarily need to know the physical server, but in some sense they do. They put in a server name, which...

The correct answer should be 0-25. BOL is slightly ambiguous as nothing is listed for 25. I have notified them of that.

Points are awarded back and the answer changed.

Nooooooooooooooooooooo, not two threads!

I think we get more specialized in some ways, and in larger groups, that specialization is needed. You'd like to think that we would get more reliable as well, so...

I wonder when this thread will have more posts than me?

Updating statistics and potentially rebuilding indexes that might be fragmented are two things you'd need to do to see what else might be wrong. Most things run better in 2005,...

The place you want to check for services, and change it, is in the SQL Configuration Manager. You can check in the Control Panel Services applet, but it's easier in...

Those threads are kind of funny. Let me Google that for you ROFL