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

Recursive Association with compound primary key in SQL database
Hello, I’m afraid I’m very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a ‘Lead Client’ column to represent a recursive relationship where one attendee can be nominated to lead others attending [...]

Answer Question   |  January 3, 2011  11:53 PM
Database issues, Design principles, SQL, SQL Database, SQL Server database, SQL Server errors

SQL Server error 7125: Updated driver to get around?
I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs: #7125: The text, ntext, or [...]

Answer Question   |  November 2, 2010  5:32 AM
Access, ODBC, SQL Server, SQL Server error messages, SQL Server errors, SQLSRV32

SQL Server 2005 error log, could not read information for this log entry
Hi, There is a SQL Server error log entry in the SQL Server 2005 production box with the following.   “Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:”   Has anyone seen anything similar? Does anyone know what [...]

Answer Question   |  January 14, 2010  12:41 AM
SQL Server 2005, SQL Server error logs, SQL Server errors

On Error Resume Next SQL Server 2005
Is there to achieve On Error Resume Next? insert into table1 select top 1000 columnname from table2 It should continue inserting the next record even if there is an error. It should not stop the execution. It should simply skip the errors. thanks in advance.      

Answer Question   |  September 5, 2009  10:28 AM
SQL Server 2005, SQL Server error messages, SQL Server errors

SQL Server error: Cannot find log file
I am receiving the error, “cannot find log file.” I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

Answer Question   |  July 15, 2009  2:52 PM
MDF, SQL Server database, SQL Server error messages, SQL Server errors, SQL Server logs

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

SQL SERVER EXPRESS 2005 FREEZE
I have a server machine running Windows Server 2003 and sqlserver express 2005 for a client-server application. All clients machines access the server thru a router fine with good response time but if the internet conecction fails suddenly the sqlserver freeze. Any sql command takes a long delay. What could be the reason ?. What [...]

Answer Question   |  April 26, 2009  1:38 PM
SQL Server 2005 Express, SQL Server errors, SQL Server Express, SQL Server Express 2005

Application not responding in Windows XP Professional
How do I determine what is causing a “Not Responding” status in Windows Task Manager when running my application? It changes back and forth from “Running” to “Not Responding”. It is very slow but eventually finishes. Using Windows XP Professional and SQL Server 2000.

Answer Question   |  November 20, 2010  2:52 PM
SQL Server 2000, SQL Server errors, Windows XP, Windows XP Professional

Finding the average of a data type on a SQL Server
I am trying to figure how to find the average of the data type datetime on my SQL Server. This is my code: SELECT CONVERT(varchar, Tanggal_Produksi, 3) AS Tanggal_Produksi, Target, Actual, Balance, CONVERT(varchar, Waktu_Proses_Awal, 8) AS Waktu_Proses_Awal, CONVERT(varchar, Waktu_Proses_Akhir, 8) AS Waktu_Proses_Akhir, CONVERT(varchar, Waktu_Proses_Akhir - Waktu_Proses_Awal, 8) AS Waktu_Proses, Bulan, Tahun FROM dbo.Histori_Produksi This is [...]

Answer Question   |  March 5, 2009  8:25 PM
Data Types, DateTime, SQL Server, SQL Server DateTime, SQL Server errors

SQL Server 2000 error message involving ASP
We are getting a scripting engine exception on the ASP page, but it is actually updating the data to SQL Server 2000. Could the error be due to a SQL Server connection problem?

Answer Question   |  February 25, 2009  8:46 PM
ASP, SQL Server 2000, SQL Server error messages, SQL Server errors

SQL Server user instance error
Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled’ to generate user instances.” idon’t know how to solve it

Answer Question   |  February 25, 2009  9:42 PM
SQL Server errors, SQL Server User Instances

Error uploading records into a SQL Server table
We have 700 hundred records, and we wish to upload them into a SQL Server table. After 600 have been uploaded, SQL Server failed to upload the last 100. Why might this have happened?

Answer Question   |  January 22, 2009  6:07 PM
SQL Server errors, SQL Server tables

Error in SQL Server 2005 with passing a variable
In T-SQL code on SQL Server 2005, the variable :t_id is being passed from other pages and works in other statements, but it is not parsing within this statement: define(“TF_T_INFO_INSERET”, ” insert into TFT (WG_ID,task_id,tf_id) SELECT (select WGID from LU_T where TID= :t_id ), :t_id , (select max(TF_ID) from LU_TF); “); If I replace :t_id [...]

Answer Question   |  December 12, 2008  4:23 PM
SQL Server 2005, SQL Server errors, SQL Server Variables, T-SQL

Error message from SQL Server 2000 Agent after antivirus installation
SQL Server 2000 Agent would not start after the installation of the antivirus software Sophos and a reboot. I found the messaging service was shut off, so I started it, rebooted and the agent came up running. I then tried to start a backup job, but I received “error 14258,” which stated that it was [...]

Answer Question   |  December 11, 2008  7:44 PM
SQL Server 2000, SQL Server Agent, SQL Server errors

insert into with select and passing variables
This is driving me NUTZ —- SQL Server 2005 and PHP the variable :t_id is being passed from other pages and works in other statements, but is not parsing within this statement. If I replace :t_id with say 30, it works just fine. I tried declaring a new variable and passing it to the statement, [...]

Answer Question   |  December 11, 2008  2:21 PM
PHP, SQL Server 2005, SQL Server errors, SQL Server Variables

Error message when installing SQL Server 2005
I have installed SQL Server 2005 and acquired SP2. However, when I continue to install the SAP dialog instance, it gives me the following error: MDB-05036 Error when creating sqldmo SqlServer object What does this mean?

Answer Question   |  March 8, 2011  6:02 PM
SQL Server 2005, SQL Server errors, SQL Server installation

SQL error. There is already an object named ‘InitCap2′ in the database.
I am running the following code in Microsoft SQL Server Management Studio Express, and after I run it, I get the following error, even though it is returning the record set that I am looking for. I would like to get rid of this error. Thanks. The error is: Msg 2714, Level 16, State 5, [...]

Answer Question   |  December 5, 2008  8:21 PM
InitCap2, SQL, SQL Server errors, SQL Server Management Studio, SQL Server Management Studio Express

Can’t manually enter data any more; get Error Message: String or binary data would be truncated.
Three databases that were forced restored now do nor allow manual entry, even one single character, although using an update statement works. This is not a matter of changing the length of the datatype, but something else. For the life of me, I can’t figure out why this mere attempt at manual data entry generates [...]

Answer Question   |  December 6, 2008  6:23 PM
Binary data, SQL Server 2005, SQL Server 2005 SP2, SQL Server errors

Need help…My Sql server 2000 has error
My Sql server 2000 has error when created a new database or create a new table in my database. There is the error : “[Microsoft SQL-DMO(ADBC SQLState : 42000)] – Cannot use empty object or column names. Use a single space if necessary” I think my SQL server 2000 was created a no name database, [...]

Answer Question   |  December 4, 2008  4:41 PM
SQL Server 2000, SQL Server database, SQL Server errors