DECLARE @TableName NVARCHAR(128)
DECLARE @SQL NVARCHAR(MAX)
DECLARE TableCursor CURSOR FOR
SELECT name
FROM sys.tables
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @SQL = 'SELECT TOP 1000 * INTO OLM_FX_New.dbo.[' + @TableName + '] FROM ' + @TableName
EXEC sp_executesql @SQL
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE **TableCursor**
