Much better would have been to create an SSMS server group(s) with all the relevant servers in it(them), then fire off the script for a given server group(s) whenever...

+1 for an interim table. I use a similar concept for sending emails, it was not feasible to do in the application due to reasons I won't go into.

If it's...

I love the grainy pictures of problems, I send my solutions back in pictures with even lower resolution! Heh maybe I'm just old and cranky but I get a...

They say that helping others can also improve one's own learning. Partly for that reason, partly altruistic and partly as another avenue to pick up useful tips, I joined a...

• This reply was modified 4 years, 2 months ago by  david.edwards 76768.

Not sure if this has been done, but I thought I'd have a little fun on a rare day off:

The MSSQL DBA's Prayer:

Our Master, which art in DataCenter

Two-part be thy...

Imagine the lady in Poltergeist: ALL ARE WELCOME!

Come on in. The water is fine. This is just the local water cooler (bubbler/fountain/whatever your local vernacular is for a central...

Personally, I'm a bit sad (and also kind of excited I guess) that the days of SSRS are numbered for me - got to start from scratch and learn PowerBI...

As a (mostly) lurker on this esteemed forum for around five years, I've only recently come across this thread.

I've not managed to consume all 4000+ pages to find...

Thank you Jeff & Jeffrey for your helpful replies. I have sorted it now

Sadly my skills to SQL are not great so I find it easier to do these...

• This reply was modified 4 years, 3 months ago by  david.edwards 76768.

As a (mostly) lurker on this esteemed forum for around five years, I've only recently come across this thread.

I've not managed to consume all 4000+ pages to find the answer,...

Missed the fact that this was an SSRS forum. ...

In my opinion that's a big "it depends"! 🙂

Some...

• This reply was modified 4 years, 3 months ago by  david.edwards 76768.
• This reply was modified 4 years, 3 months ago by  david.edwards 76768.

Thanks much, it makes sense to me.

The project was a big one and a complicated one. And an entire project team with several good developers and BA and Project...

• This reply was modified 4 years, 3 months ago by  david.edwards 76768.

At the risk of sounding like a crazy stalker, I'm glad I started "following" you on this forum Jeff, I can usually guarantee that a thread you pop up on...

Thanks. This overnight update process is a part of  a  big project we had and hired several contract developers and project team. The web service/applications does very complicated process...