IF you are NOT running this SQL from the server holding the SQL Database, it doesn't know which Server to connect to.

If you ARE running this from the server, my comment...

This is a known problem, involving a UDF in the join clause of a sub-query.

http://support.microsoft.com/default.aspx?scid=kb;en-us;819264

Thanks for your response.

I searched msdn, but couldn't find anything which sounded like this, except for 321879, which CAN'T be the cause, because none of our SQL Servers have shut done...

Look up ISNULL() in BOL.

Use it inline, instead of updating the base tables.

You usually don't want to use FLOOR, as this causes a conversion to float, which is an APPROXIMATE number.  Stick with human-style math, like the ROUND with truncation mentioned in...

SELECT DISTINCT QuoteID, Country

                       FROM          dbo.tblSchedule

                       GROUP BY QuoteID, Country

You don't need the DISTINCT, since you are using GROUP BY.

You appear to be missing an ending parenthesis for the EXISTS,

and pif_date is not compared to anything.

IF EXISTS (SELECT pif_mem_no FROM preneed.dbo.tbl_new_pif_plans

WHERE pif_processed IS NULL AND pif_date<DATEADD(WW,-2,GETDATE()))

EXEC master..xp_sendmail

Date "0" for MS SQL Server is Jan. 1, 1900,

NOT Dec. 30, 1899.

There is NO subquery in the Update statement you posted.

Did you notice that the error mentioned a UserDefinedFunction

"deficit_year_calc?".  The subquery is probably in the UDF, which

may be in a...

Look at "DBCC CHECKIDENT" in BOL.

A late thought...

The function idea has one "hole" - if an empty or null varchar is passed.

imho, use:

RETURN(SELECT ISNULL((DATALENGTH(@String) - DATALENGTH(REPLACE(@String, @Search, '')))

         / NULLIF(DATALENGTH(@Search), 0), 0))

I've been "bit"...

The NOCHECK option was NOT used.

Any other thoughts?

Note the difference in results, depending on which server was used to run the SELECT.

You should also recognize that a Trigger can be altered, disabled, or dropped by any person with sufficient permissions.  Log-reading applications can solve some of this, but Logs can also be...

Another little "gotcha."

The abbreviation "Sr" may mean either "Senior" or "Sister."

For "Sister", it is usually given before the name,

while "Senior" usually trails the rest or the name.

Also, names like "Mary...

I get an 87% / 13% load... and 85% of the load of the first query goes for the count(*). The strange thing is that when I do top 500...