Kit G (9/3/2010)

Yes, we are. I'll let Gus...

Just for load, I'd do them in series. As noted by Jason, I have no metrics.

I'd also use shrinkfile instead of shrinkdatabase. Had better luck with that.

OK, Lowell's theory works for me. I can re-enable a constraint, with CHECK, and it succeeds, even if I have data in the table that conflicts with the FK.

That seems...

Is this the add of a constraint and not a re-enable? Did you disable it for some reason? What is the constraint?

I don't think you are supposed to be able...

In addition to the other notes, if you have file system access from the Windows server, you can bcp out (or SSIS export) the data to a file that you...

Are you post SP2 + SPs? There were some fixes for plans.

What are your deletion settings?

Be safe, hope no major damage.

You can run a SQL 2000 database on a SQL 2008 server in compatibility mode 80. That might work for you.

Not sure if SQL 2000 can run as a named...

Kit, are you and Gus near Tampa? I heard Jonathan Kehayias was looking for a DBA, paying well.

IF it's eval edition, you can get info here: http://mangalpardeshi.blogspot.com/2009/05/expiration-date-of-sql-server.html

If you want to query each server, I'd think that eval edition had a note in the @@version that it was...

There are all types of settings that occur when you connect to SQL Server from any client. There's SET ANSI_NULLS, SET ARITHABORT, etc. If these are set differently from different...

There are no logs of what happened to a table. As Steve mentioned, there's a default trace, but it only keeps the last 25MB of stuff that happened on the...

Is that the only permission you granted?

What do you mean "solve it"?

SQL still has to run the query, read through the data, and process the results. They could change. The time savings usually comes from things...

Any of the diffs after the full will work. I'd think that typically you wanted the latest diff made after the full.

Isn't the backup finish time in the headeronly result?