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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-21 : 08:40:47
|
| timpooz@yahoo.com writes "Hi,I have a sproc that I run from an Access data project. I have a print statement to try to catch errors (using @@error). When I run the sproc from the SQL Query Analyzer, I get the results of the print statement. From the ADP, however, nothing happens.How can I get the Print statement to work? Is there an alternative?" |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-09-21 : 10:45:00
|
| Print will not work in Access.If this SP Does not return any records you could add to the begining of your sp SET NOCOUNT ON then add to the end Select @@error AS LoggederrorsJimUsers <> Logic |
 |
|
|
|
|
|
Print statement doesn't work