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 |
|
EA
Starting Member
19 Posts |
 Posted - 2006-09-30 : 07:07:17
|
| Posted - 09/30/2006 : 05:52:32 -------------------------------------------------------------------------------- Hi,When I move my SQL Server from node 1 to node 2 the instance and agent are starting correctly. Everything seems to be working fine, but the (DotNET) application won't start.The eventlog shows:Exception Type: System.Data.SqlClient.SqlExceptionErrors: System.Data.SqlClient.SqlErrorCollectionClass: 15LineNumber: 151Message: Incorrect syntax near 'OPTIMIZE'.I can't find anything on the net about this behavior, suggestions are welcome!SQL Server 2005 SP1Windows 2003 SP1 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-09-30 : 13:28:44
|
| Sounds like there is some SQL in the app that is failing, you need to find that SQL (it has the word OPTIMIZE in it). Find that and post it. |
 |
|
|
EA
Starting Member
19 Posts |
Posted - 2006-10-01 : 07:50:13
|
| The same application is working fine when cluster1 is active! Why can this statement be run on one cluster not be working on the other? |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-01 : 09:05:07
|
| I guess there is something in the code that is node specific, but unless you find that code and post it - I'm just guessing. |
|
|
|
|
|
|
Error switching node