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 |
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
 Posted - 2009-04-22 : 09:30:39
|
| How to Get System Information from SQL Server???is there any store procedure or something like that from which we get to know the hardware configuration of our system.iF theRe iS a wAy iN tHen theRe iS a wAy oUt.. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-22 : 09:32:55
|
You can begin with SERVERPROPERTY function.And you can read from the registry.It would be somewhat easier if you provided some information about what configuration you want.You can use WMI.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-22 : 09:32:56
|
You can begin with SERVERPROPERTY function.And you can read from the registry.It would be somewhat easier if you provided some information about what configuration you want.You can use WMI.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-04-22 : 09:39:10
|
| Thanks....i want to know my hardware name as if my instance running on System name Ashu.than i get Ashu in resultmean i like to get Hardware Configuration of my Hardware on which my SQl is running like information about processor and something like that???Thanks in Advance...iF theRe iS a wAy iN tHen theRe iS a wAy oUt.. |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-04-22 : 09:55:15
|
| ohkk i got my PC name ... from SERVERPROPERTYselect serverproperty('ComputerNamePhysicalNetBIOS')Thanks for help....:)iF theRe iS a wAy iN tHen theRe iS a wAy oUt.. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-22 : 09:55:46
|
With SQL Server 2005, you have a lot of new DM views.SELECT *FROM sys.dm_os_sys_info
E 12°55'05.63"N 56°04'39.26" |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-04-22 : 10:03:17
|
| Yes thanks to u sir...iF theRe iS a wAy iN tHen theRe iS a wAy oUt.. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-04-22 : 10:27:43
|
| Also see if this helpsexec xp_msver MadhivananFailing to plan is Planning to fail |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-04-22 : 10:32:19
|
| Thanks ,, Sir,,,iF theRe iS a wAy iN tHen theRe iS a wAy oUt.. |
|
|
|
|
|
|
System Information