SQL Prompt 5 not changing context

andyhammer

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.

Anu D

Thanks for your post Andy!

We have logged a ticket for you call reference number for which is F0075926.

andyhammer

The issue resolved itself after a Windows restart. Works fine now.

Anu D

Glad that it is working!

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.