Technical Article

Script to generate BCP Statements for a Database

The Script below creates a Stored Procedure that returns a Macro SQL Statement. When this SQL statement is executed, it inturn returns BCP Out Statements for all the tables in a given database. The database name should be passed as a parameter to the procedure. Before the procedure is created, the SA Password must be […]

(1)

You rated this post out of 5. Change rating

2002-01-07

3,884 reads

Blogs

SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026

By

SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...

Take Time to Gain Perspective

By

Probably the best piece of advice I ever received is to take time to...

The Fringe Festival

By

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Read the latest Blogs

Forums

Fulltext filter daemon host (FDHost) process has stopped abnormally

By zoggling

We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...

Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer

By Cláudio Tereso

Comments posted to this topic are about the item Automating OSM Data Refresh in...

Database Mail Configuration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Mail Configuration

Visit the forum

Question of the Day

Database Mail Configuration

If I want to get a list of the configuration settings for Database Mail using T-SQL,  how can I do so?

See possible answers