SQL Server Performance Forum – Threads Archive

IRowsetChange

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.

---

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.

---

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

---

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.

---

Both(query timeout and connection timeout) are 0 Whenever you fall, pick something up.

---

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.

---

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.

---

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.

---

Thanks Satya, i will have a go. Whenever you fall, pick something up.

---

]]>