If you want to get it all done in a batch file, check out xcacls.

http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/xcacls-o.asp

You want to make sure you have the most recent version.....I believe this is...

haha, it was small text....I'd recommend the magic of ctrl + scroll 😉

the way i did it was to set up a user or system DSN and then that should be available as a source to import data

Think i found it. I was doing an ExecuteNonQuery when i should have been doing ExecuteScalar in my aspx page. Thanks for the help guys!

Result from Query Analyzer is 1.

Sorry, @result was leftover from when i was going to use an output parameter. Haven't gotten around to cleaning the code up yet since...

that's the whole proc. Userid is unique via a constraint set on the column. The update works ok in either place, it's just that from the web it...

no, still no resolution

Ha! Excellent catch! I mis-typed my first message. The code is calling the sproc for the update. Sorry about the confusion.

Checked that. Not the case. Thanks though!

Here it is. I circumvented it by checking the table structure while creating the trigger and now it works fine. The audit trigger is one I found online...

Again, an IF statement in a CREATE TRIGGER statement is failing. The entire CREATE TRIGGER statement is being created/executed using EXEC. I believe the reason for failing ...

Agreed. Any help with the original ? then?

Yes, I am creating the trigger. So the EXEC is around the whole CREATE TRIGGER statement. I have an auditing trigger I use to audit column changes, and...

AWESOME! Thanks for the help!!!

This probably isn't exactly what you're looking for, but it's how i get around it.

In my stored proc. I use a variable to hold a newid() and use that for...