Finding Cluster Nodes or Cluster Name

Here is a Query to find the Cluster Nodes or Cluster Name using SQL server 2005.

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

This helps in  finding which node the instance is currently running.

Just for Laughs :) :) :) Marriage invitation in SQL Server Stored Procedure Style

CREATE PROCEDURE MyMarriage
@BrideGroom Char(NotBad),
@Bride Char(Good)
AS

SELECT Bride FROM
BridesList
WHERE
FatherInLaw = 'Millionaire'
AND CarCount > 2
AND HouseStatus ='TwoStoreyed'
AND BrideEduStatus='PG_or_Above'
AND HavingBrothers='NO'
AND HavingSisters ='No'
AND AllowRelocate ='YES'

SELECT Gold ,Cash,Car,BankBalance FROM FatherInLaw

UPDATE MyBankAccout SET MyBal = MyBal + FatherinLawBal
UPDATE MyLocker SET MyLockerContents = MyLockerContents + FatherinLawGold

INSERT INTO MyCarShed VALUES ('Ford')

@@CONNECTIONS and @@MAX_CONNECTIONS

@@CONNECTIONS returns the number of attempted connections, either successful or unsuccessful since SQL Server was last started.Connections are different from users. For example, Applications can open multiple connections to SQL Server without the user observing the connections.

Syntax: - Select @@CONNECTIONS

@@MAX_CONNECTIONS is the maximum number of connections allowed simultaneously to the SQL server. The number returned is not necessarily the number currently configured. The actual number of user connections allowed also depends on the version of SQL Server installed and the limitations of your applications and hardware.

To Change the max connections, Use sp_configure

Syntax: - Select @@MAX_CONNECTIONS

@@CONNECTIONS is incremented with each login attempt, therefore @@CONNECTIONS can be greater than @@MAX_CONNECTIONS.

 

Example: -

SELECT GETDATE() AS 'Current Date and Time',

@@CONNECTIONS AS 'Login Attempts',

@@MAX_CONNECTIONS AS 'Max Connections Allowed'

Code Names of SQL server releases

         SQL Server Release          Project Code Name

 

1. SQL Server 2008                Katmai
2. SQL Server 2005                Yukon
3. SQL Server 2000 64 bit       Liberty
4. SQL Server 2000 32 bit       Shiloh
5. SQL Server 7.0                   Sphinx
6. SQL Server 6.5                   Hydra
7. SQL Server 6.0                   SQL95

 

Add a logo to the Report Manager

Everyone wants to put their custom logo to the Report Manager. Here is how it can be achieved.

You just need to change the below code for .msrs-uppertitle in the ReportingServices.css file which is located at
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Styles

Note : Before doing this please backup the ReportingServices.css file for safety.

Put the below code under .msrs-uppertitle and you will be able to see your custom logo on the report Manager.

.msrs-uppertitle
{
BACKGROUND: url(Image Location) no-repeat;
HEIGHT: 35px;
WIDTH: 120px;
TEXT-INDENT: -5000px;
}