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.
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 |
|
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. |
 |
|
|
|
|