Can you check what Plan do you get NOW if by any chance you get Index spool there is another of these nasty bugs hidden in those waters

Some models for you too:

http://www.databaseanswers.org/data_models/index.htm

Sure, nothing like saving a few nights of bad sleep and hearing the client did you fix it yet, ... did you fix it yet ... did you fix it...

Isnt it great that the most simple things tend to be usually the most powerful ones

SQL Server is very picky whenit comes to timings and sometimes on High-End systems it can trigger that error during AUTOGROW (which you should avoid at all costs) and File...

Unfortunately for me I have hit that bug times, in the begining it cost me some hair  

That's sleek

Assuming that the Poster is not using SP4 (most of us aren't ) he just hit and old bug in SMP systems:

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

I still don't see the need for sysadmins rights. if the issue is that he needs access to xp_cmdshell, just make sure you set up the proxy account for the...

have a look at sp_makewebtask. BTW it is a BAD idea to send emails from a trigger. Use a separate Job for that.

The Problem with a linked table is that the "Filtering" of the data (depending of course on what you are doing) happens on the FRONT END, with SPs is done...

me too

The problem with remote (linked) tables and Access BOUND forms is the they perform TABLE LOCKS therefore multiuser enviroments are really hampered. The reason I believe your Local  Table is read...

Have you tried your query with (MAXDOP = 1)?

Besides:

ASCII(@myCol) >= 48  works for a SINGLE character not multiple you may need more than that if parsing is needed