Do you see any strange dots and/or arrows in the Visual Studio code editor and have no idea how you turned them on? (check the screen-shot)
Category: Troubleshooting
If you ever generated scripts using SQL Server 2005 using Management Studio by right-clicking on table names, and tried executing it in SQL Server 2000 (using Query Analyzer), you would have encountered this problem… The Query Analyzer would report syntax errors.
Here is the scenario… a web application has been implemented with the standard user management features… can create new users, the admin approves the users, can recover passwords and change security question + answer bla bla bla
What happens if a user forgets the password?… simple, just goto the password recovery page and answer the security question and get the new password in the email.
But what if he/she doesn’t remember the answer for the security question???
Just the other day, the guys told me “This is weird, the same form works in one PC and throws an exception in another”.
We thought it is something to do with the default culture set in the PC (it was dutch). But the culprit seemed to be the SQL query used. But how come the same SQL query with the same database works in one PC + SQL server and throws an exception in another PC + SQL server? (the databases are identical)