Thanks, that got me started. Now I can just use the same on SQLServerAgent and I'm good to go.

I know this is a really old post, but thougth I'd point out a couple lines in the script:

-- Decrypt passwords

-- Only works for 7.0 server

-- Encrypt algorithm changed in...

Super series of articles. This has helped me streamline monitoring and also learn SSIS more effectively.

Many thanks for taking the time to contribute.

I've found a few things that might be...

My understanding is that there are two ways to look at schema.

1. the way you initially said it.

2. the way I posted just above with the command giving authorization to...

But does the SQLServer:Databases Performance Object..Transactions/Sec Counter tell you whether it's a read or a write or just a transaction?

Yea, I just used the Self-passed training kit.

Personally, I've used SQL Profiler and output the results to a table.

At that point, I can dig into the results and massage them to find out that kind of info.

If you have SQL 2005 installed with the SQL Server Management Studio then just try to make a connection to the SQL 2000 instance that has the database(s) in question....

have you tried to do it through TSQL using WITH REPLACE?

You might also want to look at RESTORE VERIFYONLY AND RESTORE FILELISTONLY.

more info

Then you just open up SSMS.

Create a connection to the 2000 database server.

Right click on the database, and select tasks, generate scripts.

Select the items you need, and it will create...

I think you have to be careful with how you are using the term schema.

Have a read here.

I'd start with these resources:

http://weblogs.sqlteam.com/tarad/archive/2008/05/20/60604.aspx (will actually create the temp files for you)

http://weblogs.sqlteam.com/tarad/archive/2008/08/05/How-to-get-physical-CPU-count-on-a-server.aspx

I don't understand that last part.

I have been able to create a OLE DB Source out of the first statement without the into.

It's the Update that I'm having the issue...

Well, I was hoping to find a way to get away from the temp tables if possible. It seems that they aren't the best way within SSIS.

I wish more people were looking for that kind of talent. Most interviews I've ever been on were not like that.

I can find out how to do just about anything,...