Script via OLE Automation and Export via BCP. Check for existance of object, checks count of table with count of exported file (reads BCP output). Will do DBCC UPDATEUSAGE if at first the SQL record count does not match BCP count. Full options for scripting (with w/o indexes, Referential integrity, etc). REQUIRES ADMIN ACCESS - […]
2004-04-15
2,511 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers