SQL Server 2005

[Smeglor]

I have migrated our SQL Server 2000 database to SQL Server 2005. The migrated db is still in compatibility mode 80. I want to upgrade the compatibility mode to 90, but I have many sql statements embedded into my asp.net c# app. The SQL Upgrade analyzer checked for all stored procs, queries, view etc and showed me which items need to be changed in the database to be compatible with compatibility mode 90. Is there anything out the that can scan the queries in my .cs files and tell you which queries need to be modified to be compatible with SQL Server compatibility level 90?

asp.net 1.1.4

I don't know sir...I guess its broke.

 

[jbenson001]

Not that I know of, and really, how could there be a tool to do this since the query is embedded in other text, there is no way for it to know what is SQL and wahat isn't? The same goes for any code that dynamically creates SQL.
You can just take any SWL from your code, and paste it in Management Studio, and use the tool to check the compatibility there.

 

[BoulderBum]

You may have a compelling reason to move your code's T-SQL to stored procedures.

It's usually a preferred approach where possible for reasons of security, manageability and performance.

MCP, MCTS - .NET Framework 2.0 Web Applications