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!

Once you save the maintenance plan, open it again by double clicking it. You will get a "toolbox" in the lower left.

The History Cleanup task deletes meta data in the...

How is it updating? Is it doing a transformation? Is it an Execute SQL task? You haven't really explained how it works.

If it's just using SQL, why not use a...

Don't think the above will move the mdf. Will get the data and objects out, but system tables, metadata, etc. are stuck until you detach/attach.