Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating a trigger fails
Message
 
 
To
23/11/2021 08:10:42
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01682776
Message ID:
01682794
Views:
26
>>https://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/how-to-refresh-the-local-intellisense-ca/
>
>Thanks, I have seen a related situation where the first command creates a field but SSMS won't run it because it already detects that the second command makes relation to a field which does not already exist. When that happens, I have to split the command into two windows. I then execute the first one so the field is created. Then, I can execute the second one successfully.

Yes, this is called deferred name resolution. Read this blog recently on this exact topic

https://www.littlekendra.com/2021/10/18/deferred-name-resolution-in-sql-server-stored-procedures-views-functions/
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform