Great Article Craig

This helps a lot seeing from a wide view what really i enjoy regarding databases.

Keep up the good work!

OK for anyone that enters thhis topic, i entered this link:

http://sqlserver2000.databases.aspfaq.com/how-do-i-audit-changes-to-sql-server-data.html

and used some recommendations from there.

im still missing the proceess that changes the data, but i got some useful...

Thanks for the fast answer, the function worked and it gives me the name of the process.

i was trying to get the name of the process modifying the table, but...

Is correct, i didn't thought on that, but thats a real condition to not to move into a SP, we left the trigger because the proces time is shorter, but...

Thanks for the fast replys, i used both suggestions and both worked,

the diference is that sp_helptext gives me rows with fragments of code, and those look like a wall...

stuff ?

pls dont tell me theres a function called "Something" or another function called "AllINeedToGetTheJobDone"

Select AllINeedToGetTheJobDone('Im lazy') from PolimorficTableThatKnowsEverything

XD

i really laughed with the name of the function. learned...

Yeah u need help!

oh wait...

for what do u need help?

Oh then that was the trick, thanks alot for the explanation :w00t:

i also checked the link of your post and it was helpful too, now im curious about for...

Hi shane,

Im not an expert or so, but for the answer your looking, this is not the correct forum, u should try posting this on a Java or general programming...

Excellent, exactly what i need , thanks :w00t:

Sorry i forgot to mention those details. Just in case in the future somebody enter this thread. u need to run this code to enable ad.hoc distributed queries...

Thanks for your response lowell.

I used the sample u posted in a little rutine and it worked then i adapted my trigger at the same form.

and worked too. But in...

Oh you're right!

didn't know that implicit work of sql.

another new thing learned today.

Thanks a lot :w00t::w00t:

ahahahah

Hell yeah, for a simple execution for a single Store my old proc takes 14 seconds,

Your Proc takes 2 seconds ¬¬, plus less code XD.

excellent improvment 😀

:w00t:

Dude now that im in the work PC, im testing the procedure, and i dont know if i should feel bad or good D:

I still got a lot...