Viewing 15 posts - 1 through 15 (of 53 total)
November 19, 2012 at 10:14 pm
So accoriding to the above logic. I have to Deny View Any DB first. THen make the login owner of the DB. Then it will be not be able to...
September 7, 2012 at 2:13 pm
So is there no way to achieve it??
September 7, 2012 at 1:11 am
But Mu DB is alredy in simple recovery
August 10, 2012 at 1:11 pm
The problem is the DB is alredy in simple recovery mode. WHat can we do in that case?
August 10, 2012 at 12:40 pm
Thank you for the reply.
But I am using SQL serve 2008.
BACKUP LOG <DBNAME> WITH TRUNCATE_ONLY is no longer usable in 2008. I already tried that.
August 9, 2012 at 12:02 pm
Hi, Thanks for the reply.
I donot want the log file size to be reduced. I want to truncate the log file. When I run dbcc sqlperf(logspace) the log %...
August 9, 2012 at 12:31 am
OMG. You are Amazing. Thank you very much. You were a ton of help.
I was wondering when we run this does it query the current trace file. What I mean...
July 30, 2012 at 3:55 pm
Thank you for your responsese.
Yes, Indeed they are sys.database_principlas.
When it comes to expiration. They passwords are set to expire every 365 days. So it should not be a problem.
July 30, 2012 at 2:24 pm
It was more than helpful. Thank you.
July 15, 2012 at 1:36 pm
Really Thank you for the help.
But situation is like I have a OLEDB Destinattion and from the destination I have a Flat file destination to redirect the error rows....
July 14, 2012 at 5:06 pm
Oh yes It can be. I am sorry.
But I would like to know why a 'CREATE DATABASE' Statement cannot be a part of Transaction. At the same time what are...
May 24, 2012 at 9:19 am
Beautiful Book Cleared a lot of questions in my Mind. Thank you.
May 14, 2012 at 8:10 pm
I am waiting eagerly for this book. May I know when I can expect the release????
May 14, 2012 at 8:09 pm
THANK YOU VERY MUCH. That was very informative
April 1, 2012 at 5:11 pm