SQL Server: create failed for user/ User, group, o...

If experiencing the following errors in SQL Server: Create failed for User ‘xyz’. (Microsoft.SqlServer.Smo) User, group, or role ‘xyz’ already exists in the current database. (Microsoft SQL Server, Error: 15023) The above error can sometime occur when migrating a SQL Server Database from one staged environment to another. If both those environments have the same users present you can get issues...

SQL Server: Find modified Stored Procedures with D...

Good little query to find modified dates of SQL Server stored procedures. The following example will find stored procs that have been modified in the last 7 days. SELECT name, modify_date FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 7 ORDER BY modify_date desc