How To do Case Sensitive String Match in SQL Server

CREATE PROCEDURE [dbo].[tblUserSelect_Authenticate]
    @Username nvarchar(50),
    @Password nvarchar(50)
AS
BEGIN
     SELECT * FROM tblUser WHERE Username = @Username AND Password = @Password COLLATE SQL_Latin1_General_CP1_CS_AS
END

DROP PROCEDURE statements (all stored procedures delete Query generate)

SELECT 'DROP PROCEDURE [' + SCHEMA_NAME(p.schema_id) + '].[' + p.NAME + ']'
FROM sys.procedures p 

Drop (delete) all tables In Database

Drop (delete) all tables In Database

exec sp_MSforeachtable 'DROP TABLE ?'