Check out the feature pack for compatability tools:

http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

A named instance.

Heh, heh, yeah I made the mistake of not looking at the year too.

71-444 is now available in Beta also, Optimizing and Maintaining a Database Administration Solution.

Check the permissions of the accounts used for the SQL Services

Try looking into this:

ALTER TABLE....

SWITCH PARTITION..

TO...

First off, DBAs should NEVER be domain administrators.

You need to get documented your seperate teams roles and responsibilities.

Then, and only then, start defining security permissions.

As a preference, I would do...

Could this be updates to prerequisites like the .NET framework?

What's the format of your object name in the dsn?

From assumptions based on your table names, it may be better to drop the CONSTRAINT to remove rows from 'Agent' and archive your security events, or to create a...

Ray is correct, a student ID should refer to one student only and forever.

In the real world, if someone dies, should I get a new social security number?

No, the index still exists, takes up space, it's just disabled. But you're right, the primary reason for using Disable is to simplify the process to a simple ALTER...

Post up your whole script.

Note that:

ALTER COLUMN cannot have a collation change if any of the following conditions apply:

If a check constraint, foreign key constraint, or computed columns reference...

Hi,

Why are you using a self referential linked server?

Microsoft SQL Server 2005 : Changing the Paradigm is quite a good book I've found, anything else you've come across Rick?

Disclaimer: I'm working as a SQL Security consultant and SOX is one of the issues I have to cover.

"One would think that the best people to commit fraud and misuse of data would...