Sorry code block did not accept all xml file so had to put as normal text.

• This reply was modified 5 years, 4 months ago by  SqlServerLover.
• This reply was modified 5 years, 4 months ago by  SqlServerLover.

Thanks. I end up using something else.

Thanks. I will try.

Thanks so much Lowell.

I have never done any powershell script so do not know how but i will search and see how i can do it.

Thanks. I think i can modify this stored procedure to get any information like database information,job information, backup information etc right?

Hi,

Can i see your stored procedure? I want to do the same thing to create SSRS report for 30+ different servers.

Wow nobody replied to me ?

Lol.

Thanks guys.

Just for your information.

After I posted this; I ended up doing more of MS BI work and less of DBA work even though I got a job as...

Thanks.

There are so many things to consider like service account, encryption key, subscriptions etc when i refresh test enviromnet with production.

Can anyone tell me what are the steps i need...

Thanks

Ya i already have those books. I will start reading them now. Thanks.

Thanks

Thanks everyone