Activity overview
Latest activity by ZachBerr
Thanks, Jon! I'll do a numbered list below to help keep my response organized.
I checked the other DBs on the instance, and none of them appear to have that object.
I unchecked the values in Suggestions > Connections and restarted SSMS (to be safe). Same thing happens-- still getting the incorrect prompt.
I had another SQL Prompt update to install, but that didn't do the trick. Part of the installation was restarting SSMS.
I tried refreshing suggestions again.
Our SQL Instance was restarted Thursday of last week and it didn't resolve the issue (in case that's relevant)
Querying sys.views and sys.all_objects for relationships_table_v returns no hits.
It's possible that, when the view was originally created, the developer incorrectly used etl.relationships_table_v , and then dropped/recreated the view using the correct nomenclature etl.relation_table_v. I'm not sure. Other ideas / next steps? / comments
Thanks, Jon! I'll do a numbered list below to help keep my response organized.
I checked the other DBs on the instance, and none of them appear to have that object.
I unchecked the values in Sugges...
Hi there, It's been a week, so I wanted to check back in; let me know if you need more from me. Thanks! / comments
Hi there, It's been a week, so I wanted to check back in; let me know if you need more from me.Thanks!
Thank you! I sent the snapshot through the link provided. Appreciate your assistance. / comments
Thank you! I sent the snapshot through the link provided. Appreciate your assistance.
Thank you, @Jon_Kirkwood. I'd be glad to, but I don't believe that we're currently licensed for SQL Compare; we have SQL Prompt and SQL Search. Do I need to sign up for the 14-day free trial? / comments
Thank you, @Jon_Kirkwood. I'd be glad to, but I don't believe that we're currently licensed for SQL Compare; we have SQL Prompt and SQL Search. Do I need to sign up for the 14-day free trial?
SQL Prompt Not Showing Accurate View Code-Behind
Greetings,I have a view running on Microsoft SQL Server 2017. Whenever I or others in the office use SQL Prompt to view the code-behind, it shows inaccurate code-- it lists the table name as "etl.R...