I am currently using MS SQL 2000 server as backend database for web site (written in php), now plan to switch DB to MS SQL 2008 Express, I have questions about this conversion:
1) Will MSSQL2008 support all sql statement that was written in MSSQL 2000?
2) I know SQL2008 Express supports upto 4 GB storage, but is there any maximum records limitation in each table?
Any response will be appreciated.