Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @dbs table
- (
- name varchar(200),
- [size] varchar(20),
- owner varchar(50),
- dbid int,
- created datetime,
- status varchar(4000),
- compat int
- )
- insert into @dbs exec sp_helpdb
- select name,
- substring(size, 1, len(size) - 3) as size
- from @dbs
- order by
- name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement