![]() ![]() It became quickly apparent that IntelliSense was not recognizing my table, as illustrated below: I ran the script, checked in the Object Explorer to make sure it was created properly, then started writing Stored Procedures against it. The other day I created a new table in my database. Though I try not to rely on IntelliSense anyways, I decided to take to Google and see if I could figure out how to fix this problem without restarting SSMS. Luckily for us, there is a simple solution. I have known about this issue for years, but have just ignored it up to now. If you too have come across this, it is likely that the object has been newly created or modified since you last opened SSMS. Have you ever been writing a bunch of SQL code in SQL Server Management Studio (SSMS), only to have the query editor put a red, squiggly line underneath a table, column, view, procedure or any other object that you know exists? Of course, that red, squiggly line means that IntelliSense is not recognizing that object, thus it will also not appear in your auto-complete pop-ups either. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |