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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-02 : 06:45:07
|
| david writes "Hi,There are 300 sp waiting for change because of some syntax error when upgrading to sql server2000 . Is there any automatic method to help me finish such kind problem" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-04-02 : 06:47:36
|
| What do you mean by "automatic"? Automatically fix the syntax errors? No. But you can have SQL Server generate script files for all the procedures very easily. Once the scripts are generated you can load them into a text editor or word processor and do a search and replace on the offending syntax; if it is indeed something that can be fixed that way, you'll be done in no time. Once the scripts are edited you can save them and then execute them from query analyzer and the procedures will be updated. |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-04-02 : 06:50:17
|
| What were the syntax errors ?The only major problems I have seen in upgrading stored procs from sql 7 to 2000 is SQL 2000 doesn't like " for strings, preferring single quotes instead. Which you should be doing anyway.DamianEdit : After a few glasses of Red I am typing like I talkEdited by - merkin on 04/02/2003 06:51:29 |
|
|
|
|
|
|
How to migrate sp from sql server7 to sql server2000