var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: last tsql command
hi, how can i obtain the info of the last tsql command executed?, in the table sysprocess i only have the number of spid
thanks so much
...have you tried double-clicking the spid in Enterprise Manager->Management->Current Activity->Process Info?
...might give you what you're looking for...
last tsql command
hi, yes, but sql save it in someplace? i need to extract it to a table
Not that I'm aware of, you'd have to run profiler to capture the sql (even then I am not sure you can save it to a table...)
Yes you can though MS recommend you write to a trace file and insert this into a table when you want to analyse. More efficient to write to a file at trace time basically.
Originally Posted by rocket39
ur codings are working excelent.
@Mvrg76: Why have you opened a new thread???