TY So much.

Thank you for the reply,So you are saying to not to use scalar functions in the column list?

Is it good or bad to use?

Thank you Eric, But didn't came nay results.

showing object name as delPersons ....I see only this.

Is there any way that they are handling this audit data from some where I...

Yes,Exactly.

So when I am doing a flow diagram when first part of data flow task is done do I need to connect arrow from destination to data flow task 1...

There is precedence constraint between two data flow tasks.

Once first data flow task is finished transferring data from source to target its coming to second data flow task.

TY Champion,

These variables we...

In @pay we are getting max id from payfecon table where status is f.

and we get cycdate from payfecon where id is the @pay that we got maxid form...

Hello Insane,

I understand, these...

I didnt understood..

My main idea is to capture login id in the audit data table..Here is my trigger is there any function to capture the logged in user id....if its...

Sorry,i edited the topic..

Hi SSSCrazy,

I have another problem with Desc column.Desc which are going to...

Thank you so much for your valuable time and for information....

Thank you SSSCrazy.

I modified now plz look into it.

so you are saying no need to pass the paramters right?by using these two tables we are joining am i right?

ALTER TRIGGER...

I checked the object property its enabled..is there any work around with proceedure?

Instead of trigger i am planning to write a procedure which we can run using job which will...

Hi ,

how to check the object propert function?