September 4, 2002 at 7:58 am
I RESEED a table halfway through a SP, this gives me a warning message:
Checking identity information: current identity value '1', current column value '21683142'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
This I expect, so I add 'WITH NO_INFOMSGS' to the end of my RESEED command and now I only get:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
However that message is still giving my devloper problems with his data connection object.
Therefore is there a way to supress messages like the one above totally? (I don't mind 'Command completed successfully'!)
Many Thanks
September 12, 2002 at 7:06 pm
I don't think so, all the DBCC commands returns
DBCC execution completed. If DBCC printed error messages, contact your system administrator
September 13, 2002 at 4:57 am
He may have to do this client side instead to catch the error and ignore. You will get something back. His object shoudl still be open and he as a developer should be able to handle it.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply