sql server odbc: I am able to create a view in SQL Query Analyzer with no
problems. When I try to do this in Enterprise Manager, I
get the 'Invalid Cursor State' error when I try to save

You didn't post what version of SQL Server but there was a
similar issue fixed in SQL 7 with SP2. However, I've seen
the error with other versions, in other situations when
using Enterprise Manager. Why not just use Query Analyzer?
It's an ODBC thing - I've seen it when not using set nocount
on (as multiple result sets are returned) or with ODBC
programming, not managing the result sets or positions. If
you really want to see what ODBC call is failing, you can
turn on ODBC tracing and reproduce the error.

-Sue

On Tue, 26 Aug 2003 08:31:10 -0700, "David Koth"
[quoted text, click to view]