How can we help you today? How can we help you today?

SQL Prompt 5 not changing context

SQL Prompt is stuck in a single database. It does not change when I change databases in SQL Server Management Studio 2008. It DOES reflect the correct database contents if I type the entire database name.
andyhammer
0

Comments

4 comments

Sort by
  • Anu D
    Thanks for your post Andy!

    We have logged a ticket for you call reference number for which is F0075926.
    Anu D
    0
  • andyhammer
    The issue resolved itself after a Windows restart. Works fine now.
    andyhammer
    0
  • Anu D
    Glad that it is working!
    Anu D
    0
  • andyhammer
    This behavior started up again in SQL Prompt 6. It was because of a USE [database] statement in the preceding code. SQL Promt pulls metadata from the last USE [database] statement, NOT the database selected in the SSMS drop down menu. That's logical and acceptable and now I know what to look for. :D
    andyhammer
    0

Add comment

Please sign in to leave a comment.