DBA Archives - Page 21 of 21 - SQL Authority with Pinal Dave

SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1

April 6, 2007

DBA, SQL Download, SQL Error Messages, SQL Server DBCC, SQL Server Security

I have received this error many times on different servers in my careers. There is no single fix for this Error. Server: Msg 7391, Level 16, State 1, Line 1 can happen due to many reasons. I have used various of this reasons with few of my servers. Please refer…

SQL SERVER – Download 2005 SP2a

March 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

DBA, SQL Download

Microsoft released an updated SQL Server 2005 SP2 on March 5th, 2007. The build number is 9.00.3042.01. The previous build number was 9.00.3042.00.Microsoft released a SP2a patch for the second service pack for SQL Server 2005 to fix the issues with the maintenance plans.If you have upgraded to SP2, use…

SQL SERVER – FIX : Error 15023: User already exists in current database.

February 15, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

DBA, SQL Cursor, SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure

Error 15023: User already exists in current database. 1) This is the best Solution. First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan. USE YourDB GO EXEC sp_change_users_login 'Report' GO Run following T-SQL Query in Query Analyzer…