Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Active node name where SQL is running

May 9 2012 12:00AM by Chintak Chhapia   

With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.

Select serverproperty('ComputerNamePhysicalNetBIOS')
Read More..   [25 clicks]

Published under: SQL Server Tips ·  ·  ·  · 

Chintak Chhapia
40 · 5% · 1457
13
 
2
 
12
 
0
Incorrect
 
0
Interesting
 
0
Forgotten


Submit

1  Comments  

  • It's sad that a lot of production code does not use this.

    commented on May 11 2012 1:01PM
    Nakul Vachhrajani
    4 · 33% · 10564

Your Comment
Sign Up or Login to post a comment.
"Active node name where SQL is running" rated 5 out of 5 by 13 readers
Active node name where SQL is running , 5.0 out of 5 based on 13 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]