cool. thanks for the advice, but creating a user-defined function

is beyond my current level of experience with this.

i'll check out some resources and see what i can do.

thanks again.

so here is what i do next...

i keep the same import table as i made before. then change the datatype

to 'timestamp', and get the same warning message about conversion,...

ok... so i import them into their own table. all data was imported

into a table with varchar datatype.

then it try using that table to import from.

no problem right....

Henk Kok...

WOW THANKS! ABOVE AND BEYOND!! MANY THANKS MY FRIEND!

YOU ROCK!

no no... probably my fault.

lets see if i can expalin this properly.

basically you have a .vbs script that will run a tsql backup script.

once a parameter is passed...

could thish work as well?

declare @WhatToDo varchar(30)

set @whatToDo 'select [type] from buttype'

... ...

excellent starting position... some thing like this perhaps?

select [type], --column_name

case

when [type] = 'full' then (/*backup script here*/)

else (/*other backup script here*/)

end,

from butype --table_name

any takers?

check this out... i've used it before, and works great!

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=46806&enterthread=y

excellent question.

it's a value of a parameter actually.

so based on parameter 1, 2, or 3 that is entereed (which is another question)

the script looks in table 'X' for what the...

well... never mind that script. i was able to do some thing else like this:

set quoted_identifier off

set nocount on

declare @dbname varchar(36),@cmd varchar(255)

declare dbname_cursor cursor

for

select [name] from master..sysdatabases where [name]...

let me put it to you this way...

for example: spid 110

spid 110 full backup of database 'mydb1'

spid 110 transaction log backup of 'mydb2'

spid 110...

or... if you want to be careful you can just go to the sql service manager (icon located usually at the bottom

right in the system tray) or find it under...

i'm thinking more exclusive wmi if possible.

any takers?

this doesn't go for all procedures in variables right?? is there another way?