Just like the backups, you can use the wizard or script.  The restores worked fine.  The coolest feature was the ability to restore all log backups in a folder with...

When I gave this presentation to the local user group, this question came up.  The only idea someone had was for the performance files.  Use the performance collector in each domain....

That is very odd, the SQLH2 base collector is only supposed to pick up files starting with 'pfc', so it shouldn't have even tried to open that file.  Normally, you don't...

ADO Recordsets have Move, MoveFirst, MoveNext, MoveLast and MovePrevious. They also have EOF and BOF properties. You also might find the AbsolutePosition property helpful. When the recordset...

It will still work if you just stop and start the service.  When the service is restarted, it will create a new file with a different name.  The old file...

Without seeing your code, it is difficult to guess. One thought is that you may be trying to add NULL values when building your string. For example, say...

When you move the files to the local server, make sure that you use the local path, not the UNC path. For example, don't use \\servername\e$\sql2000\ , use e:\sql2000

Kathi

SQL Server Central is all about DBAs and developers helping each other out, so I'm sure that others would appreciate learning about these tools as well.  Thanks for mentioning them!

Thanks, Brian.  I found the the set up was a little tricky at first, too.  My goal was to give a different perspective on installing and configuring so that others...

I just found what I was looking for.  It is called "Cascading Parameters". 

I am pretty sure it is processed for each row.  You could do something like this:

declare @CatCount int

select @CatCount = dbo.IntListCount(@categoryIDs)

select

*

from

PersonCategoryAssign

inner join

dbo.IntListToTable( @categoryIDs )

on number = PersonCategoryID...

Check the recovery model property of the databases.  By default, master, northwind, msdb and pubs are set to "simple" which means you can't do a transaction log backup and therefore...

I wonder if you are backing up the system databases or any other databases with the recovery model set to simple.  In that case the job would fail when it...

Try fully qualifying the sp_dboption command like this:

master.dbo.sp_dboption.  But I don't know why you have to take the old database offline first. 

I agree with Steve.  Check the database in your connection object in the DTS package.  Recenly in another post, someone had a script to do a restore of database X...