replace the "distinct" with a "group by" if you can, it might get index-only access, whilest distinct is an extra passthroug of the resultset .

- http://www.sql-server-performance.com/cursors.asp

- http://www.sql-server-performance.com/dp_no_cursors.asp

- http://www.sqlservercentral.com/articles/articlesexternal.asp?articleid=477

your last "group by" is not allowed.

How about :

update ft

  set ft.peso= fiii.NewPeso

from ft

inner join fi fii

on ft.ftstamp=fii.ftstamp

and ft.fdata between '20040201' and '20040229'

inner join

   (select...

sqlagent needs to be restarted when you activate the first alert.

- If it occurs while running the sp :

check your network-card/cable the computer where you get the error.

If it occurs on #-computers, check network-card/cable at the server.

- Check out if...

Very nice

Many have been searching for this and (like I did) build their own sqldmo-solution.

"Therefore, I am trying to create very general indexes on each table that will serve generic needs (my attempt at half-way optimizing the DB).  So each table has a unique...

How about renaming sp_start_job temporary and await what's going wrong

Even when disabled, one can still start a job manualy !

ifaik the schedules will not launch the job because it is disabled.

If you doubt it, you could still disable all...

there is a sqldmo example for this delivered if you have checked for example-files to be installed.

It will need to be modified because it...

Is your "old" server obsolete ?

if so : clone your "old" server to your new one, so you can avoid the naming problems.

That is not what I mean.

In my previous reply I altered the sp so it would use only known values !

What you want to perform -IMO- is to have predicates...

Does sqlmail also work when you have a remote sql-connection (not on the server itself) ?

What 's the sql-version (and sp / hotfix) ?

did you stop and restart sqlagent ?

(should not be an issue, but you never know)

btw, I mostly use smtp-mail (http://www.sqldev.net)

You'll need to alter the service-accounts for sqlagent and sqlserver to a windows-account that has access to your mail-server and mailbox.

afaik local administrator has no network authority

Avoid NULL !

ALTER procedure _getInvoices ( @DateFrom as datetime = null, @DateUntil as datetime) AS

if @DateFrom  IS NULL

begin

   set @DateFrom = '1900-01-01 00:00:00.000'  

end

if...