|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SSMS ErrorWe have two production servers running SQL 2000 and that are set up as
linked servers. My desktop has SQL 2005 and I am using MAnagement Studio to connect to the first server. While running a stored procedure on a 1st remote server that inserts data into another server, I get this error - ..Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. However, if I run the same procedure using Query Analyzer, I do not get any errors. Even though I received the error message, the stored procedure execution was successful. Any thoughts? baddy (narsi***@gmail.com) writes:
Show quote > We have two production servers running SQL 2000 and that are set up as The likely reason in an error in SqlClient. Mgmt Studio is implemented> linked servers. My desktop has SQL 2005 and I am using MAnagement > Studio to connect to the first server. While running a stored > procedure on a 1st remote server that inserts data into another server, > I get this error - > > .Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0 > A severe error occurred on the current command. The results, if any, > should be discarded. > > However, if I run the same procedure using Query Analyzer, I do not get > any errors. > > Even though I received the error message, the stored procedure > execution was successful. in managed code, whereas Query Analyzer uses ODBC. With knowledge of your code, databases etc, I cannot give any more precise information than this. But as it is likely to be a bug, it would be interesting to see a repro scenario. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics