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 |
|
Doug G
Constraint Violating Yak Guru
331 Posts |
 Posted - 2003-04-09 : 05:53:13
|
| I have a remote SQL2000 Server that I connect with over the Internet using an Access Data Project front end. A simple stored procedure with a temp tableCreate Procedure Testing create table #t1 (col1 varchar(50), col2 smallint) insert into #t1 VALUES ('This is a value', 14) select * from #t1 drop table #t1works fine when executed via QA (from the same workstation as the adp) returning the resultset with the one row.If I doubleclick the same testing sp in the ADP Stored Procedure window, I get "The stored procedure executed successfully but did not return any records"Am I being stupid or is Access?======Doug G====== |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-04-09 : 07:27:14
|
| Have you tried adding SET NOCOUNT ON to the very top of the procedure? I have a feeling that might solve it. |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-04-09 : 08:01:09
|
| In QA you are viewing the steps. In access it will run the proccess then give you the result.your last statement says to drop the table. Access has nothing to return to you.I would drop the table first then create it. Yes this will leave a temp table out on SQL but since you drop it before you start your procidure it will have no effect on your data.Edited by - JimL on 04/09/2003 08:01:54 |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2003-04-09 : 14:01:08
|
quote:
Have you tried adding SET NOCOUNT ON to the very top of the procedure? I have a feeling that might solve it.
Thank You Robvolk, that was it.  ======Doug G====== |
|
|
|
|
|
|
Access Project, Remote SQL2K, Stored Procedcure