Has anyone else been through this?

I created a simple scalar function that checks if the folder exists, if it doesn't it creates it - it depends on Jeff Moden's awesome function DelimitedSplit8K, but you can...

sheba.sql (6/3/2015)

---

I have Credentials stored in the report for the Data source and also i am using a select statement in the report not calling any store procedure. User is...

That depends on many factors. Not sure "how long" but you can find out how large the snapshot for the tables will be by running something like:

SELECT pubname...

Out of sheer curiosity; is the backup being done by a 3rd party tool like BackPro, SQSafe, or Lightspeed, etc?

If so, you'll need to kill the actual thread using something...

I store all my SSIS packages in a local folder on each server (I do not deploy them to the package store)...so I can set them up in the Agent...

Is your subscriber online? Or are there any processes blocking your distributor sessions?

Gail, looks like you hit the nail on the head...

In looking through the reporting procedure I did notice a TVF being called (although it really looks harmless and has a...

@Grant - yes it's production (reporting) - and typically I don't do it either but wanted a comparison (its strictly troubleshooting only as I'm not overly familiar with extended events...

This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

I was expecting the raise error function to be thrown if the option was not provided correctly. It only printed the message in the ELSE block.

Can you help me understand...

I'm not entirely sure this will help but found this article [https://ask.sqlservercentral.com/questions/24486/replication-limit-on-number-of-push-subsciptions.html] - I don't think there's an exact limit as much as there's a threshold with "load"

-Hope it helps!

I have written a custom script to rebuild index. But if users choose wrong choice, it is supposed to throw a specific error msg which it does not do.

Please help...

Interesting! I have no experienced this issue.

It could be that you're filling up your files faster than the job is able to pull them out...so it's getting overwritten before...

How large is the dataset being returned? Not saying the network is to blame but returning data locally will always be faster than retrieving it through a linked server...