Viewing 15 posts - 2,071 through 2,085 (of 2,732 total)
andrew gothard (4/23/2014)
jasona.work (4/23/2014)
April 23, 2014 at 7:20 am
Gary, I think if MS open-sourced the MCM questions and scenarios, you'd fairly quickly find people using them as templates to create new questions and scenarios for newer versions of...
April 23, 2014 at 4:44 am
The carnage!!
That looks like he was trying to practice his Norman Bates / Jason Voorhees routine...
:hehe:
April 22, 2014 at 4:40 am
Bouke Bruinsma (4/21/2014)
Essentially, when you install a second instance of SQL, it's (almost) completely stand-alone. Both instances will have their own TEMPDB, Master, MSDB, and Model databases, each instance will...
April 21, 2014 at 6:03 am
I can't speak to *why* your application may be having issues with TEMPDB, but I can make a few comments about why having a second instance would avoid the problems.
Essentially,...
April 21, 2014 at 5:18 am
Cool, thanks!
And yes, I should've mentioned the DB is in Simple recovery.
April 18, 2014 at 7:56 am
OK, just started in on the Google thread, and think I see why this isn't working. Not sure I'm going to be able to get it to work, not...
April 10, 2014 at 11:15 am
OK, I think that might be the problem. Although I tried with my domain account as the "execute as" user, and it did the same thing. My account...
April 10, 2014 at 11:06 am
Hmmm.
The issue I'm running into is, it's only executing the sp_msforeachdb once.
Maybe different versions of SQL?
Me: SQL 2008 R2 SP2
April 10, 2014 at 9:28 am
I meant to post this much earlier, but the network at work gets flaky sometimes...
Here's the query I was using to create the SP (scrubbed the user name, and skipping...
April 9, 2014 at 7:19 pm
Sean Lange (4/9/2014)
jasona.work (4/9/2014)
Find out from your wife that sometime between...
April 9, 2014 at 8:28 am
How to have a day go from "going OK" to "I'm almost unable to see straight I'm so ticked off."
Find out from your wife that sometime between you leaving for...
April 9, 2014 at 8:10 am
And lo and behold, I do a little more googling on creating such a trigger (and again, thanks to Gail for putting me on the right track) and I find...
April 8, 2014 at 6:42 am
Thanks Gail, looks like that's going to be what I'm looking for!
April 8, 2014 at 6:36 am
SQLRNNR (4/1/2014)
jasona.work (4/1/2014)
SQLRNNR (4/1/2014)
Ed Wagner (4/1/2014)
Lynn Pettis (4/1/2014)
jasona.work (4/1/2014)
...OK, old man rant off (crap, 44 is just 3.5 weeks away!)
You're not old!
Personally, I really hope you're not old at 44....
April 1, 2014 at 10:16 am
Viewing 15 posts - 2,071 through 2,085 (of 2,732 total)