Are they printing it automatically, or does someone push a "Print button" of some sort? If automatically, how is it being sent to the printer (.NET call? Scheduled...

If it has to select the whole table, or most of it, it's going to have to lock the table anyway.

A Select statement by itself can't really cause a deadlock,...

I must be missing something.

I ran the create script as posted. I ran the populate script as posted. It looks like c. 5000 records in Temp_Cust, and a...

I'd use a T-SQL task for that, and just issue a backup command. The backup command can accept a variable for the database name, but you might need to...

The problem with oddball solutions like this one, using a tool in a way it's not intended/documented for, is that you then have to overdocument it yourself to explain, in...

I'm having trouble getting those scripts to copy-and-paste cleanly, because of their size. Think you could post them as .txt file attachments, instead of in the body of the...

Congrats!

And I love the recursive post!

Me too. You're welcome.

That makes sense.

Jeff, I just fielded a question where someone was asking about your Million Rows of Test Data thing. Still planning on writing that?

I avoid it unless I have a copy of Dev Edition licensed for that dev. You need an SQL Server license to legally install SSIS on a machine, and...

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

---

GSquared (1/12/2012)

---

At least half the time I answer, I didn't have the answer when I started. I read the question, go "I wonder how...

There are a number of ways to do it. Far as I know, Jeff is actually working on an article about them.

One of the easiest, if the tables are...

BIDS can run packages without SSIS installed, last I checked. Ran into that as a problem a while back, when I didn't realize that Workgroup Edition doesn't have SSIS...

Bex (1/12/2012)

---

Cadavre (1/12/2012)

---

I'm going to continue posting, reading and answering questions on this site for one simple reason: I learn as much if not more than those that I've helped....