How to migrate from sqlserver 2005 to sql server 2000
(every one know reverse process of that )
- 2 Answers
- 6871 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Which method has beenintroduced in asp.net 4.0 to redirect a page permanently?
What is the use of global.asax file?
What does uri mean?
How does u call and execute a sp in .net?
Explain the path instructions in xaml?
What is the extension of master page in asp.net?
What are different methods of session maintenance in asp.net?
If we remove web.config or machine.config from the application then, is this application will works?
A web service can only be written in .net? State whether true or false.
Explain how does asp page work?
What is sdlc process?
how to include timer or counting time to display next page in asp.net
Where is the session stored?
What are the differences between primary foreign and unique keys?
Why is xap important?
