--This code affects all the records inserted into books with the same uniqueidentifier

CREATE TRIGGER tr1 ON Books AFTER INSERT AS

UPDATE Books

SET batchUID = NEWID() --batchUID being a uniqueidentifier field

FROM...

correct...no recursive triggers (which is default for SQL Server). The first trigger assigns the same GUID to each record in the insert. So the author of usp_Process has...

Hey everyone, I haven't posted in a while, so I thought I'd chime in on a good one like this. I've used alot of the suggestions in the past...

http://www.google.com

you wouldn't be able to access the file at all if that were the case (I could be wrong)

you also may want to go to "save-as" and save the DTS...

maybe a DNS problem? try using ip addresses instead of named pipes temporarily.

can you open the dts from the server? what type of connection is it? sql/windows nt?

if you addressed any of the connections as (local), and you do not have the same database on your local computer, it will not show. The solution would be...

"Answers that require my time for research will be fee based. Either way, I am always happy to help."

Aren't we all?

Thanks again, Mel!

-KM

Thank you Mel! I forwarded this post back my manager.

I should have waited before I spoke, but I think I alieviated the problem in one place and it is still in another.

All I have done so far is the...

Jeff,

Just when you thought you knew how to develop a database, this is thrown at you. I wonder why this is not more common knowledge. If I were...

Thank you Jeff,

Sounds like you had heck of a time cleaning up.

I started putting NOLOCK and ROWLOCK where I thought applicable. So far no deadlocks this morning. ...

Thank you Mike, I guess my question was more geared to binding forms and how an updatable snapshot can affect deadlocks. And if it does a table lock or...

if your numbers are in sequence...

select *

from table

where fld between @start AND @end