You can add users to the fixed database role called db_datareader.  It can be done either in Enterprise Manager or by executing sp_addrolemember in Query Analyzer.

Greg

That's what it sounds like to me.  Make sure that the DTSRUN command in the job step has the correct package name and password (if there is one).  I don't...

Ryan,

What datatype is the originating column?

Greg

Why wouldn't it be considered a commercial post?  That's just about all you ever post.  If you want to advertise, pay the going rate and leave the forums to people...

What happens when the job fails?  Any errors in Job history?  Any errors in package log?

Greg

Since I work in western Washington, it's hard to pass up the opportunity.  Our management isn't big on sending us out of state for training anymore, but it's a pretty...

You can use sp_helplogins and sp_helpsrvrolemember or look in the Security folder in Enterprise Manager.

Greg

Joao,

An offline database can't be backed up.

Greg

Alan,

Sounds like a memory leak.  Does this KB article apply?: http://support.microsoft.com/kb/816937/  It says that the problem was fixed in sp4 and there's a hotfix for instances running sp3.

Greg

TEXT datatype can store more than the allowable row length because the data is stored outside the table.  Only a 16 byte pointer to the page where the data can...

If you're sure you saved the packages to SQL Server, not to files or VB, perhaps the msdb backup you restored was taken at a time when no packages were...

Meredith,

Run the installation from CD as you normally would and when you get to the screen where you choose a default instance or a named instance, the default instance checkbox...

Is it a newly created table?  Try refreshing in Enterprise Manager.  Can you see the table in Query Analyzer's Object Browser?

Greg

You can restore msdb to your newly installed instance and have the DTS packages back.  See "Restoring msdb database" in BOL.

Greg

The db_ddladmin database role allows a user to create a stored procedure.

Greg