Hi,this is script for same purpose :

set nocount on

declare @nam nvarchar(255)

declare @qur nvarchar(max)

declare shayanCurs cursor for

select top 50 name from sys.objects where type = 'U'

open shayanCurs

fetch from...

Hi

there is any number of reasons, like the agent can not access to log backup to restore or you are using the secondary database and database is in Use .

for...