jdamian (3/13/2012)

---

Oh yes, this is what I need!! I posted my last reply before I saw your latest IF post Seth. Thank you so much!! I really appreciate your help;...

jdamian (3/13/2012)

---

OK, I changed it...but I'm still having an issue and am a bit confused. Excuse my "newbness" but how can I now create such a query that would get...

Annee (3/12/2012)

---

I already configured it using GUI 'SQL Server Surface Area Configuration'

But to make sure, I repeated it using the commands u sent.

But no luck.. still the same...

Yes, you may have to enable the xp_cmdshell extended sproc first:

USE

master

GO

EXEC sp_configure 'show...

I just tried replicating the issue from your first query (modifed to use AdventureWorks DB) and it output 19614 records to a .csv:

DECLARE @FileName varchar(50),

@bcpCommand varchar(2000)

SET @FileName = REPLACE('c:\\ArchiveDocumentHold_'+CONVERT(char(8),GETDATE(),1)+'.csv','/','-')

SET @bcpCommand...

The problem I see with this...

jdamian (3/12/2012)

---

Hi, Thank you! This looks like it is what I am looking for. However, I forgot to mention that I am using SQL Server 2005 and I don't believe...

Annee (3/12/2012)

---

But if I have to declare variables(since I want to dynamically append the date to the outputfilename) and then execute it using 'exec', it fails with the error

SQLState =...

Thanks Steve.

marly (3/12/2012)

---

I changed it to

SELECT * from dbo.mytable WHERE FirstName LIKE ‘%’ + REPLACE(@FirstName , ‘%’,’’) + ‘%’ but it still seems to put down the whole database if I...

I think the job will simply not run. It won't fail because it won't be attempted. This Sunday, 2:00 AM will not exist.

I like to use BCP:

declare @cmd varchar(1000)

set @cmd =

'bcp "select Col1, Col2, Col3 from x where Add_dateTime = CONVERT(VARCHAR(10),getdate(),120)" queryout "F:\output.csv" -t, -T -c'

exec xp_cmdshell @cmd

Then wrap that in a...

Have you tried turning on the Windows Event Log service?

OR execute BCP right from a scheduled SQL Agent job. Here's a similar script I've used for a CSV file (you can change it for tab delimited use):

declare...

How about creating a batch that executes a BCP (Bulk Copy Program) script?