Here s the INSERT stmt

INSERT INTO T1 SELECT 1

No, that was already cleared by Gail. I read his article which was really superb.

Next i went for shrinking the log file when i encountered the log full error.

I...

I have given all the steps in 1st Page.

And database is in Full Recovery Mode.

Hey Guys,

Dont catch me wrong. I read the article and it is really helpful for me in understanding how the database is going to come ONLINE after recovery phase.

But...

Thanks Greg!

Still am expecting few answers on my below comment

You can't shrink a log that's full because there's no space within the file to release to the OS.

I want...

Thank You Friend.

Sorry My Bad!!!

I should have posted this in Development Category.

Thank You.:-)

Can anybody help???

Hey,

That was very GOOD.

But how could i get the infomartion whether my IMPLICIT_TRANSACTIONS is ON / OFF??????

Can you give me any specific examples on "unusual activities"?

I need some clarity on this!!!!!!!

Don't take me wrong my friend, I was just curious.

Can you give me any specific examples on "unusual activities"?

I need some clarity on this!!!!!!!

Don't take me friend, I was just curious.

[highlight=#ffff11]You can't shrink a log that's full because there's no space within the file to release to the OS.[/highlight]

I want to add a point to the above statement.

When i run...

Hi Gail,

Now i understand the importance of the Log but than in what real time scenarios we go for shrinking???????

Hi Gail & Abhay,

I tested the above scenario's and is working perfectly.

While doing so i have few questions raised in my mind. Here is one regarding the Shrinking of Transaction...