Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Map a databaseName with a physical device name SybaseASE
-- Map a databaseName with a physical device name SybaseASE
select sda.name
,sde.name
,sde.phyname
from master..sysdatabases sda
,master..sysdevices sde
,master..sysusages su
where su.dbid = sda.dbid
and su.vdevno = sde.vdevno
and sda.name like '%temp%' --- CHANGE HERE with your database Name!
and sde.name not like 'tapedump%'
go
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.