Looks like you're getting closer but the syntax is wrong, when you use the redirection symbol you do not specify the -o option for out put. so you should...

Did you try the re-direction symbol >

Not tested but it would seem that you need to put quotes around the path of the output file.

Rick

to Create a date variable you can use:

DECLARE @fn char(6)

SET @fn=REPLACE(convert(char(8),getdate(),1),'/','')

http://msdn2.microsoft.com/en-us/library/ms974559.aspx

On Error Resume Next

Const adOpenStatic = 3

Const adLockOptimistic = 3

Const adCmdText = &H0001

Set objConnection = CreateObject("ADODB.Connection")

Set objRecordSet = CreateObject("ADODB.Recordset")

strPathtoTextFile = "C:\Databases\"

objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

...

First thing that comes to my mind is permissions. Where are you executing it from and do you have access as that user? I run from my workstation via query...

BULK INSERT [ [ 'database_name'.] [ 'owner' ].] { 'table_name' FROM 'data_file' }

[ WITH

(

...

I do it by running a ftp job that sweeps the server picking up any file it sees mget *.* as often as needed. then I run a vbscript which...

try this

declare @idint

declare @typecharacter(2)

declare@pagesint

declare @dbname sysname

declare @dbsize dec(15,0)

declare @bytesperpagedec(15,0)

declare @pagesperMBdec(15,0)

create table #spt_space

(

objidint null,

rowsint null,

reserveddec(15) null,

datadec(15) null,

indexpdec(15) null,

unuseddec(15) null

)

set nocount on

-- Create a cursor to loop through the user tables

declare...