| Author |
Topic |
|
andy.davids
Starting Member
4 Posts |
 Posted - 2008-08-28 : 07:33:19
|
| I am not a DB developer but I know there is a system stored proc that will return system info from SQL Server ( in XML ) such as server info, databases and info ( such as tables ... ) etc. I want to use this for documentation.I know the result set will probably quite large, however I am interested in the sp name.Can anyone help?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-28 : 08:23:51
|
| Yes there are lots system Procedure for that.You need to be specific what exactly you are looking for. |
 |
|
|
andy.davids
Starting Member
4 Posts |
Posted - 2008-08-28 : 08:28:31
|
| Cheers. I know there are lots, but the DBA I used to work with used 1 which gave him ALL the info at server level, the db level down to at least tables and procs in each database. Unfortunately I never asked which sp he used, but this guy was a guru. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-28 : 08:31:05
|
| You still didn't answer what are you looking for. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-28 : 08:33:06
|
| sp_databasessp_helpsp_tablessp_columns 'table name'MadhivananFailing to plan is Planning to fail |
|
|
|
andy.davids
Starting Member
4 Posts |
Posted - 2008-08-28 : 08:42:47
|
| Sorry, but this not what I am looking for. Like I say it is one proc that you will return whole server config as XML, but it is definitely not sp_help, sp_database etc. Cheers though. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-28 : 09:16:51
|
| There is no System SP to give you all information.For Server:You can use:sp_configureReconfigureSp_Configure |
|
|
|
andy.davids
Starting Member
4 Posts |
Posted - 2008-08-28 : 09:23:20
|
| OK, like I said this guy was a guru, so it must be undocumented then. Oh well. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-28 : 09:26:53
|
| Yes he must be Guru of the Guru to get all information with 1 system Store proc. |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-08-28 : 17:49:59
|
| Chances are he wrote his own procedure to get the information he wanted. Review your procedures and see if anything looks like what you are expecting. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-28 : 18:09:39
|
quote:
Originally posted by tfountain
Chances are he wrote his own procedure to get the information he wanted. Review your procedures and see if anything looks like what you are expecting.
Then he wrote user store procedure... one 1 System SP to get all informations. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-28 : 18:29:28
|
quote:
Originally posted by sodeep
quote:
Originally posted by tfountain
Chances are he wrote his own procedure to get the information he wanted. Review your procedures and see if anything looks like what you are expecting.
Then he wrote user store procedure... one 1 System SP to get all informations.
Why did you repeat in different words what tfountain wrote? tfountain's post is much clearer.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-28 : 18:38:49
|
| Because I want to. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-28 : 18:58:08
|
| It's funny that you did that as you complain in other threads that other people are repeating what was already said. We all need to watch our forum etiquette.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-08-29 : 09:37:52
|
And he also quoted me... I dunno... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-29 : 09:42:54
|
I think sodeep want to have a top position whenever Graz decides to have a new competition.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
System Info