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 are the events raised in asp.net page life cycle?in which stage view state can be loaded?
What is Razor View Engine
Which protocol is used in a web api?
Explain the difference between panel and groupbox classes using .net?
What is the full form of asp.net?
Can you nest updatepanel within each other?
how to include timer or counting time to display next page in asp.net
Explain the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc
What is session and cookies in asp.net?
What are the asp.net 2.0 features?
What is the difference between the response.write() and response.output.write() methods?
What is the difference between sealed vs static class?
1.what is the application pool. 2.what is the HttpModile and Http Handler. 3.C# 3.0 Features ? 4.Anonoymous Type,methopd and claas in 3.0? 5.difference between statsic and const ? 6.session vs application 7.state management clint side and server side ? 8.Genric list 9.c# 3.0 vs 3.5
What is asp net theme?
What is %20 in a url?