..... one more question, BrownCoat42. I have configured Wimdows Failover Cluster and  specified the 2 node IP addresses on what is my Primary SQL Server. Do I need to do...

That's a good point, Andrey. Also, if the original poster just recently created the table in master, its' stats and query plan got rebuilt in master. Maybe they need to...

Thanks,, BrownCoat42. We have 2 VMs here, virtualized so I'll just specify the fileshare for the witness. I'll let you know how it goes. Appreciate all of your tips!

..... do I need to have TWO network cards per server, 1 for heart beat and one for the cluster?

... when I created the Windows Failover Cluster, it created successfully but gave me this Warning:

Warning: No appropriate disk could be found for the Witness disk. I didn't see a...

Thanks BrownCoat42. Because I have 4 databases, I will use a regular availability group. 2 nodes 1 primary replica and only 1 secondary replica.

I'm not sure about the listener. Will...

Thanks, Beatrix. Of course, I need high-availability. But as this instance has 4 databases, I would have to create 4 Basic Avail Groups if I choose Basic. But Both instances...

Thank you, Phil.

1. I don't see the link you referred to

2. These packages work well on the old 2012 instance (Visual Studio 2012). Are you suggesting I install VS 2012...

Some more information:

In the Integration Services 2014 Project Conversion Wizard, it shows Package Status "Not Loaded", "One or more packages are not ready".

Also "Cannot create a task for XML for...

Thank you Phil Parkin. There is no solution on the 2012 instance only project and package files. I have attempted the upgrade but it failed with errors. I will post...

Thank you, Sue H/Old Hand. That article sure seems to apply to my situation. I was hoping I could avoid manually importing 50 SSIS packages but maybe not.

This seems...

Thank you, Pouis. Your idea helped. I also had to tweak 1 line in my stored procedure. It works now and that variable value is available

in other tasks. (I plan...

Have you checked the Windows Task Scheduler tasks? I really don't like those because they can be overlooked when you're looking for jobs....

Have you checked the Windows Task Scheduler tasks? I really don't like those because they can be overlooked when you're looking for jobs....

Thanks Jack.

Yes, I actually rebooted this server before I checked the value of machinename, servername.

select @@servername does return the correct name.

but SELECT serverproperty('ServerName') still reflects the old name.