also gave view definition access to the database but still gives the error.

yes in single quotes like

WITH EXECUTE AS 'StateME\LTara'

if not then how?

we have to do an auditing before and after updating production databases.

is the firewall on my server or the remote computer where i am putting the .bak files?

how can i fix that?? or does the windows admin has to do...

anyways I am doing it since years and now its failing.

actually the issue is with that error to troubleshoot.

thanks

but i do so. we can change it.

Now everything looks working except that when i put in

EXECUTE as User its not working.

I doubt if this feature works all the time as this is the new...

Though i put in

WITH EXECUTE AS 'State\TPatel' which has sysadmin role still i get this error

GSquared

when i use

IF EXISTS ( SELECT name FROM master.sys.databases WHERE name = @DBName )

OR EXISTS ( SELECT name FROM Rev1.master.sys.databases WHERE name = @DBName )...

GSquared

Your proc looks good but i get some errors as

Not all users can use select from sys.databases and so i want to exec proc as an id which...

thank you guys..

Yes as Mike said, I have to check for db name on all 4 servers.

I have to hook this proc to an app where i have to allow...

Thank you guys.. it was my mis understnding.

I havent tried anything so far. I dont know how to aggregate them

I have a table with all Cust Codes and CustId from there i have to create a 3 rd table as above, its not existign yet, i would like to...

150 days worth of information will be calculated later but first i would to put these CCodes in a table with the flags in a proper way. I also have...