Put the database in the emergency mode,

then use sp_resetstatus to change the status flag on the database..and then restore the database from the backup...

..hema

I want to know whether there is any

predefined system stored procedure for finding the same and thanx for the reply...

..hema

If the transaction log contains committed transactions and u need more space for lot

 of active transactions then u can truncate the

log without backing up.

..hema

you can use the following system stored procedure :

sp_depends 'objectname'

You will get all the objects which depend on that object.Hope it will be useful to u...

..hema

You forgot to give and 'end ' at the end of the transaction.

There are three 'begin'  statements but only two 'ends'

try this.....

declare @Balance money

begin transaction

......................

........................

if @Balance...

May be the log is full....

..hema

I think we can do it maually..

..hema

check whether the SQL Server and Agent are in the same domain account are not..

..hema

Can you specify the primary key of the parent table.

I guess the column in the child table is not accepting any nulls.

..hema

And one more question:

when the master database is full, will the sql server stop running? Plz clarify this.....

..hema

 Mr Lahkani,

 We know that when sql server is started it uses three files:

1) master.mdf file

2)master.ldf file

3)error log file

But as master is full, Can it use the files of the master...

Hi,

You divide that table into two tables and establish one-one relationship between those

two tables...

..hema

I think detaching and attaching will be better and it is faster..

..hema

Datafiles(.mdf) and logfiles(.ldf) should not be

kept on a single disk,bcoz if the disk crashes

you will not be able to recover the database upto the point of time..

..hema

Thanx for the help..but I want to know how to

restart the sql server when the master database

is full..

...hema