Thank you for the response. The job must run 30 minutes minimum after the job last. Run. I will add the additional steps. You made a good...

I managed to find the solution:Adding "-Recoverymode Standby" , this will allow me to restore transaction

"C:\Program Files\Idera\SQLsafe\SQLsafeCmd.exe" Restore test1 F:\Backup\test1_db_dump.safe -Replace -Move test1_data2 G:\Mssql\Data\test1_data2.NDF -Move test1_Log H:\MSSQL\Log\test_Log.LDF -SecurityModel Sql -Recoverymode...

I appreciate all the help and suggestions, I went with this selection that was provided. Many thanks

DECLARE @DbName VARCHAR(100),

@SP_Name VARCHAR(100),

...

I received this cursor, that works fine if the procedure does not exists, what I want to acccomplish is to alter the procedure, how can I change this cursor

DECLARE...

The method would work but I cannot use this solution as I need for this procedure for each database. do you have any other solution or method to carry...

I appreciate the assistant but the suggestion did not work. Using sp_executesql what is your recommendation on proceeding.

In this server I have around 24 databases with similar schema.

I appreciate the help from everyone who participated, this is what I end with as a solution, please note or make any suggestion for improvement.

USE master;

GO

SET NOCOUNT ON;

GO

DECLARE AllDatabases CURSOR...

okay, I appreciate all the time an effort from everyone who participated, this is what I ended up with as a test.

USE master;

GO

SET NOCOUNT ON;

GO

DECLARE AllDatabases CURSOR FOR

SELECT name...

This solution work but it only deletes the rows from the database being reference.

USE master;

GO

SET NOCOUNT ON;

GO

DECLARE AllDatabases CURSOR FOR

SELECT name FROM sys.databases WHERE database_id > 4

OPEN AllDatabases

DECLARE @DBNameVar NVARCHAR(128)

DECLARE...

Got it, Thanks

I undestand that part but this is what the cursor is built for, it when check the database in that instance. How can I get though this. The concept is...

I worked the solution in but I get this error

CHECKING DATABASE jaime

Msg 208, Level 16, State 1, Line 1

Invalid object name 'WORKLISTLOG'.

I appreciate the suggestion by I need to be able to apply this to all my database in one statement. Can you help my original statement

Thanks and I will look in to this.

What I have so far is this. I have taking the statement that backups the database and modified it. The issues I have...