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
Explain page output caching?
What can we do with asp.net?
What is the difference between Hash table and Array list?
How to disable disable browser's Back button in asp.net (JavaScript)?
Where would you use an ihttpmodule, and what are the limitations of any?
How will you load dynamic assembly?
How many types of cookies are there in asp.net?
What is a session http?
What is app_code folder in asp net?
Where the assembly is stored in asp.net?
Which is the parent class of the web server control?
Define the types of configuration files.
What is the life-span of the items in the viewstate?
What is microsoft windows sharepoint services?
What symbol specifies the beginning of a query string?