How to migrate from sqlserver 2005 to sql server 2000
(every one know reverse process of that )
- 2 Answers
- 6627 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 is the full meaning of asp.net?
What is an asp.net validator? And, mention its types.
What are Authentication and Authorization?
6. Tell us about a time when you failed to meet a deadline. What were the repercussions?
Can we create a multiple user simultaneously ?
How do I send an email message from my ASP.NET page?
What is cross page posting in asp net?
What is difference cookie and session?
Diff between web user control and web custom control?
How asp.net mvc differs from asp.net web forms? : asp.net mvc
How does viewstate work?
What is the difference between web config and machine config files?
Is a dll file an executable?
Is it possible to create web application with both webforms and mvc?
Explain what benefit does your code receive if you decorate it with attributes demanding specific security permissions?
