SUser_Sname returns the user's login name. App_name returns the application that initiated the connection to SQL. In terms of the resource...

Um... That question makes absolutely no sense. Could you perhaps...

There seems to be an echo in...

Did you read the link that I and several other people posted?

Based on the sample data that you gave, what are the exact results that you want?

I would suggest you call Microsoft's customer support for this one. We don't have the tools or knowledge to interpret a stack dump

Hmmm.

http://www.sqlservercentral.com/Forums/Topic633720-338-1.aspx

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Please post the full error message, the exact version of SQL that you are on and what seems to cause the error.

Steve Jones - Editor (1/9/2009)

---

There's no downside to doing this. Change it during the day, set up backups every 15 minutes and keep track of the sizes. Set an outlook...

JPLeBlanc (1/9/2009)

---

I have attempted this, but who knows if i was doing it correctly or not, do you all know of any specific learning courses for the workflow editor? or...

crfenix (1/9/2009)

---

Thanks you all for your answers! My script will be executes on MANY servers and I think a couple of them are sql server 2000 so Try Catch is...

The inserted table will contain all the rows that were updated. There may be more than one, SQL doesn't have row triggers.

So, what you need is something like this

UPDATE tbl_Question1Answers...

Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic633463-8-1.aspx

JPLeBlanc (1/9/2009)

---

It looks and feels fairly simple but each time i do this i get an import error. It finds the data but from what i remember without doing...

There's no equivalent on SQL 2000.

On SQL 2000, check to make sure the log backups are running and check that there are no old open transactions or old unreplicated...