How to migrate from sqlserver 2005 to sql server 2000
(every one know reverse process of that )
Answer Posted / neeraj tyagi
Open SQL server managment studio
Connect to required SQL Server Instance
Right click on Database
Select properties
From property window, select Option
There is compatability mode drop down
Change drop down to required version
then save and close property dialog window.
Then take backup of database and restore it to older
version Sql server or attach the same sql serve database
file
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is http post action?
What are ASP.NET Web Forms? How is this technology different than what is available though ASP?
Explain the use of duration attribute of @outputcache page directive.
Explain how do you deploy your asp.net application?
How to deploy/publish webservices?How many ways?Plz explain me
How to comment out asp.net tags?
How does the service stream content?
What is Web API?
What is the importance of Global.asax in ASP.NET?
What is difference between or and orelse?
What is data reader in asp.net?
Define caching.
What is the server of asp.net?
What is the procedure to handle the process request using mhpm events fired? : asp.net mvc
What is the good practice to implement validations in aspx page?