thanks krishnan

just tested this out... i'm not getting any ouput

at all. i'm not seeing the results from the text.txt

file.

this file by the way... just is an error log, and...

cool...

the xp_cmdshell worked, but having a bit of trouble

getting it to work if SET as a variable.

example:

declare @output

set @output = (master..xp_cmdshell "type C:\test.txt")

this doesn't seem to work.

forgive me if...

thanks for all the feed back.

i'm doing this for a job-step that will read various .txt files, and ouput to a notification e-mail.

example:

declare @errorlog

set @errorlog = (master..xp_cmdshell "type C:\test.txt")

--then the...

cool... thanks for the tip. any other words of wisdom that i should look out for with this??

thanks for the feed back.

ray,

every time to try to put it into one statement i

get errors cause fo the 'case', and also for the

query against the master for...

OR...

you could do the following:

backup the table with the usual method of making a copy within the same database using the following:

select into (table_backup_copy) from (original_table)

then simply go to...

well.. perhaps i spoke too soon.

the first batch is a head-ache to mod into a useful format. it can be done, but you better have an extra html editor...

hey... cool.

thats every thing i need to know. i'll be messing with this for a while.

i'm also looking into sp_makewebtask

cool stuff.

thanks bro!!

but what about sp's?...

well... i can get the information needed. i just

want the results to be in html format so i can

save a page per server as a form of documentation.

much like...

if only it were that easy.

when opened in excel, the format is messed up, and

took way to long to mod the xls, so thought it could

be done better on the...

YES!!

Many Thanks!

"Disable WYISWYG Forum Editor" under user profile.

It worked!

What a relief.

Thanks again!

ok... so...

if i was interested in working in that area,

where exactly should i look?

how do i find such jobs?

naa.. vacationed there so figure it would

make a good name.

would liked to have lived there, but couldn't

find where the 'sql' markets were.

cheers

the net is great isn't it/

what an excellent resource.

another question... do you find that the excercise in general is

easily understood?  -or- do you feel it was poory written all together?

i mean... are the concepts clear?