Resolved; replaced problem row with this:    "'" + $Row.$Prop + "'" 

Also needed to modify these rows:
$Insert = $InsertValues -join '), ('
$InsertQuery = "INSERT...

I'm late to the party as usual, but just hit this issue for the first time. We handle -2 blocking with a process that alerts us when it happens and...

Well.. the workaround/fix is a snooze (now that I know it). Rename the CSV file to TXT. Then Excel properly interprets the TAB as a column separator.

Hi...

I'm trying to use SQLCMD to dump a few tables out to CSV files.

Several of them have columns that contain commas, so I'm TRYING to use TAB as a column...

I don't think you need to run your process every 30 minutes; you could just create an "autoexec" stored procedure in your master db (see sp_procoption), which runs any time...

Could it be that it fails because the code in your CATCH is missing a "SELECT" at the top? (or just a transcribing error?)

Error is 50000 because it's a user...

...And here I thought the correct answer was "Acolyte of the Church of Modenism"

THANKS for the info!!! It's very much appreciated.

(like your sig... so in the same spirit, "Game over, man... GAME OVER!!!")

...edit after reading ALL the examples... WHOA, that last one is...

Well... this fixed it. But now I'd like to know if anybody knows WHY it fixed it...

#this fails

$from = "\\srvrname\r$\SQL\MSSQL10_50.instname\MSSQL\Backup\srvrname$instname\DBNAME\FULL\srvrname$instname_DBNAME_FULL_" + $dd + "*.BAK"

#but this works

$from = "\\srvrname\r$\SQL\MSSQL10_50.instname\MSSQL\Backup\srvrname" +...

Does anybody have an idea?

We're running SQL 2005 Enterprise Edition. We restore a backup of a 100gb db every day in the early morning hours.

The scheduled job starts at 3:45am each day; the...

Have a look at http://www.sqlservercentral.com/articles/Tally+Table/72993/

(Tally OH! An Improved SQL 8K “CSV Splitter” Function)

Especially, review the discussion thread. You can do this without committing that cardinal sin, looping (see...

If you can find it, you might consider the reference, "How To Write Good"*

😀

*courtesy of National Lampoon Magazine

This brings me (FINALLY) to my 2 questions:

* Does this mean FTS is enabled in this db-- but it's never been used? (I think yes; I think this is my...

(If SQL2008 is the same as SQL2005 in this regard, and I expect it is,...)

Don't forget that even if my default schema is DBO-- if I execute the following 2...