Post reply

fn_get_sql - Not returning the full SQL statement

  • August 25, 2003 at 12:43 pm

    #159767

    I am attempting to use the fn_get_sql function within SQL 2000 SP3a. I can get it to return the SQL statements executing but it is truncating them. BOL states that this function is to be used any time your SQL is longer that 255 characters but I can not seem to get the function to return more that 267 characters.

    Has anyone seen this issue? There isn't a whole lot of documentation out there on this one so any help would be of value.

    Thanks!

  • August 25, 2003 at 1:11 pm

    #471300

    Just to verify (the braindead because I've worked too many hours check)...

    Your max characters per column (Tools | Options | Results tab) is set > 267, right?

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • August 25, 2003 at 1:26 pm

    #471302

    OUCH...plagued by the "to many hours" syndrome. That fixed it.

    Thanks for the help!

Viewing 3 posts - 1 through 2 (of 2 total)

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