Viewing 15 posts - 2,071 through 2,085 (of 2,729 total)
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
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. 😉
Personally I...
April 1, 2014 at 8:42 am
Grant Fritchey (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. 😉
Ditto....
April 1, 2014 at 7:06 am
Grant Fritchey (4/1/2014)
jasona.work (4/1/2014)
April 1, 2014 at 5:33 am
Viewing 15 posts - 2,071 through 2,085 (of 2,729 total)