|
Posted by Simon Hayes on 10/01/58 11:27
laurenq uantrell wrote:
> This is the part I'm not sure how to write:
> "Loop thru this table and insert the DBCC inputbuffer result into
> another table"
>
I admit I didn't read your post in detail, but I suspect that
fn_get_sql() is what you're looking for - it's more useful than DBCC
INPUTBUFFER. See Books Online for more details; if it's not mentioned in
your current version of BOL then you should get the latest version from
here:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
But since Erland uses this function in the procedure that he mentioned,
you might well find it easier just to use that.
Simon
Navigation:
[Reply to this message]
|