Sounds like you need to do each file as a step within the dts package.  How many files are there?

Jules

Yes, I believe transactional does push schema changes also.

Sql Litespeed is a very good tool for SQL Server backups, it compresses the file and is very fast.  Bear in mind  SQL Litespeed's price plan is per cpu on...

Dan,

I think you might have to pass in a format file, but what is the default of the output file set to?  Is it not tab delimited?

Jules

Ian,

Sorry I have not had the time today to respond to you today.  The way referential constraints work is through a parent table and one or more mulitiple child tables. ...

Ian,

You will need to drop the foreign key constraint before you can drop or truncate any tables that it references to.  You can always add the constraint back after your...

Martin,

To think further ahead, you might want to consider creating an index filegroup totally separate from the primary filegroup and move your indexes there because it really isn't a good...

Serqei,

You cannot do this:

select *

into beta.work.dbo.Table_backup

from _all_props

instead connect to the remote server and run this:

select *

into Table_backup

from servername.dbname.dbo._all_props

also make sure table_backup does not already exist because it gets created...

I had this problem before using excel and loading into a table with some rows missing. The best way to do this is to change it to a tilde...

Yes, you need to install sql2kasp3.exe, mandatory if you are using windows xp, in order for server analysis to work. Once you get to processing cubes, you will run...