I had to re-install SQL Express on my laptop for development purposes, and didn't have a backup of my development database. My live app is on a shared hosting plan, I called my provider, and they were able to send me a backup of the live database, which I restored into a new DB on my laptop.

Problem is, it pre-pended all my table names with the name of the user that I use to access the hosted database. e.g. tblUsers became myuser.tblUsers.

I'm using ColdFusion, so I usually just create a cfuser login in my development DB, and assign it to all the databases. I was able to make the myuser schema the default schema for cfuser, so I wouldn't have to re-write my queries.

However, when I log in via SQL Express (using Windows Authentication), I have to use the full schema name: myuser.tblUsers, which is a pain. Is there anyway I can make myuser the default schema for anyone accessing the database? How can I get rid of it?