SQL SERVER – How to Refresh SSMS Intellisense Cache

Are you getting the little red squiggly lines on your code in SQL Server Management Studio?  You may need to refresh the intellisense cache.  There are two ways to do this:

1.  CTRL + SHIFT + R .

2. or use the menu EDIT / Intellisense / Refresh Local Cache

 

Advertisements

How can I move SQL Server Agent Jobs from one Server to Another?

You can move SQL Server Agent jobs from one server to another by scripting the jobs.  The best way is by opening up SQL Server Management Studio.

Select View Object Explorer from the  VIew Menu in SQL Server Management Studio.

Object Explorer Details

From the Object Explorer Details window select all the jobs that you want to copy. Right click and select Script Job As then Create To ,  New Query Editor Window.

Select Jobs

This will create one script for all the jobs.  This script can be saved then run on the new server.  This will recreate all of the jobs on the new server.