Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 dbo and permissions?

Author  Topic 

mdean9999
Starting Member

21 Posts

Posted - 2011-05-27 : 13:11:20
I have an old SQL server database now running in sql server 2008. There are four tables prefixed 'dbo.' and the rest are 'SFS.'.
How do I change change the four to the same as the rest? Or do I not need to bother?
I don't fully understand what the ramifications of this 'database owner prefix' are!

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2011-05-27 : 14:10:26
If nothing is consuming this database then you can probably do as you want but otherwise I wouldn't mess with it until you know what you're doing and why.

Here's some general info:
SQL Server Best Practices – Implementation of Database Object Schemas


To change the schema of a table use alter schema

Be One with the Optimizer
TG
Go to Top of Page

InfraDBA
Starting Member

38 Posts

Posted - 2011-06-06 : 00:56:55
Check with the application that is accessing the database.Check with the default schema for the database and then do the changes.
Go to Top of Page
   

- Advertisement -