Script and Export (via BCP) SQL Tables

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 - […]

5 (2)

2004-04-15

2,226 reads

Blogs

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Daily Coping 16 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to grant Exec ON multiple Stored Procedures

By ArnolddG

Hi, I have multiple Stored Procedures that are named like _Test_01, _Test_02 _Test_03 I...

XML data extract

By dbayliss1978

Hi I've been tasked with extracting information for a report where the field type...

There is insufficient sys memory in resource pool 'internal' to run this query

By WhiteLotus

Hi All, I have an issue with production server , from SQL error log...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers