• sqlusers (2/5/2010)


    Good Question. Thanks...

    But, can you tell me how to delete the "@Sql_str" string value without restarting the sql services?

    Did you mean something like that?

    Assign NULL value:

    select @Sql_str = null

    or balnk / empty string:

    select @Sql_str = ''

    Regards,

    Gennadiy