posted 5/27/2010 by Raghav Khunger
I like working with "Red Gates" tools, they are awesome. SQL Prompt (one of their tools) is a code auto-completion and formatting tool for writing SQL queries. While working with SQL prompt I noticed that it automatically qualify object names with owner name .i.e if the owner name is "dbo" it makes the query like this:
Select * from dbo.mytable
As you are seeing dbo has been added while qualifying objects. I need to remove this feature as I don't want to put restrictions on the clients to have the owner name i.e I want the query to remain
Select * from mytable
To make it that happen I did the following steps
Below is the screenshot:
After doing it my SQL prompt stopped qualifying the object names with owner name.
Do let me know your feedback, comments.
What kind of email newsletter would you prefer to receive from CodeAsp.Net?18