• 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...

    only1rb15 pointsBadges:
  • 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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    Comtrendz5 pointsBadges:
  • 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.

    Wdpless5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following