Database Sizes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by vinaykumar » Database Sizes

Database Sizes

Rate Topic

Display Mode

Topic Options

Author

Message

Danny Ocean

Posted Friday, February 06, 2009 5:46 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 6:38 AM
Points: 1,111, Visits: 1,232

Comments posted to this topic are about the item Database Sizes

Keep Learning - Keep Growing !!!
http://growwithsql.blogspot.in

Thanks
Vinay Kumar

Post #651532

Josep

Posted Friday, February 20, 2009 3:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:35 AM
Points: 139, Visits: 4,605

It would be nice to know the space used and the space available too...

Post #661170

Yenidai

Posted Monday, March 16, 2009 1:18 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 1:14 AM
Points: 334, Visits: 84

A condition in a where clause should be :

insert into #spacetemp (DBname,DBcreationDate,DBStatusid,DBStatus)
select [name],crdate, status,case
when status=1 then 'autoclose'
(....)
end
from master..sysdatabases where (status & 512 = 0) and dbid >case when @sysdb=1 then 0 else 4 end

To prevent crash on a offline databases.

Regards,
Yenidai

Post #676296

« Prev Topic | Next Topic »

Permissions