What's going on with these questions.

Again one with no correct answer to choose from.

I know Steve Jones explained the process of choosing and testing QOTD in his article...

Can you run DTS packages in SQL 2005?

In most cases the answer would be yes. There are a few incompatibilities but you can detect these by running the Upgrade advisor...

Like said before you should check your executions plans first in case there are any differences betwen the fast and the slow executing ones.If you find a differece between the...

I agree with Jeff and Barry, but what interests me is why would you want to change the date created of a table ?

At the beginning of a backup the last Log Sequence Number (LSN) is recorded. Once all the data from the datafiles is written to the backup file, SQL Server uses...

Did you check this:

http://support.microsoft.com/kb/811889

Sorry Steve,

that's not an option.

First of all SQL 2005 do't allow you to remove guest...

To be honest, I simply think that the number for SQL 7.0/ 2000 are worng. The max database size is determined by the max number of database files and the...

The easiest option is just generate scripts of your jobs and alerts and run them on the 2005 server.

But make sure that you've transferred logins first because if you...

When you do an in-place upgrade the compatibility level will be upgraded to 90. You don't have to do anything.

If you attach a database you have to change the...

Jeff is correct about the table variables.

The rerason why temp tables perform better for larger datasets is not so much parallelism but the fact that temp tables can use statistics.

Also...

Attaching a database should only take a couple of seconds no matter how large the database. Since the actual datafile already exists all which needs to be done is updating...

Could this be a permission problem ?

For INSERT INTO you only need datawriter permissions, while for a SELECT INTO you need at least CREATE TABLE permissions.

Two things spring to mind.

First of all after migrating to SQL2005 all statistics become unvalid and you should run DBCC update statistics on all tables/indexes.

Second, depending on the hardware configuration,...

Another good resource:

http://www.sqlsecurity.com/