How to make a database auto commit all transactions

I am using SQL Server 2005 with several databases.

Recently I backed up our main production database and re-attached it as a development or test database for development purposes.

For some reason this 2nd copy of the database won't commit my SELECT statements. Every statement I run a query on the database it "locks it" and won't release back to other users, unless I force a commit statement at the end of my script.

Is there a way to SET IMPLICIT_TRANSACTIONS to OFF so that I don't have to COMMIT all the time and lock the database from other users? And again, I don't want to use that statement in the query. I want to set it in the properties of the database in some way.

I read this, but it's not much help

http://ift.tt/1O4K7Bf

Thanks