Moved to DTS forum. Please watch where you post.

Also, when you do the packages, if you can't see the new server, you can save as a structured storage file, copy...

space wise, we only show 5 + you.

We have more here: http://www.sqlservercentral.com/TotalScores

SQL Server 2000 has a debugger in Query Analyzer.

SQL Server 2005 has some debugging in Visual Studio, but nothing built in.

You could possibly pass in global variables from the various schedules. But that would mean separate jobs for each schedule

I'm lost.

Eye B cun-fuzed?

you might try here: http://www.sas70.com/faq/faq14.html

And then post a new thread in the SQL Server 2005, Security forum asking for more info.

Haven't heard or seen anything. There is a large in-memory cube addition for Excel due in 2010.

Scripting additions isn't a bad idea. We could use separate schemas as well for new features so that older scripts/demos still work with the original Northwind structure. The scripting idea...

http://msdn.microsoft.com/en-us/library/ms187329.aspx

You can include 1..n trace flags with DBCC TRACEON

Glad you like it. Pass the word around as we have a limited contract with Mr. Gonick to try these out. Scheduling one for every Wed.

IO seems to be the biggest issue with this, but you have to test. Don't forget that virtual instances are sharing resources. You don't get a "Free machine" by going...

Moving to 2005

In windows, every machine has a 4GB address space. It's 2GB for the app, and 2GB for the OS in 32 bit systems. You can allocate more to SQL, but...

How are you checking the host server? Activity Monitor just queries the servers for activity. note that this query is "activity" and will show up.

you could use VBScript and the FileSystemObject with sp_OA procs to find the date.

I'm not sure how else you can get this.