Viewing 15 posts - 196 through 210 (of 254 total)
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...
March 20, 2012 at 3:51 pm
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)
...
March 20, 2012 at 1:09 pm
I am having the same issue...
January 31, 2012 at 6:34 am
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...
January 27, 2012 at 7:36 am
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...
September 1, 2011 at 3:31 pm
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...
August 16, 2011 at 12:18 pm
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...
April 14, 2011 at 6:06 am
LOL! I've seen the same thing!! When I show them how to properly use the table they're like, "Oh... OOOOHHHH!"
January 13, 2011 at 9:45 am
Ah yes! I had forgotten about this script. Thanks Thordog!
January 13, 2011 at 8:27 am
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...
January 13, 2011 at 7:01 am
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...
November 19, 2010 at 2:34 pm
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...
November 4, 2010 at 3:21 pm
Viewing 15 posts - 196 through 210 (of 254 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy