2627 is unique constraint (includes primary key), 2601 is unique index
SELECT * FROM sys.messages
WHERE text like '%duplicate%' and text like '%key%' and language_id = 1033
More Related Contents:
- Retrieving last record in each group from database – SQL Server 2005/2008
- Base64 encoding in SQL Server 2005 T-SQL
- Integer division in sql server
- Nested stored procedures containing TRY CATCH ROLLBACK pattern?
- How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
- get DATEDIFF excluding weekends using sql server
- How to upsert (update or insert) in SQL Server 2005
- SQL query to find Missing sequence numbers
- How to use alias column name in where clause in SQL Server
- How do I move files to an archive folder after the files have been processed?
- Convert .NET Ticks to SQL Server DateTime
- Executing dynamic SQL in a SQLServer 2005 function
- subquery or leftjoin with group by which one is faster?
- Calculating timespan with t-sql
- Isoweek in SQL Server 2005
- SQL Dynamic Pivot – how to order columns
- How to update data in one table from corresponding data in another table in SQL Server 2005
- Foreign key relationship with composite primary keys in SQL Server 2005
- How to recover deleted rows from SQL server table?
- SQL Server 2005 – using generated sequences instead of Identity columns?
- What good are SQL Server schemas?
- What is difference between datetime and timestamp
- How do I check if a Sql server string is null or empty
- Problem with Renaming a Column in SQL Server
- SQL Server 2005 Computed Column Is Persisted
- Aggregate SQL Function to grab only the first from each group
- SQL can I have a “conditionally unique” constraint on a table?
- SQL Server: How to tell if a database is a system database?
- Multiple Select Statements using SQL Server 2005 “WITH” Statement
- How do you store a picture in an image column?