Comments
Sort by recent activity
Reinstall sorted out the issue. Thanks. / comments
Reinstall sorted out the issue. Thanks.
Found the issue. I have a USE statement at the top of my SQL script. I'm not running that code as I have several scripts in one file and highlighting the code I want to run. The code I'm running also has a USE statement but for a different database. SQLPrompt is only showing me suggestions for the USE statement at the top of the file, not for the code I'm actually running nor the database I have switched to. I did not update my SQLPrompt this morning before this issue started happening. Not sure why it suddenly started acting this way. I can understand this after updating to the latest version but it occurred before I updated. Not happy with this new default way of offering suggestions. I will now remove all USE statements from my scripts and start using 3 part identification when referencing tables in my FROM clauses. I believe this is the easiest workaround for me. / comments
Found the issue. I have a USE statement at the top of my SQL script. I'm not running that code as I have several scripts in one file and highlighting the code I want to run. The code I'm running al...
Opps, forgot to mention: Connecting to internal network based SQL Server 2012 (Standard Edition) instance. / comments
Opps, forgot to mention: Connecting to internal network based SQL Server 2012 (Standard Edition) instance.