Thank you for the idea but when I do that, mmc runs but as soon as I try to open the SQLServerManager12.msc file, it fails.

Even though I had successfully installed an older SQL version after 2014 (2008R2 and the first instance of 2012) without issue, I believe that you are correct. This is very...

Thanks for the info. I'm not on a Windows Server so the domain / firewall settings don't apply here (at least I don't think they do). Regarding the version incompatibility...

Thank you. I'll consider the issue closed. In this case I did not write the application so I cannot capture the results. I will generate an entry...

I was reading about this and I think the print statement actually does go somewhere. Another developer recommended that the Print statement be used instead of returning a results...

Thank you for clarifying. We seem to be up and running again on a replacement computer. We did find out that the previous partner had imbedded virtual servers...

We have a new client. Their primary computer was acting a the "master database". Their secondary server was hosting the replicated data base. The primary server went...

Thank you. Will do.

Yes, thank you. I will remove the "UPDATED". It was there for testing.

I'll try that because I think the application is doing something else and overrulling the effects of the trigger. Even the simpler trigger is still producing no "1". ...

Right, the user would be using the application to make a change and that function is not intended to be in the trigger.

Thank you. Much simpler.

How do I update the inserted records without using a cursor? I thought that I had to use a cursor to reference the INSERTED records.

I want to set taxid = 1 to all new records in this table. I also want the user to be able to change the taxid to something else...