SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Old Issue, incorrect schema name

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Old Issue, incorrect schema name
Author Message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Old Issue, incorrect schema name Reply with quote
Still see it on v7
SQL Server

If you are not a dbowner in a database, and "Always Fully Qualify Object Names" is set to "With schema name" The current DB Queries will use your username as the schema name rather than the schema name of the object. I had a query that took care of this. But it isn't loading into the options anymore.

Example:

Select From table
If you then select a table like table1 in dbo schema, I get:

Select From [DOMAIN\Username].Table1

I expect to see:

Select From dbo.Table1
Wed Jul 02, 2014 11:19 am View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
Any update on this? it is a painful issue now.
Thu Jul 03, 2014 9:14 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
Looking into that.
Thu Jul 03, 2014 10:03 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
This will be fixed in the next build. Beta version 7 R2 will be made available over the weekend
Thu Jul 03, 2014 8:21 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
confirmed it works now. Thanks.
Tue Jul 08, 2014 2:40 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.