data device question

[nyck]

Hello,

is there a command under isql that i can run that will tell me how much space is left available for use on a particular data device?

cheers

nick

 

[DotNetGnat]

If you execute sp_help from ISQL or SQL Advantage you will get a list of all the databases
and their sizes. If you want more details on a specific database then execute the same
command with the name of one of the databases as the parameter.

-DNG

 

[micha123]

sp_helpdb, you ment...

"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M.

 

[JMCraig]

Sybase Central gives a nicer display, IMHO...

John
Alpha-G Consulting, LLC

http://www.alphagconsulting.com