What have you done to verify that the file is not in use by another process?

Can you provide the OS?

Here are a couple of blog posts that are good reads for selecting indexes:

http://feedproxy.google.com/~r/SqlInTheWild/~3/Oi1xzC6jiZ0/

http://feedproxy.google.com/~r/SqlInTheWild/~3/qNiI731n59Q/

Not minutes from 1/1/1970 as that puts you in the 4000's. Could be seconds though.

Overall this is a mystery and you need to find someone involved in creating...

SSIS is a a good tool to do that. IF you aren't doing any other transforms to the data then the bcp utility or bulk insert might be a...

I'd use a tool like RedGate SQLCompare or Apex SQLDiff.

If you have to have a script, this should get you started:

SELECT

T.name AS table_name,

...

Duplicate post. Please post answers here.

Assuming you are using a table, if you have group/table headers and put the fields you want aggregated into the header you will get aggregated data. You can change...

You can specify the collation at the database level. Check out the Create Database entry in BOL.

This says that you have...

I've found a couple of instances where this was caused by an error in the installation of SP2. SP2 reports it succeeded, but there are a couple of scripts...

I usually use a data conversion task to transform the data to the expected data type, unless I can change the destination to the source data type.

That could potentially be a busy trace. It depends on the number of admins you have, if any applications are running under sa or a sysadmin account, and how...

The default trace "may" have the information needed, but, this according a MS in a connect item, the "default trace is not for security auditing", so you probably need your...

You need to do a command line install and include the SKUUPGRADE parameter. See this article.

If you have the option to improve performance and data integrity by adding foreign keys and indexes to the current database I would start there.

You also have to...