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 |
|
mcarper
Starting Member
1 Post |
 Posted - 2002-05-01 : 09:32:32
|
| I noticed that if I used a temp table via 'CREATE TABLE' or the new 'table' datatype in sql2k in an SP called from an ADO command object that I can't get a recordset back, yet I can EXEC the SP just fine in sql QA and get a result set. I've since re-written the SP to not use a temp table or local table var (which is probably better anyway) and I am getting a recordset back now but I'm perplexed why it works in sql but does not return a result set back to ADO. Any ideas? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-01 : 09:49:26
|
| We'll need to see your code (ADO and SQL) before we can see where the problem is. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-05-01 : 10:50:54
|
| Yep, I ran into this too. I don't remember the KB article, but put SET NOCOUNT ON at the top of your stored proc and try that.Michael |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
|
|
|
|
|
Returning records from SP with temp table to ADO