James,

The import package may be failing when scheduled because the login used by SQL Server Agent doesn't have access to the Access 2000 database location. 

Keep in mind that when...

When tempdb is recreated at startup, it uses size and growth specified for the model database.  To fix, set the model autogrow parameter to 10% before the next reboot. 

Greg

Or this:

select t1.UserId from Mytable t1 join Mytable t2

on t1.UserId = t2.UserId

where t1.ItemId = 'AA' and t2.ItemId = 'BB'

I'll second Kat's remark about working for a government agency.  We've able to purchase pretty much any books we can justify to fill the gaps between formal training classes.

Greg

RTM is usually referred to as "Release to Manufacturing".  It's the initial production release of a software product.

Greg

Backing up and retoring will work, as will detaching and attaching the databases.  Any article about migrating databases between instances of SQL 2000 will contain instructions for it. 

One suggestion:...

We use MS Visual Sourcesafe for version control of stored procedures.  We don't keep back versions of views.

Greg

Michael,

I use DTS to move packages directly from msdb.sysdtspackages on one server to the same table on another server.  I took the instructions at http://www.sqldts.com/default.aspx?204  and added a Dynamic Properties...

Clive,

I use DTS to move packages directly from msdb.sysdtspackages on one server to the same table on another server.  I took the instructions at http://www.sqldts.com/default.aspx?204 and added a Dynamic Properties...

Sam,

I'm not clear about what you want to do in DTS.  If you're doing database backups, you can use SQL Server backup commands and put them in scheduled jobs.  Maybe...

I agree with Yelena.  DBO is not a login.  When I execute sp_changedbowner ‘dbo’ , I get the error "The login 'dbo' does not exist." 

I don't...

Actually Steve, Log Explorer can read transactions that were committed to t-logs before Log explorer was installed.  It can even read log backup files.

Jolyn, you could try using DBCC LOG...

I just noticed that you got pretty much the same suggestion in your thread in the Administration forum. 

For future reference, you might try posting DTS questions in the DTS...

Is your error message being generated by the DTS package?  If so, it's probably because when you execute it from Entrerprise Manager, it's executing on you workstation and when you...

By default, anyone can run the import/export wizard or create a DTS package, but they have to have permission to insert into the destination tables to make it work import and...