Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-06-30 : 09:18:44
|
| I would like to get a few fields out of sp_helpdbFor example I would like to have a query something like:select size, growth from sp_helpdb databasename for data file and transaction log fileHow can this be done please?Thanks |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-06-30 : 09:34:04
|
| u can insert the output of sp_helpdb into a temp table (#) and then query the required fields on desired condition |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2008-07-01 : 04:44:28
|
| Not sure how do do this because sp_helpdb databasename returns two tables and not one.Thanks |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-07-01 : 09:38:33
|
you can't use insert/exec with procs that return more than one result set. one option is to look at the code for sp_helpdb and write your own proc that *does* return only a single result set. then you can use insert/exec with that new proc.
elsasoft.org |
|
|
|
|
|
|
DB details