<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Sean Smith
»
usp_who5
21 posts, Page 2 of 3
««
1
2
3
»»
usp_who5
Rate Topic
Display Mode
Topic Options
Author
Message
Sean Smith-776614
Sean Smith-776614
Posted Thursday, September 01, 2011 3:31 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
Ah, yes. I think I know why. There's a setting in SSMS (buried somewhere, I can never remember the exact spot) where you can set the text output limit. In SQL Server 2005 I think it's either under
Tools -> Options -> Query Results -> Results to Text:
Maximum number of characters displayed in each column
(I have mine set to 8192)... or it's the
Tools -> Options -> Query Execution -> SQL Server -> General:
SET TEXT SIZE
(I have this set to 2147483647).
In 2008 I think it may be buried somewhere else in the options, perhaps even named differently.
Let me know if any of that helps and if not I will get on to a 2008 box as soon as I can and test it out.
Post #1168956
Sean Smith-776614
Sean Smith-776614
Posted Tuesday, March 20, 2012 1:09 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
New features coming soon (just as soon as the folks at SSC.com approve the code changes):
Rewrote Time Calculation Logic (output now DAYS HH:MM:SS)
Added Fields To Output:
"SQL_Statement_Current"
"End_Of_Batch"
"Plan_Cache_Object_Type"
"Plan_Object_Type"
"Plan_Times_Used"
"Plan_Size_MB"
Expanded "Running" Type Indicators
Added System Reserved SPID Indicator To "SPECID"
Added "C" Type "@v_Filter" Option
Merged "I?" And "O?" Help Parameters Into "?"
Changed Help Output From RAISERROR To PRINT
Renamed Input Variables
Post #1269808
Jim Dunn-363909
Jim Dunn-363909
Posted Tuesday, March 20, 2012 1:15 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, October 03, 2012 10:05 AM
Points: 5,
Visits: 39
I'm running SQL 2008 and can't locate where to find it, so if you could test on SQL2008, that would be great!
Post #1269812
Sean Smith-776614
Sean Smith-776614
Posted Tuesday, March 20, 2012 2:04 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
Location of where to find the procedure?
Post #1269846
Jim Dunn-363909
Jim Dunn-363909
Posted Tuesday, March 20, 2012 3:44 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, October 03, 2012 10:05 AM
Points: 5,
Visits: 39
No, sorry. Where to find how to change the text size on SQL2008 as your previous thread says you could look around on a SQL 2008 server....
Post #1269893
Sean Smith-776614
Sean Smith-776614
Posted Tuesday, March 20, 2012 3:51 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
Ah! Sorry, misunderstood. In SSMS, go to
Tools -> Options
. From there, select
Query Execution
and you should see
SET TEXTSIZE
. I have it set to 2147483647. The new code (once approved by SSC.com) should automatically set this during execution. :)
Post #1269895
Sean Smith-776614
Sean Smith-776614
Posted Thursday, March 29, 2012 1:29 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
The latest changes are now online!
Post #1275342
patelnikhil30-508910
patelnikhil30-508910
Posted Wednesday, April 04, 2012 5:17 PM
Forum Newbie
Group: General Forum Members
Last Login: Friday, May 17, 2013 1:22 PM
Points: 4,
Visits: 248
Thx for sharing the code,,
I am getting the below error
Msg 535, Level 16, State 0, Line 10
Difference of two datetime columns caused overflow at runtime.
Post #1278470
Sean Smith-776614
Sean Smith-776614
Posted Wednesday, April 04, 2012 7:57 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
Are you able to isolate the SPID throwing the error? If yes, are you able to identify the column in question?
Post #1278518
patelnikhil30-508910
patelnikhil30-508910
Posted Thursday, April 05, 2012 1:19 PM
Forum Newbie
Group: General Forum Members
Last Login: Friday, May 17, 2013 1:22 PM
Points: 4,
Visits: 248
now it works. seems it was one off issue.. but I will keep you posted.. thx and nice work ..
Post #1279108
« Prev Topic
|
Next Topic »
21 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
