How is this different from starting up Visual Studio and importing the database schema and then adding it to a VCS ?

Create new database project and then choose...

I do this on tables with > 1.000.000 records

Something to keep in mind of course, is the number / complexity of indexes.

A possibility is to disable all indexes, remove the...

My way of working:

[font="Courier New"]

BEGIN TRAN

SELECT DISTINCT *

INTO #tempTable

FROM myTable

TRUNCATE TABLE myTable

INSERT INTO myTable

SELECT *

FROM #tempTable

COMMIT TRAN

DROP TABLE #tempTable

[/font]

This is the code I used...enjoy 🙂

-- Get table (worksheet) or column (field) listings from an excel spreadsheet

DECLARE @linkedServerName sysname = 'TempExcelSpreadsheet'

DECLARE @excelFileUrl nvarchar(1000) = 'D:\\SHARE\\WLAN\\Report.xlsx'

IF OBJECT_ID('tempdb..#MyTempTable')...

Yes, I have seen this...but sometimes the person who asks the question also finds a solution him- or herself.

HOWEVER, for any future finders of this post, I will answer this...

Did you ever got this to work ?

I stumbled upon the same error together with the error Unable to bulk copy data.

Switching off UAC and (!) rebooting the system, worked like a charm.

You are probably running the Activity monitor which generates:

EXEC #am_generate_waitstats

entries in the Profiler after an executed query