Viewing 15 posts - 34,936 through 34,950 (of 49,552 total)
support 79032 (1/6/2010)
January 6, 2010 at 8:48 am
laddu4700 (1/6/2010)
In SQL is there any way to perform database log audit?
Plenty of ways. Depends what you want to log, how you want the info stored, etc.
I suggest you hit...
January 6, 2010 at 8:31 am
Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Might be parameter sniffing.
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
January 6, 2010 at 8:14 am
Steve Jones - Editor (1/6/2010)
I see The Thread is alive and well. Happy 2010 to everyone.
And to you Steve. Welcome back.
January 6, 2010 at 8:11 am
kareem007 (1/6/2010)
How to protect the database transaction logs from alteration and deletion.
The transaction logs cannot be altered, trying to do so will render the database suspect. Deleting them will often...
January 6, 2010 at 8:11 am
Your backup is damaged or there's an IO problem with the SAN. You can try to use CONTINUE_AFTER_ERROR, but do note that if you do so, some of the database...
January 6, 2010 at 8:05 am
Manic Star (1/6/2010)
Except for some locker room behavior at a few clients, I've not noticed any serious discrimination in my 20 years in the business.
Same here. Worst I've had...
January 6, 2010 at 8:05 am
GSquared (1/6/2010)
If you can't access it, try Tarot cards to figure out the password.
I have a set, if you need me to do a reading.
January 6, 2010 at 7:25 am
GDI Lord (1/6/2010)
Can a restore change collations like this? I wouldn't think so, but...
Shouldn't be able to. A restore recreates the database as it was at the point it was...
January 6, 2010 at 7:17 am
Please rather post new questions in a new thread. Often people won't look at threads with lots of answers, assuming they are resolved.
In a new thread, please post the full...
January 6, 2010 at 7:14 am
david_wendelken (1/6/2010)
January 6, 2010 at 7:09 am
barriorm (1/6/2010)
I have to disagree with the kind person who said that most women's professional women's organizations are 'pity parties'.
I said no such thing. If you're going to quote...
January 6, 2010 at 4:35 am
Then you need to investigate why the replication isn't working. That's what's causing the log to grow.
Does DBCC OPENTRAN say anything about replication?
January 6, 2010 at 3:21 am
pmathewson (1/6/2010)
I am fairly new to SQL have always done server, hardware and network support .
No senior DBA there?
Should I back up all transaction logs aswell with or without truncate?
Please...
January 6, 2010 at 2:49 am
Viewing 15 posts - 34,936 through 34,950 (of 49,552 total)