Transforing Table in Sqlserver 2005

[Ashwini_]

How to transfor a table from one database to another.
Help me sending sentax plz. oK.

[George1111]

If you just want to do this once, then I suggest you use DTS (SSIS in later versions)

SSIS comes with SQL Server 2005 Express I believe

If you need to do this regularly, then you need to do something else

Please post again if you need more information