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 |
|
engcanada
Starting Member
39 Posts |
 Posted - 2008-06-26 : 20:28:07
|
| I have just upgraded my database from sql 2000 to 2005 however all tables now preceded with login name in which forcing me to change all me sql statement to with tables login name followed by the table name i.e.select * from loginname.tablenameinstead ofselect * from tablenameDid I miss any step when I brought my database from 2000 to 2005.Any idea how to get around this without having to alter all y statements.Thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-26 : 20:32:02
|
| How did you perform the upgrade? It doesn't sound like you did it via either recommended approach: detach/attach or backup/restore.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-26 : 20:53:18
|
| Make that schema your default schema in Logins. |
|
|
|
engcanada
Starting Member
39 Posts |
Posted - 2008-06-26 : 20:54:20
|
| TASK>COPY DATABASE |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-26 : 22:04:29
|
| You wouldn't have this issue if you'd used the methods I mentioned. Are you able to start over so that you don't have to change default schemas, code, or anything else?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
engcanada
Starting Member
39 Posts |
Posted - 2008-06-26 : 22:20:59
|
| Yes I can do that.Thanks for all your help!All the best |
|
|
|
|
|
|
Sql 2005 lgoin issue