How do I resolve this SQL error
[-1] SQL Error: ‘[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ‘PK_cat_validation’. Cannot insert duplicate key in object ‘dbo.cat_validation’.’ SQLState=’23000′ SQLNativeError=2627.

Answer Question   |  February 28, 2012  11:52 AM
SQL error messages, SQL Server 2005 error messages

SQL Server 2005 login error
I am not able to login in SQL SERVER 2005, I am getting error message”The connection was succesfully established with server, but then an error occur during pre-login handshake.(provider:SSL provider error:0- The certificate chain was issued by an authority that is not trusted.)(Microsoft sql error) Please provide me some solution…………… Thanks

Answer Question   |  February 7, 2011  6:05 AM
SQL Server 2005 error messages, SQL Server error messages, SQL Server errors

Microsoft Retail Management System and SQL Server “Write” error
I am running Microsoft Dynamics Retail Management System POS 2.0 on Microsoft XP platform.  Store Operations Administrator and Manager are working with no problems.  I know I am networked properly.  When I open the POS I get the following:  “Open-Incorrect Function”, I can click OK and sign on the the POS, then I get “Write-No [...]

Answer Question   |  August 18, 2010  5:03 PM
Microsoft Retail Management, RMS, SQL Express, SQL Server 2005, SQL Server 2005 error messages, SQL Server error messages, Windows XP

error in creating new database using sql server
I enter as the administrator, and when creating a new database a message always appear stating that permission denied in database master! what shall i do?

Answer Question   |  March 1, 2012  3:36 AM
SQL Server, SQL Server 2005, SQL Server 2005 administration, SQL Server 2005 error messages

Deadlock issue in SQL Server 2005
I have encountered a deadlock issue in <A href=”http://searchsqlserver.techtarget.com/topics/0,295493,sid87_tax301323,00.html”>SQL Server 2005</a>. According to the trace flag 1204 report, the following two queries are causing the deadlock: 1. Simple insert statement INSERT INTO TABLE1 (FIELD1, FIELD2, FIELD3) VALUES (@INTVAL, @NTEXTVAL, @CHARVAL) – Provide IX lock 2. Simple select statement with READPAST SELECT FIELD1, FIELD2, FIELD3 FROM [...]

Answer Question   |  July 24, 2009  5:30 PM
SQL Server 2005, SQL Server 2005 error messages, SQL Server errors, SQL Troubleshooting

Installing SQL Server 2005 Enterprise Manager in Windows XP Pro
how to install SQL 2005 enterprise manager in XP professional.. When I am trying to install it, it is giving me IIS errors

Answer Question   |  February 19, 2009  11:25 AM
IIS, IIS errors, SQL Server 2005 Enterprise Manager, SQL Server 2005 error messages, SQL Server Enterprise Manager, SQL Server error messages, Windows XP, Windows XP Professional

Inserting rows and multiple rows in SQL Server 2005 Express
Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three tables where [...]

Answer Question   |  December 15, 2008  2:16 PM
INSERT statement, SQL Server 2005, SQL Server 2005 error messages, SQL Server 2005 Express, SQL Server stored procedures, Stored Procedures, VB.NET, Visual Basic .NET