And then you'll need to reset it back to 1000 before your next insert, then set it to 3000 (or whatever your highest # is) after the insert is finished

We have the same situation ... It can be annoying. If you run queries between DBs with different collation, you may have to write them like this

select * from DB_CollationA..TableA...

We use Idera's SQLSafe for backups, which I think is similar to Litespeed. It creates backup files that are compressed about 80 %, and in about 1/3 less time. It...

But if the developers are using the database, you don't want to restore on top of it. Hard to decide on the best solution with limited info.

I also edit DTS packages in 2005. Are you on Service SS-2005 Pack 2 ? And you have the Backward Compatibilty add-in for DTS ?

You can't reliably copy data from one database to another if the target is being changed without your knowledge. You need better communication with the developers, and then you can...

Simon Doubt (10/1/2007)

---

I realize that this is probably much too late now, but you could always use SSIS, or the bcp utility, or a T-SQL INSERT ... SELECT statement to...

You've NEVER done a Full Backup ?? EVER ?? In that case, you are out of luck. If you have a full backup from some period...

Yes, we do this, and one instance is 2000 and the other is 2005

That's probably it ... I haven't used the Meta Data options - forgot they were even there ... Thanks

I don't see an option in 2000 to save as Meta Data ... Just "SQL Server", "Structured Storage File" and "Visual Basic File" ....   All my DTS packages are"regular" packages...

Could be, but 2005 has a "Legacy option" that allows the old DTS packages to run as 2000 DTS packages without migrating to 2005. That's what I'm planning to do. ...

Column Descriptions are extended properties. If you make the change in EM, then script it out, you see the code that you need to run in QA.  It's a good...

Your original post just mentioned the amount of time it took. At this point you probably won't get any new readers to this thread, so if you want to get...

I assume you meant  " ... that i CAN always ... "

There's no "best" answer.  I do a full backup every night of my 280 G database (takes 1/2 hour), and...