I want to take offline with connection exist.

thanks.

i want to know the 'state' of the databases.

Means online,offline,suspect.

where this information stored?

yes i checked .there is no 'state column in sysdatabases.'

Hi marcin gol,

can u pls provide the same query for sql2000.

thanks in advance.

thanks a lot.............

yes dbcc updateusage is not workedout.

my issue is stil not resolved.

sql version is 8.0

how to findout actual logspaceused.

for example a update command(update table set id=1) excuted by perticular spid,how to get that command.

thanks........

i am not getting complete command from dbcc inputbuffer.

thanks....

i got it...........

i ran the dbcc updateusge...............then it resolved..........

thanks................

i got it...........

i ran the dbcc updateusge...............then it resolved..........

thanks................

how to check exactly how much space of trn log is getting used?

why the log space used is showing as more than 100 %

any help pls.............