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...
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...
15 pts.
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...
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...
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...
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...
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!
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!
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?
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?
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 this SQL in the SQL management studio it works 100 %. When I...
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 this SQL in the SQL management studio it works 100 %. When I...
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.
"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.
