I want to know how can i access sql server 2008 r2 from factory SQL with SQL server authentication .
I have created a new database for test purpose.
I created a standard group and in database settings i have given credentials of user “t1” . Now when i run that group it has created table with user dbo not t1
so i want to know is it default behaviour or i am missing something.
PS: i am migrating from sql 2000 to 2008 r2 and i am unable to acess store procedures created with user “t1” so for test purpose i have done above mentioned steps but it makes me more confuse.