Any way to remove the "dbo." in front of join suggestions?

• 
  I've looked into this and it is a bug in the software. I've notified the developers and they are hopefully going to fix this in a future version of SQL Prompt.

  Ben Pinchen April 18, 2007 13:32

  - 0 +
• 
  Great, thank you. I'm surprised no one else has noticed or commented about this. Unfortunately this issue is really preventing me from getting my whole team to use this product, which we purchased in advance of it being ready. The sooner, the better.

  montek April 18, 2007 13:51

  - 0 +
• 
  Can you tell me if this is slated to be fixed in the next version and when that might be released?

  montek June 19, 2007 10:39

  - 0 +
• 
  This will be fixed in the 3.5 final release. We now honour the value of the "Qualify object names" option when inserting JOIN conditions exception where columns in another database are referenced. The following SQL illustrates this:
  

  -- Note that these examples are for illustrative purposes
  -- only. They use AdventureWorks 2005 and won't execute because
  -- you have to qualify object names if their owner is not
  -- your default schema.
  
  USE [master]
  GO
  
  -- Working cross-database with qualify object names disabled
  
  SELECT * FROM
  [AdventureWorks]..[Product] INNER JOIN [AdventureWorks]..[BillOfMaterials]
  ON [AdventureWorks].[Production].[Product].[ProductID] = [AdventureWorks].[Production].[BillOfMaterials].[ComponentID]
  
  GO
  
  USE [AdventureWorks]
  GO
  
  --	With qualify object names disabled
  
  SELECT * FROM
  [Product] INNER JOIN [BillOfMaterials]
  ON [Product].[ProductID] = [BillOfMaterials].[ComponentID]
  
  -- With qualify object names enabled
  
  SELECT * FROM
  [Production].[Product] INNER JOIN [Production].[BillOfMaterials]
  ON [AdventureWorks].[Production].[Product].[ProductID] = [AdventureWorks].[Production].[BillOfMaterials].[ComponentID]
  

  
  Hope that helps.
  
  
  Thanks,
  Bart

  Bart Read July 18, 2007 12:46

  - 0 +

Add comment

Please sign in to leave a comment.