Hello
We moved SQL Server 2000 Databases to SQL Server 2005 Instance. If we change the Database compatibility level from 80 to 90, shall Replication will Fail? or any consequencies will arise? please advice. Thanks,
refer link for the features ,
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/508c686d-2bd4-41ba-8602-48ebca266659.htm
have you already configured your db in sql 2000 for replication and then moved to 2k5? if you are going to newly set it in sql 2005 it shudnt be a problem.........if uyou change the compatability to 90 many features provided in link will be supported also few 2k features will be depreciated i believe....further performance dashboard is supported only in 90.......
No comments:
Post a Comment