SqlServer-QA.net

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2008 StandardNotification Contents: New and Major Modifications How to change SQL Server parameters in a clustered environment when SQL Server is not onlinehttp://support.microsoft.com/kb/953504/en-US The cluster setup fails without a clear error ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2008 EnterpriseNotification Contents: New and Major Modifications SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pageshttp://support.microsoft.com/kb/955628/en-US

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New FIX: Error message when you run a long stored procedure that is encrypted in SQL Server 2005: ''A stack overflow occurred in the server while compiling the ...

The following error is a frequent-faced issue by any SQL Server user :  SQL Server is unavailable or does not exist  or SQL Server does not exist or access denied   In this regard we have already relevant post PotentialCauses_Resolution here, but still I see that as a FAQ forum/newsgroup question ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition &  SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications FIX: Error message when you use the BULK INSERT statement to import data of the timestamp data type in SQL Server 2005: ''An ...

Have you ever observed the error specified above? Do you need to worry for this issue, yes! First task to check what are the memory settings on SQL Server, by default they will be DYNAMIC and quite common that they might have set with MIN & MAX settings. If you ever see the above error then another option is to check ...

One of the web application user complained about the above error during the upload process of images to SQL Server database! Most of the web applications have a lot of images used in it. Its not a best practice to store the Image/BLOB type data on the SQL Server database and better that these images are usually stored in a web server folder ...

One of the client referred about the  error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.    Initial thoughts lead to checking the SQL Server timeout setting which has been left with default value 0, also further ...

Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual practice of checking of whether its a security issue to allow the logins, if so then goto ...

Very confusing error when trying to connect to a Database Engine (SQL Server 2008) using 'usual' windows authentication getting the following error:   A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other ...