Its not letting you use the "GO" in your dynamic SQL script. Break the script into 2 pieces. Because your first script is an "IF EXISTS DROP" there...

I've actually had alot of success with 2 different methods.

1st and probably easiest:

Create 2 packages. The first one called "Cycle Servers" or something like it. All this one...

Probably true. Although I have to say I would question any system that has to do DDL changes often enough that you run into regular blocking issues.

Greg Charles (2/4/2008)

---

If you only want developers to work with legacy DTS packages, try creating a database role in msdb e.g. DTS_Developer and granting it EXECUTE permission to these stored...

Actually based on the SP and based on the change I'm doubt it would hurt anything. I would certainly make a backup of it, and try it on a...

I wonder what would happen if you went in and modified it to use "WITH (NOLOCK)" or something similar on all of its queries.

Kenneth

Here is a thought for you. If you have 2000 go into the registration wizard. The 2nd page has a list of "Available Servers" and you can register...

Honestly I don't think there is a way. If you had them registered in SQL 2000 you can import them into SQL 2005 but otherwise I would just register...

Also if you are going to install the DTS components for SQL 2005 make sure you are on SP4 for SQL 2000 or Enterprise Manager won't work anymore.

Kenneth

Now there is one really neat kind of trace that I found called a TRACE_PRODUCE_BLACKBOX. It basically does a rolling 5mb trace file. If you tried a regular...

Yea, Its kind of anoying but SQL checks the syntax for the whole thing before starting .. and since the field doesn't exist yet it throws the error.

You may...

The biggest problem I had with passwords (that I had a hard time finding documentation on) is that in SQL 2000 passwords are case INsensative by default (you can make...

Try using SQL profiler.

You can specify the application name as one of the filters.

Fair warning though if your timeouts aren't reproducible or regular you may have to collect...

Unfortunatly I can't duplicate the error so I can't be 100% sure but you could be running into a compile error. I've had the problem before where even though...

If you are grouping on Name, Date then you shouldn't have duplicates for that combination.

You may want to post your query so we can look at it.

Kenneth