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.
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.
Comments
We have logged a ticket for you call reference number for which is F0075926.
Product Support
Redgate Software Ltd.
E-mail: [email protected]
Product Support
Redgate Software Ltd.
E-mail: [email protected]