You can create your own SSIS package and then run it with your .NET application

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

what is response? is there any error? which version of SQLServer you use?

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

use Integration Service and transfer your database from 2005 to 2000.because you can not restore 2005 on 2000 on usual ways

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

you can generate sql script for you table structure and also data which exist in your table. if you have sql server 2008 follow this instructions: Open Sql Server Management Studio Right Click on your database go to : Tasks then: generate scripts... wizard will shown then try this wizard you can find it very simple

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

azad yadav wrote:

write a query that produced single row find the max form two table

you can get max for each table and then find max from two result . same as this code:

select max(twotable.fieldmatch) from
(
select max(field1) as fieldmatch from table1
UNION
select max(field1) as fieldmatch from table2
)twotable

azad yadav wrote:

query that delete all redundant data from table in sql 2005

This is a general question , you must specify what you mean exactly.

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

Use SSIS(Sql Server Integration Services) this service has powerfull abilities for transfering full database or database objects to another database server. You must install sql server 2005 or 2008 and then use this service.

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

sample here: add name="MapsaLoanConnectionString" connectionstring="Data Source=192.168.0.220;Initial Catalog=Mapsa;Persist Security Info=True;User ID=databaseUser;Password=123" providername="System.Data.SqlClient"

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

You need have full administration privilege on your sql server on server to user Replication. Usually with dedicated server this privilege is enough. more about replication: http://msdn.microsoft.com/en-us/library/ms151198.aspx[^] but first look at your problem: if you have a database on local and you need transfer your data to server for one time, replication is not recommended, i recommand integration service, or sql scripts , or backup and restore. but if you want to transfer every day, every week and ... i think you must use replication.

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

Rahul Say hiiiii wrote:

Here it gives exception at last statement i.e "Da.Fill(ds, "RAHUL")"

paste your exception error text here

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

firstly what is your machine OS? Is it Windows XP or VISTA? You can install sql server enterprise edition on Server OS . none of above OSs allow you to install enterprise. secondly you can see your sql server services and find that if you have sql server 2000/2005 instances. you must go to Control panel-> administrative tools->services then find all MSSQL services or something like this.

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

first you must find your combobox from datagrid by YourDataGrid.FindControl second you must get YourComboBox.SelectedValue from finded combobox control

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

Here you can retrieve your workgroup name: http://news.devx.com/showthread.php?t=145593[^] did you mean this?

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

1-there is no test environment here, you can paste your real MySql host address, and user and password, and then i can check it for you... 2-maybe your server address should be localhost or something same, is this your dedicated host ? or only usual host?

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

1-put your connection string here. i think you have illegal user, 2-put your error here...

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

If you mean in SQLServer you must use IDENTITY IDENTITY is the auto generate mode of an number field

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

remote connection is enable by default only you need to turn off firewall on your database server machine

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

you can do one way of these: 1-Backup from source database and Restore on destination, for this option your database server must be same 2-using Import/export tool from Integration service of Sqlserver, for this option database server doesn't matter usually.

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

What Database you ues? If you use sql server,You can do it with a simple export with Intergration Service of SQLServer.

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

did you mean this?: Create a DLL without Visual Studio[^]

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

you must PUBLISH your website if you want use dll instead of code files go to menu on VisualStudio and find publish...

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php