[CFTALKTor] OT: MS SQL Server question

[Sean Faulkner]

Hi folks: Sorry if this is a little off-topic but I figured since it's a Cold Fusion list, a good chunk of you would at some point have experience with SQL Server (I'm using 2000) and could answer this question for me.   I got a copy of a database which has many tables, the problem is they are "owned" by a user which doesn't exist on the system I attached. Therefore, CF can't pull any data (doesn't have permissions) and all the data I need of course is on the table owned by the user created on the last system it was on.   How do I change permissions? I've tried everything logical, from detaching it, creating a user on the system (both just the database, then on SQL server, then a user on the actual NT domain, none worked!) I've tried editing the sysusers table to no avail, anybody been stuck on this before?   Take care Sean