 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
SQL 2000 Schemas Broken |
|
5.0.97 Pro
SSMS connected to SQL 2000
With schema name chosen
If you type Select and choose a table, the table is prefixed with your user instead of the schema the table resides in.
What happens:
Select Field1 From [user].Table1 t
What should happen:
Select Field1 From dbo.Table1 t
|
|
Wed Jun 30, 2010 5:32 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
I'm unable to reproduce this. Please let us know what "Context (MSSQL)" query returns for your login. This query can be found in SQL Assistant options on DB Options tab.
|
|
Thu Jul 01, 2010 8:51 am |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
Output from query: not actual values, but what basically returned.
(No column name) (No column name) (No column name) (No column name)
[ServerName] [MyLogin] [Database] [MyLogin]
The difference: when connected to SQL 2008, the last column is dbo. In SQL 2000, it returns my login name with domain.
The query seems unchanged from version 4.8.
|
|
Thu Jul 01, 2010 9:02 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|