Skip to content

Instantly share code, notes, and snippets.

@TheRockStarDBA

TheRockStarDBA/GetDBNameAndPhyscDeviceName.sql

Created July 9, 2015 14:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save TheRockStarDBA/c2928c11fdd23184b511 to your computer and use it in GitHub Desktop.
Save TheRockStarDBA/c2928c11fdd23184b511 to your computer and use it in GitHub Desktop.
Download ZIP
Map a databaseName with a physical device name SybaseASE
Raw
GetDBNameAndPhyscDeviceName.sql
-- 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