http://msdn.microsoft.com/en-us/library/ms188228.aspx

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...

So is there no way to achieve it??

But Mu DB is alredy in simple recovery

The problem is the DB is alredy in simple recovery mode. WHat can we do in that case?

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.

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 %...

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...

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.

What...

It was more than helpful. Thank you.

Hello,

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....

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...

Beautiful Book Cleared a lot of questions in my Mind. Thank you.

I am waiting eagerly for this book. May I know when I can expect the release????

THANK YOU VERY MUCH. That was very informative