Hi Steve,

You are right. It is the worst but that is going to be done at a later date as per the project priority.

Hi Robert,

Well my problem is, the app uses "sa" as the id to connect to the db. All the security process is taken care of in the application. Therefore...

This is a check list which I would have to make sure if I come across something like this

1) Check to make sure that table has the trigger for...

Steve,

You are right! I wish I could do that...

Well I am going to tell it to my customers and basically tell them the downside...

Hi Deuce,

Well not really.. Because my app connects all users as the same SQL login after I do the intial security check using a lot of group hierarchy...

Steve/Andy

If I understand it right the unique name will be user_name + host_name right? Now I dont understand your reasoning behind the combination to be unique. Could you please...

Thanks Steve!! I was a little frustrated basically venting out..

It is int identity and not identity int. I dont understand why the datatype is called identity int when you got to define as int identity. Oh well..

Steve,

I am going to go with the host_name(). That sounds like what I wanted..

Thanks

Steve/Deuce

So what do you think is the best way of getting an unique number/id/name so that I can identify that that box was used for this trigger to fire. Thats...

Guys,

Thanks for your time. The problem was I had another trigger on the same table which was redundant. I deleted the old trigger and everything is hip.

Thanks Steve

Here it is.. thanks

drop trigger tr_req

go

create trigger tr_req on req for update

as

declare @table varchar(128),@col varchar(128),@old_value varchar(100),@new_value varchar(100),@last_upd_date datetime,@doc_type varchar(20),@col_name varchar(100)

select @table = 'req'

set nocount on

select @last_upd_date = getdate()

select...

Thanks I got it

select @S = 'select @col_name = '''+@col+''''

Also got another quick question about the same thing. If I want to print the @col which is a variable itself how can I get it?

I have @col dynamically assigned...

Thanks Brian! So is two single quote equal 1 single quote. Is that why we need

SET @S = 'SELECT @table = ''abc'' '

Thanks again