SQL Prompt 5 not changing context

andyhammer · August 8, 2013 12:10PM

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 · August 12, 2013 4:40AM

Thanks for your post Andy!

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

andyhammer · August 12, 2013 9:59AM

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

Anu D · August 12, 2013 10:01AM

Glad that it is working!

andyhammer · February 12, 2015 10:36AM

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.

SQL Prompt 5 not changing context

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk