x

OS info through sql-server

how to see Operating System information through Sql-Server

more ▼

asked Aug 24, 2010 at 12:27 AM in Default

avatar image

Murali
906 109 119 123

What type of information... version/edition, wmi, directory information etc?

Aug 24, 2010 at 12:37 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

If you want OS specific information like build numbers, h/w etc you can try...

 EXEC master..xp_cmdshell 'systeminfo' 

OR

 select @@VERSION


For OS wmi Jason Massie has a few excellent articles.. blog

more ▼

answered Aug 24, 2010 at 12:49 AM

avatar image

sp_lock
10.8k 27 37 37

Thank you very much

Aug 24, 2010 at 12:51 AM Murali
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1095

asked: Aug 24, 2010 at 12:27 AM

Seen: 488 times

Last Updated: Aug 24, 2010 at 12:27 AM

Copyright 2018 Redgate Software. Privacy Policy