Awesome 🙂

Thank you. 🙂

Guess: There's enough free space in the data file, but not in the log

Gail, am sorry i didnt understand the above statement.

Infact my data file is having more space than...

I intentionally have'nt provided the commit stmt. I wanted to keep that as a open tran.

I was expecting the CKPT to do that for me. I was basically trying to...

Hi Ninja,

What all other possible scenario's when ldf grows beyond mdf file?

Any example??

He Thanks.

Thanks Pradeep.

Thanks Gail for sharing the information. 🙂

Hi,

There is a slight difference 🙂

using my implementation if i execute

exec usp_p1 'b1',null,null,null

-- output which is expected.

/*

b1p12001-01-01 00:00:00.0002002-01-01 00:00:00.000

*/

using ur implementation

exec usp_p1 'b1',null,null,null

-- no output. which is not...

resolved my self.

For the benefit of others. Hope this will be useful.

alter proc usp_p1

@branchcode varchar(10),

@promocode varchar(10),

@effdt datetime,

@exprdt datetime

as

begin

if (@branchcode is null and @promocode is...

Sure 🙂

Thank you very much for the help.

Thanks a lot 🙂

Thanks for the confirmation.

do we have the event notifications for sql 2008 apart from CDC(change data capture)?