is there?

Is any more function available in KATMAI, to know the OS version of the DB server ?

How about xp_msver? -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi ""Select 'Siva'"@.discussions.microsoft.com" <"=?UTF-8?B?U2VsZWN0ICdTaXZhJw==?="@.discussions.microsoft.com> wrote in message news:322b3b89-0f96-4d93-8c16-7b9a6c6feb1c_WBRev1_@.discussions.microsoft.com... > This post has been edited either by the author or a moderator in the > Microsoft Forums: http://forums.microsoft.com > > > Is any more function available in KATMAI, to know the OS version of the > DB server ? > >|||

Fine,

But In this extended sp, there is no detailed information available like "Windows professional 2003 sp2".

That's wat am asked?

|||

You can use the @.@.VERSION function to get the version, processor architecture, build date, and operating system for the current installation of SQL Server.