True in both cases. Thanks for the feedback, Sam.

Cast the output as VARCHAR(DesiredColumnWidthHere).

Scope_Identity() will be null until you actually do an INSERT.

If the DBID for those locks is "2"... don't worry about it... that's TempDB.

Mick Dugan (2/13/2009)

---

This is pretty neat, but what I've REALLY been looking for for ages is the ability to pass an entire .Net dataset to a proc. Of course,...

All of the xp/sp's kinda suck for the amount of information they give... try this...

CREATE PROCEDURE dbo.GetDirDetails

/**************************************************************************************************

Purpose:

Replacement code for the sp_GetFileDetails proc that was available in SQL Server...

Your example result line has no date on it and, maybe I'm being a bit thick, but I can't actually figure out what you want from your description. It...

Not sure how I missed this when it was first published... very well done!

"two users running...."

Running WHAT?

Lookup troubleshooting deadlocks in Books Online for a wealth of information on the subject... making shorter batches is just the start.

Jeff Moden (2/13/2009)

---

I agree with Lowell... otherwise, you'd have to resort to some nasty trickery like MAX or a sequence table and both will cause a world of hurt.

And since,...

I agree with Lowell... otherwise, you'd have to resort to some nasty trickery like MAX or a sequence table and both will cause a world of hurt.

Chinesinho (2/13/2009)

---

So here's the problem I'm facing - I'm running an extended stored procedure from a third party vendor, and I want to be able to capture the text (by...

This will do it...

http://www.sqlservercentral.com/articles/Video/65070/

Heh... I have a hard time with a bank executive of a bank in trouble getting 500G to begin with. I'm with Rudy... "Pork chops awaaaaaaayyyyy!"

Note possible using Bulk Insert alone. Is possible if you use a calculated column on the target table and, maybe, a bcp format file... but a simple post-import update...