In SQL Server 2000:
select * from ::fn_virtualservernodes()
In SQL Server 2005:
select * from sys.dm_os_cluster_nodes
Or this backward compatibility function:
select * from fn_virtualservernodes()
Reference: BOL
Posts Tagged ‘one-liner’
One-liner : Find out the node/ server name
Posted in SQL Server, tagged one-liner, tsql on 21 September 2009 | Leave a Comment »
One-liner: sp_change_users_login
Posted in SQL Server, tagged one-liner, tsql on 18 September 2009 | Leave a Comment »
To automatically map users to the SQL logins on the server:
exec sp_change_users_login ‘Auto_fix’
To find orphaned users ( users with no logins):
Use
exec sp_change_users_login @Action = ‘Report’
Reference: BOL
