fyi; i'm not looking to compare schema.

just the values to make sure that they are the

same on both ends. i've upgraded as system to 2005,

and did some imports,...

you know... thats what i thought. doesn't work on this end, but will around to

see if (for some reason) was customized for another function.

thanks for the response.

this seems to be a problem from time to time....

i've done conversions which shouldn't be too difficult; yet for some reason will

still give me trouble. nice to know threads...

it does. appreciate it. 🙂

you know... although no more than a minor annoyance this stuff (or the lack of ease)

is getting out of hand.

whatever happened to: 'download here'

great! thanks for the heads-up. 🙂

thanks for all the good feedback 🙂

fyi;

this account is shared between a few of us here at the office. i'm more

of a front end applications guy, but there...

i'm probably too inexperienced to understand charindex.

after looking through bol, i'm not sure it will get what i need.

maybe what i need is a quick example.

i want all the records...

getting the following value for the

monthly frequency:

00::0

is ok though. i'm not worried about that as long as most of it

work ok.

many thanks chuck! 🙂

just to clear something up... i'm not saying it's a bad life. only that the frustrations

can bring you to that point.

i suppose i'm done with the rant.

unfortunately; by the time you feel like you are getting a successful or near proficient

grasp on the current sql envrironment or material... it will be time for the next...

this will return all packages that are encrypted from sql server 2000.

even though 'DTSRUN' applies to the SQL 2000 environment i strongly recommend

this be run from management studio so you...

something interesting though... (pseudo logic)

whats your take on this:

selecting out all the job names, and 'command' encryption lines into

a table, then concatenating an xp_cmdshell statement to include

the...

i've got to say... this is pretty awesome.

unfortunately; could take a while. i've got hundreds of packages, but if

thats whats needed...

a dba's got to do what a dba's got...