I got it. I gave the other user in the same PC administrative access to SQL Server via Windows Groups. Then logged on to windows using other user & was...

Paul

Users I meant custom users i.e. they can be salesman, buyer, seller, manager & not the users within the sql server.

I have a user created table where users is a...

yes. but once my job fails & restarts the tempdb table would not be available any more. moreover, global temp table may leave orphaned tables.

Thanks

unfortunately i cann't add another table to the database though this would help me run procedure in checkpoint.

i have to create transaction within a loop to delete user & send...

Well! good point. I will have to check with business to see if this is required for any other purposes.

Thanks

the below one just worked fine. I have to test the performance alone now.

col1 - primary key

col2 & col3 - Need not audit

col4 - nullable column

col5 - not nullable column

select...

Yes. Other than the key column we wouldn't need to add "or ((d.col5 <> i.col5) or (i.col5 is null) or (d.col5 is null))" to a column that is not nulllable...

this is a good query but would fail if there are NULL values in deleted. i think the below query would fix it. But, anyway I have to double check...

1. My Requirement is I have 26 columns in a table & we might add few more columns. Out of 26, two columns one column is in 6 position &...

For example, take my query:

insert dbo.audit_abc (col1,col2,col3,col4,col5,audittype)

select d.col1,d.col2,d.col2,d.col4,d.col5,

case

when i.col1 is null then 'delete'

else 'update'

end

from deleted d

left outer join inserted i

on d.col1 = i.col1

where col2<>col2

and col5<>col5

In this query except col3 &...

COLUMNS_UPDATED is not helpful. It requires lot of validation which would impact the performance. I want this to be validated at the query level.

if all columns except my two...

Matt, Jack, Thank you. The detailed answers are excellent & this explains me how to design our systems.

Thanks

RJ

My application directly accesses the database tables (application creates insert, update, select statements & executes against the database.) i.e. there is no stored procedure in between application & tables so...

Storing it in binary seems to be a good plan. but, i have to check with my project if this comply to what we are looking. anyway thanks y...

well, you have an option to store stored procedure or function encrypted in the database but would be visible only to certain users. is there some functions that allows in...