Comments
Sort by recent activity
Simon
Thanks for that. I've managed to do it where the two tables are in the same database. A suggestion that the user interface could be a bit more explicit in future versions. / comments
Simon
Thanks for that. I've managed to do it where the two tables are in the same database. A suggestion that the user interface could be a bit more explicit in future versions.
Thanks for the link. In your example, when you remap a table both source and destination tables have the same name "WidgetPrices". I would like to copy data from "WidgetPrices" into say "WidgetPricesNew" and I can't see how the "Map" diakog allows me to to do that / comments
Thanks for the link. In your example, when you remap a table both source and destination tables have the same name "WidgetPrices". I would like to copy data from "WidgetPrices" into say "WidgetPr...
Amongst others I selected Include Identity Columns and Reseed Identity column. The script ran this as the last statement.
-- Reseed identity on [dbo].[tblEvent]
DBCC CHECKIDENT('[dbo].[tblEvent]', RESEED, 1014049)
GO
-- Reseed identity on [dbo].[tblContact]
DBCC CHECKIDENT('[dbo].[tblContact]', RESEED, 173013)
GO
I suspect the reseed values were wrong for some reason. I don't run this script very often. When I run it again I will check the identity reseed values before I run the script / comments
Amongst others I selected Include Identity Columns and Reseed Identity column. The script ran this as the last statement.
-- Reseed identity on [dbo].[tblEvent]
DBCC CHECKIDENT('[dbo].[tblEvent]',...
Thanks Chris. Please close the call. There may have been a delay bewteen generating and executing the script. I will check details when I run this script next / comments
Thanks Chris. Please close the call. There may have been a delay bewteen generating and executing the script. I will check details when I run this script next