August 25, 2003 at 12:43 pm
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
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
K. Brian Kelley
@kbriankelley
August 25, 2003 at 1:26 pm
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