Is this under the DTS Package Properties: Write completion status to Event Log? And where is the Event Log stored? How do I access this information?

Lastly, this was...

Does anyone have the SQL Server 7 syntax for the sp_renamedb stored proc that they can post here?

Thanks!!!

I'm not on the server with the back-up device and have no control over this -- I get the message "Cannot open backup device..."

Any other ideas?

I'm not on the server with the back-up device and have no control over this -- I get the message "Cannot open backup device..."

Any other ideas?

I tried to modify this sp but I get an error message that states "Ad hoc updates to system catalogs are not enabled. The system admin must reconfigure SQL...

Thanks, I just tried your suggestion but now I get the following error message...

Server: Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'sp_renamedb'.

When I open the...

I had a similar problem where I was executing several DTS packages from within another DTS package and had a need to log each step/task with execution information (start time,...

I have added start-time and finish-time to the code and it works beautifully. (Below is the code I used)

Concerning the built-in logging function of DTS, how do I get...

Is there a way to get what the index of each step is to test this, or better yet, a way to get the order of execution of each...

To further clarify...

Simply use the following SQL statement to grant access to a Role:

GRANT SELECT ON TableName_X TO RoleName_Y

Place this SQL statement in the ExecuteSQL task within a DTS.

Thanks for...

I'm sorry, I can't seem to find Brian Knight's article 'Locking Down DTS' in this forum. I conducted a search with these keywords and the only thing that is...

Oops -- sorry about the double-post

Right, but what it does say is this...

From the section of the article subtitled:

Where is the DTS Package Running?

...When you run the package from the DTS Designer in SQL...

Right, but what it does say is this...

From the section of the article subtitled:

Where is the DTS Package Running?

...When you run the package from the DTS Designer in SQL...

Below is a quote from the thread: DTS works but schedule JOB don't...

Microsoft has posted this article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q269074

It seems to clarify the issue of using a msgbox and never...