yes i am looking for the genre variable to contain a comma seperated list of genres for the title. just wondering if it was possible to return that in...

homework - haven't had that in years.

well for now i am doing the following (note that i simplified the field names in my original post so they are different here):

SELECT...

can anyone help me out here?

basically the table is a list of users and their addresses. there are several cases where there are 2 listings for the same name. ...

ok i think that makes sense. now the complication is that i am already doing a join.

my current query looks like this

SELECT products.ID, products.Prod_Name, products.QTY, vendor.VENDOR

FROM products,...

ok so it seems that changing the service account via enterprise manager did not actually update the service at all.  so i went into the services page in computer management...

does anyone else have any ideas here - i am really stuck.  i have to get this back up and running in the next couple days somehow.

thanks for the info but unfortunately i gave that a try and still no luck.

i just tried again - maybe i am going to the wrong place in enterprise manager, because after i changed the service account in EM and stopped and started the...

yea - went into enterprise manager and changed the service user from newdomain\administrator to newdomain\someotheruseruser  then i restarted the service.  then i changed it back to newdomain\administrator and restarted the...

ok - according to that post, the new admin account would need to have the following rights:

- Act as part of the operating system.

- Increase quotas.

- replace process level token.

-...

yeah! now were getting somewhere - i looked at the proxy account and it was in fact the admin account from the old domain.  i updated it so it is...

Ok so i tried using CFEXECUTE like this:

<cfexecute name="dtsrun"

arguments ="/s SQL01 /U ColdFusionUser /P ColdFusionUser's Password /N mypackagename">

</cfexecute>

and it gives me the following error:

table.cfdump_wddx,table.cfdump_xml,table.cfdump_struct,table.cfdump_array,table.cfdump_query,table.cfdump_cfc,table.cfdump_object,table.cfdump_binary,table.cfdump_udf,table.cfdump_udfbody,table.cfdump_udfarguments { font-size: xx-small; font-family: verdana, arial, helvetica,...

all the other regulat queries like that work fine - no errors.

yea that works.

sorry i dont know what that is.  what is the SPN?