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,...

I assume I'm not the only one who sees no content (well really only the word "content") in the body of today's featured article Stairway to Server-side Tracing - Level...