Thanks very much, vongrunt! Here's a star for you.
As long as I can be confident that DB-schema-dependent errors are the only ones that will behave this way, then I'm good to go.
Ben
Thanks very much for looking at this with me, vongrunt.
I understand what you did, and I see that I can run a ROLLBACK TRAN while transactions are still pending in Query Analyzer.
I guess my point is this: there shouldn't be a transaction pending. ROLLBACK is called in the stored proc...
Thanks vongrunt.
I have restarted Query Analyzer several times, opened up a clean ODBC connection, and I still get the same error!
If you try my sample code above, do you get two errors like I am seeing?
Ben
I'm seeing something strange in Query Analyzer, and I wonder if anyone else has noticed it.
Inside a stored procedure, if I refer to a non-existent table, the proc fails--giving an error, but I'm left with an additional error message indicating that a COMMIT or ROLLBACK is missing.
Some...
Hi Oakpark5.
You'll find plenty of references to CDOSYS in the SQL forums here at Tek-Tips. The CDOSYS objects allow e-mail to be sent via Exchange but originating from your SQL server. We use a proc like this (the comments explain things pretty well):
SET QUOTED_IDENTIFIER ON
GO
SET...
How much control do you have over the structure of the new_org_info table? If you could add a column that kept track of the number of occurences of each org_data name, then you could use that column to control your updates. Can you add a column to the table?
Well, take a look at the script below. It basically turns a SQL result set into one big string. If you can follow what I'm doing below, you should be able to alter it to suit your situation. I've aliased the columns in my query as col1, col2, col3, etc., because you have many columns in your...
We are using version 8.5 of Crystal with SQL Server 2000, and stored procedures work just fine. Crystal even automatically creates a parameter field to prompt the user for any parameters necessary to run the Crystal report. It could be that your "no rowset returned" error is due to a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.