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 |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-09-04 : 15:42:49
|
| Ugh, it feels like a Monday.I upgraded a DB from SS 7.0 to 2000 awhile back, I used an oledb connection from sql server to access stuff.I was looking around today when i found an error. I was grabbing a recordset produced by a stored procedure.i was doing' *** sql has stored proc and parms ***Set qry = connection.execute(sql)if qry.bof and qry.eof then emptry qryelse data in qryend if'********* I managed to fix it by putting Set NOCOUNT ON at the top of my stored proc.Is this an okay practice? Or should I find another way (change all my empty rs code or change providers)sorry to blend the asp in, but it seems to be relavant enough to Sql Server.Thanks._________________________I am 8 Beers short of a case.Proof:Phone Rings:"This is your proctologist calling, we found your head." |
|
|
|
|
|
Stored Proc Question