Viewing 15 posts - 6,451 through 6,465 (of 9,725 total)
SQL is assuming the _1 is forcing a trace number. Remove it.
exec @rc = sp_trace_create @TraceID output, 0, N'\\servername\D$\Folder\Trace_1', @maxfilesize, NULL, @filecount
Should be
exec @rc = sp_trace_create @TraceID output, 0, N'\\servername\D$\Folder\Trace',...
February 16, 2011 at 12:15 pm
The best way to deal with this issue is to work with the people who own the automated files.
Here's what I would ask for:
1) Keep the # of...
February 16, 2011 at 12:13 pm
GAH. Got the name of the antho wrong. A Career Guide to Your Job in Hell, not "from Hell."
Sorry, folks.
February 16, 2011 at 12:06 pm
Not to take away from Grant's book, but if you need information fast, Google "SQL Server Performance Tuning." There are literally hundreds of articles out there. Or search this site,...
February 16, 2011 at 12:03 pm
What response are you getting that is telling you you can't create RollOver files? Post the exact error message (type or cut-n-paste) please.
February 16, 2011 at 11:59 am
So you have a file with multiple, repeatable column headers. How is this file generated? Is it automated or does a person fill in the sheet?
EDIT: If automated, what sort...
February 16, 2011 at 10:46 am
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
Viewing 15 posts - 6,451 through 6,465 (of 9,725 total)