Please don't cross post.

First thread here: http://www.sqlservercentral.com/Forums/Topic431539-1042-1.aspx

The HTML display in Outlook is based on the size of the area in which it's displayed. This doesn't necessarily match what's printed, which is a problem.

Are you saying a...

Is it running on the same client in both cases? If not, you have two choices, client or server potential issues.

You could have a different isolation level on each server...

You can query for the licensing mode: http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx

I'm not sure why the product key was filled in. Possibly someone set up an unattended install and burned that to the media....

Do you get a similar error in the SQL Server error log?

This can happen at times when the server becomes overloaded. Is this standard edition of SQL Server? The reason...

Can you explain what isn't working in the backup and restore? This is a lot to look through and I don't see anything obvious. Does it not perform the log...

I would agree with Michael above. You should not change MAXDOP or depend on any ordering of the records for any reason. It isn't the way SQL is designed to...

Or build dynamic SQL. For a case like this (CREATE DATABASE command), I wouldn't worry about any performance issues.

What is the report doing? Can you run Profiler and try to determine if this is a problem with the db engine or SSRS?

If this is important, production data, call PSS at Microsoft.

DO NOT RUN ALLOW_DATA_LOSS as it's behavior is unpredictable and does not necessarily help.

This is a complex issue, and we can't...

The DTA is not bad, but it depends on the workload you run through it. Like any tool, it's examining the queries and making guesses. You want to be sure...

Rudy,

Have to disagree with you there. I think trust is important because it comes from someone being professional in their job. Process and procedures are the same way. There are...

That appears to be the case here as well. I can use indexing to move the tables to new filegroups, but can't move metadata. Can't use DBCC to get things...

EMPTYFILE should work for NDFs, but not sure it works in MDFs. I thought that error'd out because you can't remove an MDF, nor create a 2nd.

Hmmm, guess I need...

Here, here, Scott!