thanks for your reply but  o i didnt do either of those things - and i tryed running both commands you suggested and no effect. 

i just looked in the event viewer on the SQL server and every tiem i run my CF template i see an entry like the following in the security log. ...

coldFusionUser is a SQL login with just SQL Server Authentication - so there is not domain account for him.  i don't think i could assign permissions to any folders with...

ColdFusionUser is not a networkuser, it is a SQL user using SQL server authentication.  so how would i go about giving a SQL user access to a network folder?

I assume so because it is the same user that was running the sp before the migration without any problems but how would i check this?

anyone??? i am really stuck here.

hey thanks for the reply.  originally i was using CF to control the import but some of the file we need to import are quite large on occasion.  and it...

i have no idea how to do that - could you give an example?

unfortunately i dotn think the dctry/cfcatch would work for me because the problem is that the cf template sends the command to the sql server to run the stored proc...

sounds interesting but i have no idea how to do that.

let me just see if i have the concept right.  you are saying that i add a command to my...

thank you!  i had copied and pasted and modified this query from another page where i was using a subquery and my mind was thinking subquery since it was already...

i ended up doing this and it seems to work:

SELECT tbl_users.username,

(select top 1 tbl_groups.groupname

from tbl_groups, tbl_group_memberships

where tbl_users.id=tbl_group_memberships.userid AND tbl_group_memberships.groupID=tbl_groups.ID

order by tbl_group_memberships.id)...

hey thanks for the reply!

sorry but i am not sure what that last part is doing

where exists

(select gm.groupname

from tbl_groupmemberships gm

where u.id=gm.userid )

can you please explain that?

thanks!

sorry i should have mentioned that if a user is a part of multiple groups i only what their first group membership returned.  so there will only be one record...

will that work though?  because the detail query is part of a loop that is looping over the RICCOUNT query (a seperate query) so the detail query is executed for...