I never had that issue. I would like to see the code you are using to call the sp.

Also varchar(50) for job name and table name is too short....

Darin Higgins (4/26/2011)

---

+1 on grant's comment. It's always bothered me that places that absolutely refuse a telecommute position, are more than happy, day 1 to hand over admin passwords, keys...

Grant Fritchey (4/26/2011)

---

nico van niekerk (4/26/2011)

---

One can understand that employers would be reluctant to allow someone with whom they have no trust-relationship to work at home. There are a multitude...

Impossible.

The best...

Did you actually run my script? It gives you the date you're going to runout of space on EACH drive on the server + the next autogrowth event.

Also it...

Jason Selburg (4/25/2011)

---

It is a question of semantics. You are guaranteed to have ANY of those values and NONE of them at the same time. There is no guarantee, and...

GilaMonster (4/25/2011)

---

You, me, Jeff, Lowell, Tara (from SQLTeam)...

Jeff Moden (4/24/2011)

---

Syed Jahanzaib Bin hassan (4/24/2011)

---

Check this script if you have any problem or modification required then tell me

Did you read this statement in the end of my post

Regards,

Syed...

Here's how I tackle the problem. Read the backup history and using the logged...

wware (4/25/2011)

---

Interesting question. I had no problem with the semantics of the question or answer.

Wondering if anyone can think of a real world example where one might...

roger.plowman (4/25/2011)

---

Am I the only one who thinks "none of the above" is the correct response, because the script is so buggy it won't compile?

Unless I'm crazy you can't insert...

I've seen 300+ employees companies with a network admin I...

Or even simple option :

sp_helpindex 'TblName'

sp_help also has nice info.

David Burrows (4/25/2011)

---

Wow Gail! Not sure whether, as a developer, I should feel...

Echoing here... since you're talking about garanteed # of rows, none is the only possible answer.