I would look at the functions and either convert them to iTVF or eliminate them. In fact, I would get rid of all of the functions on the select...

If there isn't any database corruption - then my guess is someone cleared the history. How are you checking the job history?

Wait...just realized you are talking about jobs. ...

You need to check the maintenance plan history - not the agent job history. To do that, right-click on the maintenance plan in Object Explorer and view history.

This will...

Sridoc2020 (8/28/2011)

---

I would like to know how to increase Drive space (SAN) on existing Drive. I have drives which holds data files on one, and log files on another Drive...

First, run an integrity check on the MSDB database:

CHECKDB(msdb) WITH no_infomsgs, all_errormsgs;

If that comes back clean, then look for a maintenance task that is set to cleanup history. Validate...

And us old dogs have a much harder time learning new tricks...:w00t:

You need to work with your Microsoft Representative to identify the best licensing for your situation.

Be very careful when looking at licensing on virtual machines. If you buy the...

Tracey,

You have put the synonyms on the wrong server. What you want to have is a single synonym on SQL02:

CREATE SYNONYM dbo.Orders FOR TEST_LINK.DATABASEA.Cust.Orders;

Then, your code on SQL02 would...

Synonyms are the right answer - I am not clear why you say this doesnt work. On the test system, you would create the synonyms as:

CREATE SYNONYM MySchema.Table FOR...

Just note that XCOPY has been deprecated in Windows Vista and Windows Server 2008 and above.

The replacement is Robocopy - according to the help if you run XCOPY /? on...

Isn't virtual employees the same as telecommuting? Or is that off-shoring I'm thinking about 😀

Why would you be required to do this from SQL Server? This is much better handled outside of SQL Server using any number of techniques.

My preference for something like...

When looking to consolidate, you also have to be aware of security requirements. Many vendor applications require sysadmin rights - as well as the vendor support requiring sysadmin rights.

If...

It appears to work because in the design view...

Just to clarify:

Clustering is for HA (High Availability) - and wouldn't be a choice for DR unless you want to get into geographic clusters (which isn't really DR, but can...