And you could see his login in sysxlogins? If so, was he denied access for some reason, such as a particular Windows group he was a member of being denied...

Which instance was he trying to connect to? How did you grant him login rights to the SQL Server?

It's not just SQL Server. Windows Server 2003 SP2 has issues. Removes Help & Support. Causes issues if you have older Broadcom drivers. Don't forget the furor over what it...

There is also PostgreSQL and DB2.

Well, put it in comparison to what the owners were pulling in and I can see where they were coming from. This is especially considering that there wasn't any free...

If you ever decide to play at http://www.letsplaychess.com, PM me here at SSC. It's correspondence chess as well. Just happens to be the only correspondence chess...

I feel the same way. A great example: Candlestick Park vs. Monster Park. Sorry, Monster Park just completely loses any sense of nostalia.

Speaking of opening day, Glavine looked good yesterday (as did Moises Alou) for the over-40 club. He added a single and a sac bunt to a solid outing on...

Scope creep is a big one. This is one area where as a PM you've got to take as much a stand as you're capable of making when it starts...

True, I got used to that format in college (military college) and in the military. We used it because it wasn't ambiguous. 03 May 2007 won't ever be confused with...

You may have to end up contacting Microsoft Support. I believe it'll continue to be a problem, especially since I think it resets the permissions on the database files when...

Unfortunately, I don't think you can change the way SQL Server 2005 sets up itself. Typically, though, SQL Server is setup where the drives appear locally to the server where...

BOL = Books Online.

As to whether or not you can replace them? No. You should not. If you want to use domain groups, leave the local groups in place and...

It should also write to the SQL Server error log. But if you want it completely separate, as has been previously mentioned, use a SQL trace / Profiler. If it's...

If the SQL Server you are managing is SQL Server 2005, this will be grayed out, for it's the interface to support SQL Server 2000 SQL Server Agents, which only...