There are many things that can happen. The best thing you can do is run a test on a test system, upgrade things, and then if you have specific errors,...

There is a compatibility mode you can set on the databases as well to have them run as SQL65 for keywords and functions.

I'm not sure what a new technology is anymore. SQL 2008 got to RC0 and it includes Powershell for SQL, which is new. I played with Hyper-V, and it's straigtforward,...

Authors work hard on these books. Pirating them or downloading them for free when the author has not agreed is wrong. You want to get paid for your work; pay...

You should read through the physical storage architecture sections or BOL or pick up a copy of Inside SQL Server.

If you have CHAR, then the space is saved in the...

I'd script it out and then save the script. You can easily search and replace the server names or database names if needed to rebuild replication.

At TechEd this morning, they are giving away lots of DVDs with RC0 and the rumors are still a Q3 RTM, so things must be very close. I've seen the...

Most consistency errors are raced back to hardware problems. Potentially fabric or controller errors could be present.

I'd be sure that someone carefully runs diagnostics on your storage.

This is really a scripting problem. You can host this in DTS, but you'll be writing VBScript that can be run from the command line as easily as tucked inside...

SP2 had an issue and there were updates postSP2 that corrected issues with this task.

Jack makes a great point. Often the person that pushes the project through or gets it approved doesn't use the system. They "think" that people need something new, and if...

You can reply to a previous thread or topic and post an answer that way (or a new question).

The linked server syntax is four part naming, so server.database.schema.table.

Haven't heard of anything. What does the package do?

You might need to call Microsoft support for this.

What are the steps?

In the job properties, is each step set to move to the next step on completion? Are the jobs the exact same jobs in both instances?

You could...

Agree, add the user to the role rather than aliasing.