Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-08-11 : 17:41:28
|
| Hi,Here is the scenario.Running SQL Server 2k5 standard.Win2k3 Server.Created stored procedure that has within it 'Print' statements.Used SQL Agent to schedule this SP to run at a given interval. The output is dumped to an output file.Now when this runs and I look at the output file, I find:[SQLSTATE 01000]at the end of each 'Print' statement output.How do I stop this message [sqlstate 01000] from getting dumped to the output file??? Thanks in advance. |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-08-12 : 11:50:03
|
| I just changed print with select in script file, my problem solved. |
 |
|
|
|
|
|
SQLSTATE 01000