I'll confirm that Remi is correct.  If a job, replication jobs included, is disabled, it won't run on schedule.

Greg

Duncan,

I just read this article this morning and it explains a lot about run-time support and design-time support for SQL Server 2000 DTS packages in SQL Server 2005.

Greg

It would be hard for me to support my family on less than I make now, so no, I wouldn't give it up.  Fortunately, I really like what I do...

I'm in the midst of developing a plan for migrating our DTS packages to SSIS packages, but I haven't done any yet.  I think you're referring to the DTS 2000...

William,

Lydia is referring to the Import/Export Wizard and it is fairly easy to use.  I recommend you choose 'Copy objects and data between SQL Server databases' because it gives you...

Yes, it is free.

Greg

Auditing tracks changes to data and/or objects in SQL Server so that actions can be attributed to a person or process.  Auditing is often implemented to conform with government regulations...

Hi Utsab,

Well, I'm stumped.  If he used the Copy Database Wizard, he should have gotten an error for the destination database because, as I recall, you can't rename the database during...

Hi Utsab,

What does the developer mean when he says he "tried to restore Database2 from Database1 directly"?  Maybe it's the teminology that's confusing me.  I think of "restore" as meaning...

Use SP_HELPFILE to find file size and RESTORE HEADERONLY to find expiration data of a backup set.

gREG

I'm still unclear about how Database1 came to be in a loading state.  If a restore was in process, try this in Query Analyzer:

RESTORE DATABASE Database1 WITH RECOVERY

Greg

If you have a lot of packages to save, I've found a great, free tool that will save or transfer multiple packages.  This saves you the effort of opening each...

Yes, assuming you use Source Safe, that's where to look.

Greg

Are you talking about change control for database objects?  Typically, a database isn't replaced with a new "version", but objects (tables, stored procedures, etc.) are replaced or updated.

Greg

Are both databases on the same server and were sp_detach_db and sp_attach_db used to create Database2?  If so, you get the error when trying to attach Database1 because you can't...