Help with copying tables in Sql Server 2005 1

[ironhide1975]

Can someone direct me to a proper method of copying over tables and data from one database to another in SQL Server 2005. I've tried to use the export function, but I keep getting the rows of data appended on the end of the table instead of being replaced.

 

[mrdenny]

You can submit bugs to microsoft via connect.microsoft.com. However before doing so you should download SP2 for SQL Server and install it on your workstation and see if the problem goes away.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com