How to migrate from sqlserver 2005 to sql server 2000
(every one know reverse process of that )
- 2 Answers
- 6393 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 implement role based security in asp.net mvc? : Asp.Net MVC
Why will you usually create an aspnet user account in the database for an asp.net web application?
Explain login control and form authentication.
Tell me how asp.net mvc differs from asp.net web forms? : asp.net mvc
To display data in a Repeater control which template you provide?
What is different authentication mechanisms used in ASP.NET?
Where you store Connection string in "Web.Config" file in ASP.NET?
What is server redirect?
How can we use Web API with ASP.NET Web Form?
Hello, Using Visual Studio 2005 (VB) I am working to create a Web Site implementing the following: Within a gridView I have placed a dropdownlist control with a DataSourceID="SDSLkupList". SDSLkupList is a sqlDataSource used to store a lookup list for dropdownlist translation from ID to text. SDSLkupList contains the translation text and other fields related to the dropdown selection ID. (Thought it would be efficient to get everything at the same time.) I would like to provide the user the ability to select from the dropdownlist and, based on the selection, use labels to list related columns stored on the SDSLkupList in separate gridView columns. I have read that SqlDataSources are not meant to be used for individual controls. Since SDSLkupList contains all related information, is there a way to do a find using the dropdownlist selectedValue? (I was not able to discover one.) Otherwise, what should I use? It would need to set the labels on the gridView DataRowBound event as well as the SelectedIndexChanged events. Has anyone done this? Any help would be appreciated. Thanks in Advance. Neal
How many types of server controls do we have?Also explain differance between them taking an example of ASP.NET?
What is an asp.net validator? And, mention its types.
Explain about the .NET framework?
What is the difference between session.abandon() vs clear()?
What is connection pooling and how to enable and disable connection pooling?
