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...

Two things on the maintenance plan:

1. I have had problems with the integrity checks failing. I will try Brian's solution and see if this is the issue.

2. When it fails,...

Couple things:

BULK INSERT does work for native mode:

Run this on a server:

bcp Northwind.dbo.Customers out c:\NWTest.txt -n -T

Then create a copy of the Customers table on another server (or same). Should...

I am split here.

I think change control is critical and dev people (DBAs, programmers, etc) should not change production. I know someone has to wear both hats (I know I...

The best solution, IMHO, is to use one of the commercially available and readily known encrpytion algorithms. They biggest part of the encryption is the key. Keep in mind that...