Thanks for the complements and I'm glad to finally get it. I told a few friends, but I didn't want to make a big announcement.

Quite of few of you should...

This is a setting for files on your system. When you install SQL Server 2005 tools, the .sql extension is linked to Management Studio. Note that this is a tool,...

We do not condone or post dumps from exams. That violates the NDA you have with taking the exam and if you receive a brain dump and use it, you...

You can use SSIS to "roll back" a SQL 2005 database, but why would you? Why not just install another instance of 2000 temporarily if you need to?

Once you upgrade...

Not sure about the 64-bit to 32-bit move. Both of these require a full backup and you can easily test that to see if it works.

If you are doing reporting...

You're two service packs behind, but I'm surprised. Is this the same on other workstations servers if you connect to this server? I don't remember a bug for this, but...

No and No.

The system tables contain information that keeps the server running. Logins, users, databases, etc. are contained there.

Why do you want to mess with the system tables?

Thanks:blush:

I'm a little confused and concerned. First don't use Sa or equivalent for something like Cold Fusion. Create an account and work through the rights.

Second, the current security context will...

You add a new conneciton in the Data Sources (ODBC) control panel. Enter the server name/instance name and your credentials. It will connect.

http://support.microsoft.com/kb/943656, looks like you need to submit a request to get the download.

You could build a maintenance plan with SSIS that just does maintenance cleanup. Probably be easiest.

No problem keeping connections open. If they don't use resources (queries), there's very little overhead. Might be sure you have error code in case the connection gets dropped.

I'd actually consider...

I was going to suggest what Michael posted.

Since I often find myself going back a few events, I'd actually keep a query around to pull everything from today.

select

...

...

Great explanation and I'd add that they did a great job with the DMVs exposing almost everything you need, so you don't really need to hit the base table.

Plus the...

It's actually easy. Inside a company, you buy CALs. If the people are authenticated users, Windows Auth, or just AD accounts, they should use CALs. Per processor is for unauthenticated...