Thanks for the quick reply Ronen

It is a very good article indeed. I'll try again to see if I'll get lucky next time.

I know this is an old post but has anybody tried instructions in http://social.technet.microsoft.com/wiki/contents/articles/18481.shrink-sql-database-during-restore.aspx ?

I'm using SqlServer 2008R2 and I try to restore to a compressed folder.

If the...

Hi,

The only constraints you can disable are the FOREIGN KEY constraint, and the CHECK constraint. PRIMARY KEY, UNIQUE, and DEFAULT constraints are always active.

If you want to insert duplicates in...

Hi,

do you have a SP installed on the SqlServer? Check http://support.microsoft.com/kb/q300042/ 

Also, is it possible that you have a variable number of columns in each row?

If your csv file contains strings there might be a quote missing or an extra one. Try to set Text Qualifier to none in DTS and test import. Your imported...

If I understand this correctly, you created a domain group and added it to Sql server logins? Does this group have Login from the network policy to the windows server...