What else is happening on each box? It sounds like there would be a lot more happening on the original server which means SQL Server may not have the...

Once you've done everything that has been suggested. You should also set the size of tempdb accordingly so it does not need to autogrow. You may find...

I think you are looking for the undocumented xp_fileexist procedure. Here's a an article[/url] on it.

In this day and age, I'd recommend looking into a PowerShell solution for it,...

In both cases I'd set up a developer role or roles in SQL Server and assign developer accounts to those role(s) as needed. If possible I would use windows...

Since you are using a text parameter, how are you guaranteeing that the values entered in the test parameter are comma-delimited?

As Jason mentioned, I'd set up a profiler trace to...

Probably the easiest way is to use the ReportViewer control

SQL Kiwi (1/25/2012)

---

Well we have already met once in Boston, so I think it's only fair...

SQL Kiwi (1/24/2012)

---

Thanks! ...

Cool, I didn't even know I had made it to 10000. I was shooting for it, but not really tracking it.

Working 100% remotely now, I'd love it if the company provided a VM for me to load on...

Steve Jones - SSC Editor (1/23/2012)

---

Brandie Tarvin (1/23/2012)

---

WHEEHAW!

Delayed due to technical difficulties, Latchkeys is now out on Kindle. Here's the U.K. Kindle version and here's the U.S. Kindle version.

The...

Good article Wayne. One thing I like to see in articles like this though is how you might solve the same problem without using the new functions. Just...

Are you worried because you are a chicken?:-P

"I say, I say boy" - Foghorn Leghorn

Great question. You either have to look it up or have used the setting to know the answer. I got it wrong because I've never been in the...

I find this editorial interesting in light of what I've done since June. June to December I worked on a contract where I had a desktop at the office,...