Very nice....I figured it was something simple but you never know. Thanks again Lowell. Hopefully I can return the favor one day!

Lowell,

Thanks for the reply. I know what your talking about but the error I get is not about that. I didn't post exactly what I was writing in the...

I thought it might be a NULL issue but didn't explore it. Will do now. Thanks for the replies.

I found it.   I read a little about Using the Inserted and Deleted Tables in the BOL.

select @ID = ID from inserted

This works within the trigger.

Antarres686,

Yes I am using 2000. I'll tried that and I didn't get it to work. I'm trying to get the Identity (from the row that is being updated)  within the...

Thanks...I'll check out that link. I don't like having to move as fast as I can and hit the stop button so I don't return every freakin row in my...

Thanks for the reply again. I was just reading about dropping it in QA to run it mulitple times. I'll check out the BOL as well. Thanks again.

Sergiy,

Thanks for the reply. I've been tooling around with this a little this morning. If I run that query more than once it tells me that the object #Foo already...

Thanks much....I'm going to enforce the SSL connections. As far as EFS I'm going to apply that to the backup files at least.   20% is more than I'd like to lose...maybe I...

Yes I could install a Certificate......I could just generate a local one (we don't have a domain wide CA installed yet) but I am working on it so I can setup...

Thanks for the reply I'll check out that link. I'm assuming you can't do this but it's worth a shot.... I would like to create a domain user account add...

Thanks for the suggestions. I ended up writing a long If then Else statment. It works but I'll have to see if I can rework it using your syntax. Thank...

Thanks Michael....I'll check that out. 

Steve,

Thanks as usual for the reply. I guess we could use the webservice but I'm really sure what webservice your referring too (doh)?

I have an exsiting RS website set up that...

Thanks PW!  Actually my query does work. The problem I was having was I didn't specify the varchar size. It needed to be the same as the table. Thank you.