Searching in Microsoft SQL Server

Searching a specific entity or a table can sometimes be tedious when your project involves a huge number of tables and other SQL objects.
However, one must always think smartly and in order to make searching easier the following tool from RedGate will make your search task easy.

Link:
http://www.red-gate.com/products/sql-development/sql-search/requirements

It acts very similar to a file searching tool. You will retrieve the object or table from your database you wanted without having to think  of its exact name. 
It did make my life easy. :)

Go ahead and download this awesome tool and enjoy the benefits!!

How to verify Case Sensitive Password in Sql Server 2005 Database.

Manyusers build an application using MS SQL SERVER 2005 as backend. Since SQL Server 2005 is case insensitive even if user gives a lowercase password instead of a upper case one (if original password is in Upper case), the system allows to login. Solution for that is:

select @Result=login_id from Tbl_logindetails where login_name=@login_name and password=@password COLLATE SQL_Latin1_General_Cp1_CS_AS

By the Way, you shouldn't store plain text passwords in the database.. :)