Adding tables to sql server result in Domain\user.name.tablename
Posted
by Ryan Howe
on Stack Overflow
See other posts from Stack Overflow
or by Ryan Howe
Published on 2010-06-15T12:45:45Z
Indexed on
2010/06/15
12:52 UTC
Read the original article
Hit count: 237
sql-server-2005
Our app uses migratordotnet to modify the backing SQL Server 2005 database. This works great 99% of the time but we are running into an issue. We have a client that is using and Active Directory group for sql server login and when new tables are added it creates them as Domain\login.table_name. What permissions are needed to be given to the AD group to add the tables as dbo.table_name? This does not happen in with all of our clients with similar configurations so I must be missing something.
© Stack Overflow or respective owner
