Add database name format specfication

vjacob1vjacob1 New YorkPosts: 17 New member
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.

Thanks,
Vinod Jacob
Tagged:

Answers

Sign In or Register to comment.