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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Is SQL 2000 tran working with VS2008?

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2010-02-05 : 16:13:34
I code a store procedure mySP in SQL 2000 in which using transaction.
I used two ways to test after saving sp.

1) rename one table
or
2) rename column name

If I use "exec mySP", error will catch but ASP.NET try-catch will catch nothing, it always return no error.

Is SQL 2000 tran working with VS2008?

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2010-02-05 : 16:16:56
Sorry, If I use "exec mySP", means that
in SQL 2000 query window
Go to Top of Page
   

- Advertisement -