Are you by any chance using GUIDs as ordered primary keys? This is causing similar issues for us in a legacy system.

SSIS would handle this very nicely and be easily repeatable.

Easiest way to determine what else will need to be changed is to right-click the table in SSMS and click View Dependencies. This will tell you everything that references...

If you would post a sample of the csv file, and a create table script, I will see if I can figure it out. Sounds like a setting issue...

OK, just so everyone understands, this is not a SQL problem. The .NET Framework has a special data type for SQL databases in System.Data.SqlTypes.SqlDateTime. For some really silly...

Different dev teams I guess. Not very efficient.

Which transformation and destination components are you using?

I use .NET 4.0 and they did not update the date range limits in the libraries to match the new range in SQL Sever. I will have to wait...

Definately time the index rebuilds for off peak hours to minimize impact to the users.

You can always place the database in Read-only mode after the restore/upgrade. Unless I am mistaken, that is all that option does anyway.

Don't use that option. Restore with recovery so that SQL 2008 can run the various stored procedures that upgrade the database structure to the new format.

Then change the database...

I agree with PaulB.

When a flat file is presented, the layout/structure is typically well known. That is part of the initial discovery.

If there are freeform notes or something, I...

In my experience, SSMS does not script a drop and recreate of a table unless you insert the new column somewhere other than at the end. To append a...

Books online list the following requirements/limitations for indexed views:

The ANSI_NULLS and QUOTED_IDENTIFIER options must have been set to ON when the CREATE VIEW statement was executed. The OBJECTPROPERTY function reports...

Please provide detailed information including scripts to create and populate sample tables so we can see exactly what you are trying to accomplish.

Reading http://www.sqlservercentral.com/articles/Best+Practices/61537/ is a good start.