i have since dropped the job while experimenting, but i do want

to complete this soon.

i'll post the script later this afternoon.... doing some other

business with reporting services this morning.

in the...

excellent point...

no... i basically have the same thing you

got here, except my smtp is just below this script.

it should technically work fine, but i'm still

getting the following error.

error: Invalid column name...

i too have the same question, but am still plugging away

at it this thing.

having trouble just getting the sp to work

bcp "sp_thingy mydb" queryout c:\output.bcp

i'm still having trouble getting the id transformed

into the actual name, then passing that name into an smtp notification.

the main goal here is to create a step (which really...

yes, but there isn't any real good example of the token use in there.

sure they exist; but at least give me some thing to work with which

bol isn't that...

excellent... thanks bro!

aaron... many thanks for your help my friend.

i'm pretty sure you understand exactly what i'm trying to do.

sp_blocky really is just a select statement which returns 3 values

so all i...

actually sp_blocky produces a report, and what I'm trying to

do is use the sp instead of putting the complex select statement

after the @block

then all i need to do is use...

i'm checking it out now... i'll see what i can do

with this:

http://www.sqldev.net/sqlagent/SQLAgentStepTokens.htm

thanks for all the replies. i hope i can get this in play.

cheers!

andy... thanks for the correction, but getting the following

error:

Server: Msg 8115, Level 16, State 8, Line 4

Arithmetic overflow error converting numeric to data type numeric.

referencing line:

SELECT CONVERT(char, backup_start_date, 111) AS...

my database is nothing... at around 50gb.

ponnapalli,

tried your script... same issue.

thoughts?

oh no... thats embarassing.

please don't tell any one.

simply backup all databases including system databases, and you may

want to make a note of any special configurations for the cluster

environment.

thats it.

cheers

actually... i just tried this.

still have a problem though.

give it a go if you have time.

first:

bcp pubs..authors out c:\authors.bcp -n

then importing it with the following:

bulk insert pubs..authors from 'c:\authors.bcp' with...