I don't want to lock the whole table for a record insert. The tables are frequently used. It definitely will be hit by multiple user at the same time. I...

I don't want to use auto number, so when I do the insert, I will need to get the next ID column first. Is there some technic I can use...

I probably did not state the question clear. Please take a look at this article. Thanks!

http://www.techrepublic.com/article_guest.jhtml?id=r00520030606sob01.htm&page=1

what if I have more than one directory have spaces? Any idea? Not trying to be difficult, that is the real problem. Thanks!

That works for space in path, but I just realize new problem. I need to use a variable in the xp_cmdshell, something like the following:

declare @filename varchar(50)

DECLARE @cmd varchar(100)

set @filename...