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

error on first run Expand / Collapse
Author
Message
Posted Monday, June 29, 2009 3:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 9, 2014 3:48 AM
Points: 3, Visits: 76
Hi Leah

The first time the procedure is run it returns an error message, but it does correctly export the records.

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

The next time the procedure is run it appends records to the existing excel sheet without error message.
However as I am interested in a fresh export (no append) I always get the error message.

What is the cause of this message and can it be resolved?

Kind regards
Post #743441
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse