Interested to Buy Any Domain ? << Click Here >> for more details...
How to migrate from sqlserver 2005 to sql server 2000
(every one know reverse process of that )
- 2 Answers
- 7475 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
How to use push notification?
Briefly describe the role of global.asax?
Explain the server control events of asp.net ?
What is the caspol.exe tool used for?
What's the use of formatters in .net?
What is a page life cycle? What are the events in a page life cycle?
What is ashx file in asp.net?
Explain how to prepare culture-specific formatting in .net.
What are navigation controls? How many navigation controls are there in ASP.NET 4.0?
How do you sign out from forms authentication?
What are the different types of sessions in asp.net? Name them?
What is jade template engine?
What symbol specifies the beginning of a query string?
What is odata in web api?
What is virtual directory in asp.net?
