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.

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.