SQL Server Performance

IRowsetChange

Discussion in 'Getting Started' started by SQLKEEN, Jul 9, 2007.

  1. SQLKEEN New Member

    Hi all

    I have a job running, it basically executes a store procedure. Store proc contains some sql queries that insert data from one server to other. Job runs fine, but sometimes it comes up with following error

    Executed as user: NT AUTHORITYSYSTEM. OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.

    I really don't understand the behavior (works fine someday , and comes with error some other day)

    Thanks heaps

    Whenever you fall, pick something up.
  2. MohammedU New Member

    What are values for query timeout and connection timeout for server options in linked server configuration...

    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. ghemant Moderator

    Hi,

    Check your windows event viewer if any network error has logged at the time of timeout occurred, also ensure if their is some process running on that server/database that are eating up more resources.

    Regards

    Hemantgiri S. Goswami
    MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
  4. satya Moderator

    If it works sometimes and doesn't work sometimes means there could be an authentication issue on network. It is also called security delegation and if you are using Active Directory then refer to this KBAhttp://support.microsoft.com/default.aspx?kbid=319723 fyi.


    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  5. SQLKEEN New Member

    quote:Originally posted by MohammedU

    What are values for query timeout and connection timeout for server options in linked server configuration...

    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.


    Both(query timeout and connection timeout) are 0

    Whenever you fall, pick something up.
  6. satya Moderator

    How about information for 2 other replies above?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  7. SQLKEEN New Member

    Hi guys

    I had a look into event viewer, there is no network failure or time out messages. And also checked security , it is not using Active Directory. But i found some itresting info that, the Source Database Server and Destination Database Server have different collation, but databases and tables within both server have the same collation. I am guessing this could be the reason. If that is the case , how do i have to change the collation of Destination Server to match the Source Server without reinstalling. ..

    Thanks heaps for your previous inputs

    Whenever you fall, pick something up.
  8. satya Moderator

    You must rebuild the master database to fix corrupted master databases or to change collation settings for the instance. Detailed steps and information are available in the "How to rebuild the master database" topic in SQL Server Books Online. Also, be aware of the issue that is mentioned in the following article in the KBAhttp://support.microsoft.com/kb/273572/ link.

    Also you could take help of BOL about changing the database collation using ALTER database statement

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  9. SQLKEEN New Member

    Thanks Satya, i will have a go.

    Whenever you fall, pick something up.

Share This Page