Are you talking programmatically or from SQL Server 2005? From SQL 2005 just export from one server to the other.
Programmatically, look up DataSet, DataRow and DataColumn. On Mon, Sep 29, 2008 at 10:00 AM, vanitha palanisamy <[EMAIL PROTECTED]>wrote: > hi > Can anyone say how to capy the structure and data of one table from one DB > server to another database server in sqlserver2005. > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx <p><a href="http://feeds.feedburner.com/DotNetDevelopment";><img src="http://feeds.feedburner.com/~fc/DotNetDevelopment?bg=99CCFF&fg=444444&anim=1"; height="26" width="88" style="border:0" alt="" /></a></p> -~----------~----~----~----~------~----~------~--~---
