Post reply

why would 'create procedure' run?

  • February 29, 2008 at 7:32 am

    #783758

    It gets the sql_handle from sysprocesses and use fn_get_sql(sql_handle) to get the sql thats running.

  • February 29, 2008 at 7:46 am

    #783769

    fn_get_sql(sqlhandle) actually returns the text of the Stored Proc. So what you see is not recreating of stored proc. It is just showing the create script of the SP.

    -Roy

  • February 29, 2008 at 7:52 am

    #783775

    I found it inconsistent, it could return e.g. EXECUTE GetProductOptions 'LNX3252' at some time or 'CREATE PROCEDURE.....' other time.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply