RE: SQL problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,
Thank you for contacting Microsoft TechNet Managed Newsgroups.

To further diagnose this issue, could you please first let me know what the
version of your SQL Server is?
You can run SELECT @@VERSION to check it. If your SQL Server is 2005 and
the version number is less than 4035, I recommend that you first apply the
latest SQL Server 2005 service pack. Based on my internal research, there
are similar issues with the same error were caused by an known issue
(http://support.microsoft.com/kb/937343/en-us) fixed in SQL Server 2005 SP2
CU2 which was also contained in SQL Server 2005 SP3.
You can download it from this link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-
8ae5-949fdfbe59c4&displaylang=en

If it does not help, please help collect your SQL Server Error Logs for
further diagnostics. By default, the error logs are located in the folder
%ProgramFiles%\Microsoft SQL Server\MSSQL(.n)\MSSQL\LOG. Please compress
the entire folder to a .zip file and send it to me
(changliw_at_microsoft_dot_com). If the file is larger than 5MB, please
first send me an email and then I will send an email response and let you
how to upload the larger files.

Thank you!

Best regards,
Charles Wang

Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
====================================================

.

Relevant Pages

  • Re: Timeout during initial basic insert
    ... someone would be better able to diagnose it. ... > subsequent execution of the same process takes a split second. ... we are about to go live to production and this can't be ... Is this a problem with SQL server? ...
    (microsoft.public.sqlserver.server)
  • Re: REPLICATION ERROR - retention-based meta data
    ... symptomatic of a bigger issue. ... Please could you run DBCC CHECKDB to diagnose ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Did you get past this "error"
    ... 2003 server enterprise ... At this point I have backed out SQL Server (given up trying to get ... but I lack the expertise to diagnose ...
    (microsoft.public.sharepoint.portalserver)
  • Failed Windows Login On SQL Server 2K
    ... We have just set up a new SQL Server 2000 instance on ... Windows 2000 Server. ... All the users have domain accounts and their workstations ... hints on how to diagnose this? ...
    (microsoft.public.sqlserver.connect)
  • RE: Connecting remotely through VPN
    ... project to resolve this issue at one client turned up at a different client ... No connectivity to SQL server over the VPN. ... The error message in all cases is the same one I sent in my ... Thank you for sending the error logs to me. ...
    (microsoft.public.sqlserver.connect)