Hi experts,

I have similar error but different scenario...

I want to replicate a view that is created from tables from another server. Let say I have 3 servers, svrA, svrB and...

.

yes Jeff. you are right. I know i cant give SYSADMIN to some one else.. its just because the operators don't really have good understanding about sql. I grant this...

All right.. thanks Eric. I thinks that's why i cant query my table anymore.

Hi Lowell,

Hi Jef Moden,

Thanks for the reply...

What I am trying is to create a text file containing a message why the insert process failed. Here is a bit of the...

yes.its Logon trigger.

i was trying it for 2 days and it didnt work on my sql server. in my desperation i posted this thread. then, after i digging the internet,...

Ok..

many thanks to chiraq & markusB..

i found an article regarding my own question. is this really working ??? anyone has ever used this ?

http://www.eggheadcafe.com/software/aspnet/33464501/detecting-insert-update.aspx

so, there is no way to detect the updating event (just like detecting a button click in VB) in SQLServer ?