Forum Replies Created

Viewing 15 posts - 196 through 210 (of 254 total)

  • RE: usp_who5

    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...

  • RE: usp_who5

    Location of where to find the procedure?

  • RE: usp_who5

    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)

    ...

  • RE: Tabs or Spaces

    Tabs all the way.

  • RE: System Proc sp_SysMon to monitor sql server health

    I am having the same issue...

  • RE: SQL Server System Report

    Some new changes coming very soon to this script! 🙂

    "Last Backup Set Details" Section Will Only Show Information For Databases Currently On The Instance

    Added "@v_Output_Mode" Input Parameter (you can select...

  • RE: usp_who5

    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...

  • RE: usp_who5

    The new code is live! 🙂

  • RE: usp_who5

    For anyone interested, I just submitted a new version of the proc (still awaiting approval from SQL Server Central though...). Recent changes:

    1. Minor Changes To Code Style

    2. Added "@v_Filter_Database_Name" Filter...

  • RE: Date Calendar

    That's probably just a bad on my side. I may have originally set the columns to INT in the CREATE TABLE statement then changed it to TINYINT and forgot to...

  • RE: Date Calendar

    LOL! I've seen the same thing!! When I show them how to properly use the table they're like, "Oh... OOOOHHHH!"

  • RE: Date Calendar

    Ah yes! I had forgotten about this script. Thanks Thordog! 🙂

  • RE: Date Calendar

    Sorry, no. Life's been busy lately. Celebrating our first child. 🙂 It's on the "to do" list though (which seems to be getting longer each day!). 😉 I will post...

  • RE: SQL Server System Report

    Hmm... interesting issue. I haven't tried, but I may have taken the approach of writing the results out to a file (HTML tags included) into a text file, but name...

  • RE: SQL Server System Report

    I was thinking of doing that, but I noticed an "issue" with a one-to-many relationship for tables that were partitioned to I opted to leave it out for the first...

Viewing 15 posts - 196 through 210 (of 254 total)