Viewing 15 posts - 2,386 through 2,400 (of 9,725 total)
Shawn Melton (8/23/2015)
August 24, 2015 at 6:22 am
I will add some others later, but here's one I frequently use for our non-prod environments.
SELECT TOP 10 *
FROM msdb.dbo.restorehistory
WHERE destination_database_name = 'MyDatabase'
ORDER BY restore_date DESC;
--check the last time a...
August 24, 2015 at 5:53 am
Steve Jones - SSC Editor (8/21/2015)
August 21, 2015 at 7:57 am
Phil Parkin (8/21/2015)
and sjh.run_date >= (year(getdate() - 1) * 10000 + month(getdate() - 1) * 100 + day(getdate() -...
August 21, 2015 at 6:01 am
Brandie Tarvin (8/20/2015)
August 21, 2015 at 5:58 am
Sean Lange (8/20/2015)
Luis Cazares (8/20/2015)
Lynn Pettis (8/19/2015)
August 21, 2015 at 4:47 am
Arjun SreeVastsva (8/20/2015)
ThanksI want to show the failed jobs step I'd in the result set.
How to add this to my script
Did you create this script or did someone else? EDIT:...
August 21, 2015 at 4:13 am
I don't know about 2012, but in 2008 something would be wrong if the mirrored dbs aren't showing in sys.databases. I have 4 mirrored DBs in 2008 that do show...
August 20, 2015 at 8:05 am
Jack Corbett (8/19/2015)
Sean Lange (8/19/2015)
Luis Cazares (8/19/2015)
Sean Lange (8/19/2015)
August 19, 2015 at 12:13 pm
Sean Lange (8/19/2015)
August 19, 2015 at 12:12 pm
Alvin Ramard (8/17/2015)
I hope the OP wasn't serious!!!! :w00t:http://www.sqlservercentral.com/Forums/Topic1712315-2799-1.aspx
You are WRONG, Sir! Case has absolutely EVERYTHING to do with the way things work. If we didn't have all caps,...
August 17, 2015 at 10:46 am
If you want to get technical about it, then case might have a performance issue. In the terms that if you are using case-sensitive collations and you don't call your...
August 17, 2015 at 10:45 am
I don't know anything about England or the state of employment there. If you can find a lot of good short-term contracts, then your plan sounds like a good one....
August 17, 2015 at 10:16 am
Jack Corbett (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.😎
But you didn't do it MY way...
August 14, 2015 at 12:18 pm
psingla (8/14/2015)
Brandie Tarvin (8/14/2015)
psingla (8/13/2015)
following is the link of the discussion that I had with Arthur on MSDN forum
It appears from the above thread that this may not be solveable...
August 14, 2015 at 5:49 am
Viewing 15 posts - 2,386 through 2,400 (of 9,725 total)