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...

I've updated the T-sql text in my previous reply ! (also included tabulation-char) .

Watch out for UDF's. sp_stored_procedures...

tricky but maybe ...

-- ALZDBA dd 18/03/2004

-- convert sp to with encryption

set nocount on

DECLARE @SearchString varchar(255)

Declare @WhichProcs varchar(255)

Declare @sp_owner varchar(255)

select @WhichProcs = '%spc%',  @sp_owner = '%'

DECLARE @spcount int,

 @spLoopCount int,

 @proc_name...

First take a look at the articles diogenes0412 mentioned !

then try this.

Clone sqlserver-server (i.e. keep servername,...)

- install windows...

- what's the filter-factor of the columns in your index ?

- what portion of data would be part of your query ?

as you have noticed, RI should have an index per FK-definition (unless the overlap is matching columnorder and sortdirection), otherwize indexes might not be used for RI-purposes.

Maybe use this to put them offline when sqlserver is started :

(you must be sysadmin to install this)

use master

create procedure sp_MyOwn_SetUserDbOffline

as

set nocount...

- are there any indexes on the foreign-key-columns to support the delete-join ? (with all child-tables)

- If yes, are the columns in the same columnorder and sortorder(asc/desc) as the parent...