Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Question of the Day for 12 Sep 2005 Expand / Collapse
Author
Message
Posted Monday, August 29, 2005 10:05 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the Question of the Day for 12 Sep 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=597.
Post #215150
Posted Tuesday, September 13, 2005 9:04 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 3:44 PM
Points: 3,221, Visits: 2,375

The explanation is slightly incorrect. It states one will get the following error 5 times:

Server: Msg 8164, Level 16, State 1, Procedure procTestCounter, Line 12
An INSERT EXEC statement cannot be nested.

I cut the code out and executed it in QA and received:

[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error

 

This was achieved on a Win2K3/SP1 cluster running SQL2K/SP3a.

 

Chalk another one up !





Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #219225
Posted Monday, November 19, 2012 3:13 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, December 14, 2014 11:09 PM
Points: 1,962, Visits: 2,406
good question....


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1386262
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse