Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

usp_who5 Expand / Collapse
Author
Message
Posted Thursday, September 1, 2011 3:31 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 360, Visits: 720
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
Posted Tuesday, March 20, 2012 1:09 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 360, Visits: 720
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
Posted Tuesday, March 20, 2012 1:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 26, 2014 6:09 AM
Points: 5, Visits: 42
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
Posted Tuesday, March 20, 2012 2:04 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 360, Visits: 720
Location of where to find the procedure?
Post #1269846
Posted Tuesday, March 20, 2012 3:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 26, 2014 6:09 AM
Points: 5, Visits: 42
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
Posted Tuesday, March 20, 2012 3:51 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 360, Visits: 720
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
Posted Thursday, March 29, 2012 1:29 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 360, Visits: 720
The latest changes are now online!
Post #1275342
Posted Wednesday, April 4, 2012 5:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 12, 2014 10:26 AM
Points: 4, Visits: 281
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
Posted Wednesday, April 4, 2012 7:57 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 360, Visits: 720
Are you able to isolate the SPID throwing the error? If yes, are you able to identify the column in question?
Post #1278518
Posted Thursday, April 5, 2012 1:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 12, 2014 10:26 AM
Points: 4, Visits: 281
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 »

Add to briefcase ««123»»

Permissions Expand / Collapse