Viewing 15 posts - 6,436 through 6,450 (of 9,707 total)
Jack Corbett (2/16/2011)
GSquared (2/16/2011)
GilaMonster (2/16/2011)
GSquared (2/16/2011)
I blame Wayne. Execution at noon.Who's noon?
No, Who's on first.
I don't know!
Third base!
February 16, 2011 at 8:50 am
You need to check out Gail's blog. She has a very interesting discussion on this one:
http://www.sqlservercentral.com/Forums/Topic415829-338-1.aspx
EDIT: Whoops. The first link was wrong.
http://sqlinthewild.co.za/index.php/2007/12/19/temp-tables-and-table-variables/%5B/url%5D
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/%5B/url%5D
February 16, 2011 at 8:22 am
Fal (2/16/2011)
D'OH!I knew I should've lurked longer. But no, I had to help someone! 😛
Steve.
Aw. It's okay. We won't tar and feather you for being helpful and posting...
February 16, 2011 at 6:50 am
GilaMonster (2/16/2011)
Brandie Tarvin (2/16/2011)
In fact, if the database is online and suspect, a restart might make the db completely unrecoverable.
Not quite.
Restarting SQL when there's a corrupt database could take...
February 16, 2011 at 6:10 am
Sorry. The spelling in your post confused me. All I could understand was "after you answer the question, try restarting."
February 16, 2011 at 5:39 am
Well, since someone broke the "no technical talk in The Thread" rule...
Guess what I discovered this morning? Severity 21 errors can be caused by full disk drives. Nothing's actually...
February 16, 2011 at 5:31 am
Marco V (2/16/2011)
and
before restoring backups.
you can always try if you got the possibility to restart SQL server and hoping it start...
February 16, 2011 at 5:28 am
sqldba_icon (2/15/2011)
In all these i do not see the place where you mentioned "sp_add_jobserver"?
He's referring to a step referenced in his BOL link (click on the word...
February 16, 2011 at 4:40 am
Jamie Longstreet-481950 (2/16/2011)
The brain sleeps when it runs out of energy. Often it is smarter than we are.
Yeah, and supposedly I just woke up from a good night's sleep....
February 16, 2011 at 4:37 am
sqldba_icon (2/15/2011)
simon-811452 (4/9/2010)
This definitely happens when disabling from the GUI (see previous post). The system SP runs another SP, sp_sqlagent_notify, which clears the cache for the job; again, see previous...
February 16, 2011 at 4:34 am
Daniel Bowlin (2/15/2011)
Congratulations on publication.
WOTD: Thanks. @=)
February 16, 2011 at 4:25 am
john.arnott (2/15/2011)
Jamie Longstreet-481950 (2/15/2011)
CONVERT(varchar(8),getdate(),112)='20110215'
because it is easy to remember and there are...
February 16, 2011 at 4:24 am
GilaMonster (2/15/2011)
Brandie Tarvin (2/15/2011)
February 16, 2011 at 4:20 am
The problem is, we don't know what the problem is. Both GUI and script should work. GUI is not working properly, however. So stick with the script or, as I...
February 16, 2011 at 4:17 am
Viewing 15 posts - 6,436 through 6,450 (of 9,707 total)