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 |
|
jhnegrao
Yak Posting Veteran
81 Posts |
 Posted - 2006-07-26 : 15:07:53
|
| Hello, All!I will migrate my SQL SErver 7 to SQL SErver 2000 on next Friday. So, I've found that there are many reserved keywords that have been changed from SQl SERver 7 to SQL SErver 2000.These words are no longer reserver keywords in SQL 2000:- AVG, COMMITTED, CONFIRM, COUNT, FLOPPY, so on.I would like to seek these words in my DataBases for avoiding problem.Anybody knows if it's possible?Are there any method to check if my DB is using any these keywords?Thanks Juliano Horta |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-26 : 15:52:30
|
| have you named your database, any tables, views, stored procedures, UDFs, etc., or columns using reserved keywords? I would just do a visual check.-ec |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|
|
|
|
Migrating from SQL 7