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
- 7355 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
What are the types of caching in asp.net?
What is the difference between the response.write() and response.output.write() methods?
In your ASP.NET 2.0 web application you want to display an image that is selected from a collection of images. What approach will you use to implementing this?
What is the difference between exe and dll?
What are the Types of state management techniques
How do you hide the columns?
Is session stored in browser?
what are the security certificates used in webservices?
What are the different types of sessions in asp.net?
What does mean by a neutral culture?
What is inproc mode in session?
What is difference between singleton and single call?
How to automatically get the latest version of all the asp.net solution items from source safe when opening the solution?
What is an asp.net web form?
How to Insert/Add in ASPXgridview
