but my staements "create table ...." and "Select ...." are in same procedure.

in 1st procedure sends 'Create table....' script to 2nd procedure.

these 2 staments are executing in same session.

Regars

Kishore...

Hi

Thanks for your help.

I added above proxy server information in sql server MSDB.

and i ran the

exec master..xp_cmdshell 'DIR \\swodap1\c$\*.*'

but same error "access denied".

EXEC msdb.dbo.sp_grant_login_to_proxy @proxy_name=N'CMDShellPROXY', @login_name=N[color='What...

After run this script also i am getting same error "Access Denied"

I had added Proxy server credentials in my sql server server.

EXEC sp_xp_cmdshell_proxy_account ' ';

GO

Thanks

what is mean by UQ?

But I don't have any .BAK files at now. I have only the Secondary server DB which in the mode of norecovery.

Kishore KK