I had to look at it and walk away 3 times before I finally got it, but that was exactly what I needed!

Thank you,

Chris

It still boggles my mind that tSQL doesn't have a built in function for this, but thank you very much for providing it. I've needed one several times in the...

No, I had not generated a snapshot. I did so through the "View Snapshot Agent Status" by hitting start. Now I can see the SPs on the subscriber.

Thank you!

-Chris

Michael Earl (6/5/2008)

---

Also, for reports that are relatively static throughout the day, you may want to schedule them to execute and store copies on a server at the site the...

I really appreciate everyone's input.

Maybe some additional information will help. I didn't want to include everything initially for fear of boring frightening people away. 🙂

The data is currently being mirrored...

Hi Noob,

Thanks for the reply. Unfortunately, the database has a lot of traffic and we don't want it to eat up the WAN bandwidth.

Also, we need access to the data...