What are the challenges you face when working across database platforms? Take the survey

Add database name format specfication

Is there a way to format SQL Prompt to add the database name in the  FROM and JOIN Clauses
i.e instead of dbo.personnel - it would make it <database name>.dbo.personnel

I know that is being a bit strict but we write stored procedures that access data on the database server in a different database all the time as we cannot update the actual database as it is constantly changing and managed by our consultant.

Vinod Jacob


Sign In or Register to comment.