Viewing 15 posts - 2,371 through 2,385 (of 9,715 total)
Gazareth (8/26/2015)
But probably the most common: DELCARE left left left backspace left C 😛
Oh, yeah. I use that one quite often. But I don't think that's what Grant is looking...
August 26, 2015 at 7:10 am
Doing experiments this morning. I've got to update a table to fix data problems introduced by a bad file. So I'm in test and realize that Things Are Getting Complicated....
August 26, 2015 at 6:51 am
GilaMonster (8/25/2015)
djj (8/24/2015)
GilaMonster (8/24/2015)
August 25, 2015 at 5:02 am
Shawn, that is AWESOME. Thank you for checking that. I'll pass this along to our local team.
August 24, 2015 at 11:17 am
Grant Fritchey (8/24/2015)
I don't know. That's weird. But the site seems a little off today. A disturbance in the force perhaps.
It's as if a thousand bits cried out at once,...
August 24, 2015 at 8:50 am
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
Viewing 15 posts - 2,371 through 2,385 (of 9,715 total)