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 |
|
sqln3wbi3
Starting Member
4 Posts |
 Posted - 2009-05-14 : 09:07:11
|
| Hey all,I'm new to the forums and all (and SQL). Just started a new job recently which requires me to do *some* SQL work, but not too much. I've been reading a lot of SQL tutorials and documentation in the last few days and was just wondering about stored procedures and SQL Server 2000 to 2005 upgrades and compatibility stuff.I currently have a database in SQL Server 2000 which I'd like to migrate to a server running SQL Server 2005 in SQL Server 2000 compatibility mode. Am I required to upgrade the stored procedures so that they will be SQL Server 2005-compliant......or......will changes not be needed since the server will actually be running in SQL Server 2000 compatibility mode?Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-14 : 10:22:09
|
| only if stored procedures have some unsupported syntax in sql 2005 like old type of joins. if you're still using SQL Server 2000 compatibility mode, it shouldnt cause any problems. |
 |
|
|
sqln3wbi3
Starting Member
4 Posts |
Posted - 2009-05-14 : 10:32:43
|
quote:
Originally posted by visakh16
only if stored procedures have some unsupported syntax in sql 2005 like old type of joins. if you're still using SQL Server 2000 compatibility mode, it shouldnt cause any problems.
That's actually exactly what I was referring to. So what you're saying is that the old type of joins will still work under compatibility mode and will not require changes to them? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-14 : 10:36:06
|
| nope. if you're using compatibility level 80 it should work ok. the old join is not supported from compatability level 90 onwards |
|
|
|
|
|
|
Stored Procedures - SQL 2005 Code Upgrade Required