Hi Friends,

Please help me out to get the procedure which gives me the name of all
databases created on any particular device.

For eg sp__devdb finseg1

Database Name
------------
Sample1
Sample2
--
--
Sample5

where 'finseg1' is the name of the device .

Here it indicated that database 'Sample1',Sample2 etc created on
finseg1 device

Regards

I think that you really mean "give me the name of any database which uses
any space on <particular device>". (It's common to distribute databases on
multiple devices although this depends upon the nature of your storage
hardware & software.)

Do you want just a simple list? Or an indicator of how many fragments (per
database) there are on <particular device>? With space & usage type per
fragment? Or a map of the device space - including unallocated space? The
last may depend upon naming conventions and your OS. I do this but the code
is only good for Solaris raw partitions without symbolic links.


"Lalit" <issues_sybase (AT) hotmail (DOT) com> wrote

issues_sybase (AT) hotmail (DOT) com (Lalit) wrote in message news:<7bcd3933.0312110344.7de729cc (AT) posting (DOT) google.com>...

select db_name(u.id)
from sysusages u, sysdevices d
where d.name = "fineseg1"
and sysusages.vstart between d.low and d.high

"Bret Halford" <bret (AT) sybase (DOT) com> wrote in message

(SNIP)news:34c88f2b.0312110629.4094fabf (AT) posting (DOT) google.com...

You may (or may not) want "select distinct ..." Also "master.dbo.sysusages
u, ..."

You do want "db_name (u.dbid)" and "and u.vstart ..."