I bet you are not making this mistake, but I once did, so just in case....

I wrote an export to csv (not from SQL Server), expecting " around the text...

If you do go down the truncate table route, be aware that identity columns are re-seeded.

Might there be some merit in droppping any indexes before the delete and rebuilding them...

Many thanks - this is the solution. A whole team of developers is grateful (and one DBA).

Anothe win for SQL Server Central!

As VSS can control anything that's file-based, why not save to a structured storage file (*.dts) and use that in VSS? These files get big as they can save multiple versions within...

I agree with all of these points, and that's the way I'm going to go.

Thanks for your help.

Bill.

My objection is really on principal - it's one reason why I reject code with "SELECT *" in it. However, all of this is a compromise - if all your...

I'd take option 3. If the code looks too nasty, you could balance this by calling other stored procs - though then you end up with lots of nearly-identical SPs....

This is a "DOH!" error that happened to me...

When you run the tasks individually within the designer, you're taking reponsibility for the workflow. I guess this is obvious, but it...

I'd recommend Redgate - no experience of the others but very good experience of SQL Compare. It writes good scripts and is logical to use.

DTS Compare isn't as good though...

The central question seems to me to be:

Can different customers share 1 model, or is it a standard 1-many so each customer can have many models but each model has only...

Another way to solve this is to set the Excel connection parameters before running the data pump. This can be done with an ActiveX script as follows (VBScript):

Function Main()

'Prepares Excel...

If no other way, you might do this with DTS.

I have managed this with an ODBC connection to Intersystems Cache, using and Execute SQL task. The only problem really was...

Redgate's SQL Compare is smart enough to script your tables (and other objects) in the right order, though I'm not sure what it would do if there were nasty circular references. Its...

Doesn't this just show up a weakness of SQL Server. Compared to Oracle's ToDate or VB's Format, this is all a bit complex for a pretty common task. I know,...

I think you should consider just why you need a column in a particular postion. If I remember it correctly, part of the relational database model is that column order...