TOP is recommended.

Steve Jones

steve@dkranch.net

I'd be wary to removing any "system" like tables. HAve you noticed any issues? Do they get recreated with a new diagram?

Steve Jones

steve@dkranch.net

I had, but I use the same job on multiple servers and use the Dynamic Variable Settings to get some information for the package. This way I can also do...

My guess is that they do, but I will do some testing.

Steve Jones

steve@dkranch.net

Try saving the package with a password. This alleviates many problems.

Be sure you have not used any SQL 2K specific tasks. A number of new tasks are only supported on...

I am working on an article, but here is my ActiveX script that I use:

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=74

Steve Jones

steve@dkranch.net

There is no limit on the size of the text datatype.

Steve Jones

steve@dkranch.net

Haven't worked with multiple instances. I'd test on the 2nd instance and move to the first for production. The naming is more complex for 2nd instances, so if it works...

Try this:http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp

Steve Jones

steve@dkranch.net

The v7 Design test was harder than the v2000 test, IMHO. I took both within a few weeks of each other. Of course, I work in 2000 most of the...

I have a few refs:

BOL:Placing Tables on Filegroups

BOL:Using Files and Filegroups

Inside SQL Server - Doesn't really discuss, but recommends not too unless advanced DBA, knowedg of DB, etc. Does note...

I'd apply the KISS principle. Setup two tasks and let one grab records for TableA, ignoring other records. Let the 2nd grab records for TableB and ignore the others. Might...

One thing I have read, but not tested, is that mutliple filegroups improve IO as a separate thread is created for each file. This can have some benefits for splitting...

I agree with Brian. That's how we do it here to limit liabilities in production. Of course, our manager also does development and can be a maverick.

...

Even if it's a hash, since it can be duplicated, there has to be a way to decrypt it. Nobody has spent the time to do it, including myself, though...