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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 windwos Version NTor 2000

Author  Topic 

xhostx
Constraint Violating Yak Guru

277 Posts

Posted - 2012-06-29 : 10:09:45
Hi

is there any way how to find out if the windows is NT or 2000 within the TSQL statements?

Thanks

--------------------------
Get rich or die trying
--------------------------

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-06-29 : 11:58:43
SELECT @@VERSIION gives you some information about the OS.
Go to Top of Page

xhostx
Constraint Violating Yak Guru

277 Posts

Posted - 2012-06-29 : 12:19:57
quote:
Originally posted by sunitabeck

SELECT @@VERSIION gives you some information about the OS.




Thank you sunitabeck. Works perfect.

--------------------------
Get rich or die trying
--------------------------
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-06-29 : 12:38:27
You are welcome. Glad it worked in spite of my typo
Go to Top of Page
   

- Advertisement -