Fair enough. That would have been a piece of...

Since it works in tsql in ssms, there has to be something different about how it is being sent to SQL Server from tiny_tds.

Have you confirmed that you are running...

Looks like the spammer of the evening is mo.minbd200.

Here is a bunch.

https://www.google.com/search?sourceid=chrome-psyapi2&rlz=1C1CHFX_enUS589US589&ion=1&espv=&es_th=1&ie=UTF-8&q=vmware%20sql%20server%20case%20study

If you reach out to VMWare, they should be able to provide you with plenty of resources / testimonials as well.

jslusher (9/22/2014)

---

I can run the following in SSMS and get data:

exec sp_replmonitorhelpsubscription @publisher='publisher', @publication='publication', @publication_type=0

If I run the same query using T-SQL I get the following:

...

Absolutely. It's an art to get it all...

steganography

Alvin Ramard (9/22/2014)

---

Stefan Krzywicki (9/22/2014)

---

I'm kind of hoping this becomes the new thread. Yes, we'll lose the high count, but it won't have a title that might put people off...

Building on what Lowell already did and the information you provided concerning the start and end of the business day, you can schedule a job to run your export at...

I am curious about what you need your data to look like when you run your query. Can you provide a sample of what the output needs to look...

Eirikur Eiriksson (9/22/2014)

---

Steve Jones - SSC Editor (9/22/2014)

---

There was no chance to get...

With it in msdb, you can simply import the package from the test server. Meaning, connect to your other server and use the import option in the ssis store.

Alternatively,...

It looks like some decent scripts have been shared. I would caution against msforeachdb or msforeachtable due to some quirks that can cause databases or tables to be skipped...

Is your package deployed to sql server and stored in msdb?

Erin Ramsay (9/22/2014)

---

The majority are adhoc queries and even the ones in stored procedures are vendor owned and we can't change them. That's why I was hoping for something along...