Blog Archive


SQL Users with matching passwords

use MASTER go SELECT [name],[type_desc],create_date,modify_date,password_hash FROM sys.sql_logins WHERE PWDCOMPARE(lower([name]),password_hash)=1 –Note: Have experienced where case matters or PWDCOMPARE(upper([name]),password_hash)=1 or PWDCompare([name],password_hash)=1 order by [Name]


SQL Script DB Objects

Purpose: Generates create object scripts from a specified database Steps: Download the attached script Update the $SourceServer, $db, $path, $IncludeTypes, $ExcludeSchemas, and $IncludeSchemas […]


SQL Default Template for Query Window

Edit the sqlfile.sql file located in: (SSMS 2008) C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql (SSMS 2005) C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems\Sql /* Description: Author: Date: […]