August 3, 2006 at 11:34 am
What are the system tables, system stored procedures and sytem functions if any can be used to know information about SQL Server Clusters?
August 4, 2006 at 11:09 am
system tables - none
stored procedures - again, I believe none
system functions - there may be one or two. check out BOL
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 5, 2006 at 6:01 am
Here are the system functions that may be usefull. As some SQL instances may be defined with a case sensitive collations, the column names are exact, such as NodeName, and must be specified with the exact upper and lower case.
Also, as the function serverproperty returns a sql_variant datatype, the below SQL casts into the base datatype.
select cast( serverproperty ('machinename') as nvarchar(128) ) as machinename
, NodeName
from ::fn_virtualservernodes()
select cast( serverproperty ('machinename') as nvarchar(128) ) as machinename
, cast( serverproperty ('servername') as nvarchar(128) ) as servername
, coalesce ( cast( serverproperty ('instancename') as nvarchar(128) ) , 'default') as instancename
, cast( serverproperty ('productversion') as nvarchar(128) ) as productversion
, cast( serverproperty ('productlevel') as nvarchar(128) ) as productlevel
, cast( serverproperty ('collation') as nvarchar(128) ) as collation
, cast( serverproperty ('edition') as nvarchar(128) ) as edition
, case serverproperty ('isclustered') when 1 then 'true' else 'false' end as clusteredind
, case serverproperty ('isfulltextinstalled') when 1 then 'true' else 'false' end as fulltextinstalledind
, case serverproperty ('isintegratedsecurityonly') when 1 then 'true' else 'false' end as integratedsecurityonlyind
, case serverproperty ('issingleuser') when 1 then 'true' else 'false' end as singleuserind
, cast( serverproperty ('licensetype') as nvarchar(128) ) as licensetype
, cast( serverproperty ('numlicenses') as integer) as numlicenses
, datediff(mi,getdate(), getutcdate()) as utcoffsetmin
SQL = Scarcely Qualifies as a Language
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply