Can’t Install SQL Server 2000 on Window XP SP2
I try to install SQL Server 2000 on Window XP SP2, but there is an error message mean “OS not support.”. What should I do? How can I install SQL Server 2000 on Window XP SP2? Please, give me the best and detail answer. Thanks.

Answer Question   |  May 2, 2008  4:29 AM
SQL Server 2000, SQL Server errors, Windows XP

New user permission to SQL server
Hi all, I have created a new local user on the sql server. Now when i access the sql enterprise server, it fails and gives error as ” login failed to user, check SQL registration properties. Thank you.

Answer Question   |  April 17, 2008  6:34 AM
SQL registration properties, SQL Server, SQL Server errors

Error when restoring a .bak file in SQL Server
I’m having a problem restoring a .bak file in SQL Server. The .bak file is fine and good. But when I restore it, I get an error. It says ” TITLE: Restore failed for Server <servername>(Microsoft.SqlServer.Smo) —————————— ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Directory lookup for the file “C:Temp<databasename>.mdf” failed with the operating system error 2(The system cannot [...]

Answer Question   |  April 12, 2008  2:12 AM
Backup & recovery, SQL Server backup, SQL Server errors

Great Plains 8 ODBC Error (45)
This just started today, Great Plains has been working for a good time now. I get first error message when logging on ” A get/change first operation on table ‘tablename’ (45).” And then when you click on More Info… it says “[Microsoft][ODBC SQL Server Driver][SQL Server]Database’Databasename’ is already open and can only have one user [...]

Answer Question   |  April 7, 2008  1:47 PM
Database, Great Plains, ODBC, SQL Server errors

unable to modify field in SQL Server 2005
I have a database that was working perfectly on SQL 2000. We moved the data to SQL 2005. Now when our program accessing the SQL 2005 Server we get “Field ‘optional’ cannot modify.” The Field optional is a bit field. The program is able to modify other tables in the database. It just won’t modify [...]

Answer Question   |  April 2, 2008  7:43 AM
SQL Server 2000, SQL Server 2005, SQL Server errors, SQL Server migration

Database Creation
Recieving an error for database creation permission for sql 2005. Please advise

Answer Question   |  March 27, 2008  3:35 PM
Create Database error ( No i.d. #), SQL Server 2005, SQL Server errors, SQL Server installation

LAZY WRITER Process
Hi, We have Database production server with following configuration: Model: HP DL 585 G5 RAM: 64 GB Processors: Intel Xeon (R) CPU E7320 @ 2.13 GHz (16 processors) OS: Windows 2003 Server R2, SP2 SQL Server 2005 with SP2 LAZY WRITER 16 Process is running continuously, daily we will have to restart the sql server [...]

Answer Question   |  May 14, 2008  5:29 AM
Lazy Writer, SQL Server 2005, SQL Server errors

SQL Server – Is there a formula for determining what identity range to set?
We have been struggling with exhausting our range and get the following error: The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when an identity column data [...]

Answer Question   |  March 18, 2008  2:31 PM
SQL Server, SQL Server errors

Msg 102, level 15, State 1, Line 102
I get this with an ‘Incorrect syntax’ messasge when I run a stored procedure. if I run the ‘offending’ code in isolation it works fine. If I tidy the code (e.g. remove line feeds etc), the error ‘moves’ to a different location. HELP!

Answer Question   |  January 22, 2010  12:55 PM
SQL Server, SQL Server errors, Stored Procedures

Installing SP4 for SQL 2000 Error: 50042
When I try to instal SP4 for SQL Server 200 with the Cyrillic Collation, the install crashes unexpectedly with no on screen errors. In the log it says “GetLastError returned: 50042″ which I understand is related to the collation. Is there a way to fix this or perhaps a workaround?

Answer Question   |  September 30, 2008  3:09 PM
SQL Server 2000, SQL Server errors

Need help with running an external SQL query from within VB.Net code.
Hi all, I’m in a bit of a bind and new to SQL. I have built a DB using the SQL Manager and it works perfectly in my code. I have used SQL Manager to build the SQL to rebuild my DB as I want to use it in my VB.Net code. When I execute [...]

Answer Question   |  December 21, 2007  9:36 PM
SQL Express, SQL Manager, SQL Server errors, VB.NET

sqlevn70.rll error
“Your SQL server installation is either corrupt or has been tampered with (Could not open SQLEVN70.RLL). <I have been getting this error during bootup since i cleaned my registry and messed with startup programs. im still learning so basic instructions would be appreciated.

Answer Question   |  December 2, 2007  11:11 AM
rll error, SQL Server, SQL Server errors, sqlevn70

Can’t bring master database back online
hi,i bring master database into offline. after that i tryed so many times to make master database as online.But i did’t get that one into online(production side)wht is root cause for that?

Answer Question   |  December 1, 2010  11:27 AM
SQL Server 2005, SQL Server database, SQL Server errors, SQL Server Master Database