take good care NOT having a windows-account as jobowner. (make it a SQLuser which has enough permissions to run the dts-packages)

If you are using a windows-account as jobowner, you'll find...

Yes, Yes, Yes

1. Should not be dependant on Outlook or MAPI components like Microsoft Exchange profile etc. Should be able to use POP3 or SMTP mail services to send mails.

2....

just to remind you sysdepends is not a full solution. (create a stored proc that calls an sp that does not yet exist. you'll get a notification)

- sql profiler for a while

- check its results

- sql profiler to support the next step and gather the errors

- rename 'tobedeleted' views to 'obsolete'

- after a while

- stop sqlprofiler

-...

The table is still functioning because the row-data-length did not yet reach the maximum limit for a page.

However, sqlserver did raise a warning regarding this issue at creation time of...

check http://www.riverland.net.au/text/look_first/netcode.html

it has a litle list and also has some smily explanation.

There also exists a sp_cycle_errorlog.

Downside of this is that it apears not to be working when used in a sqlagent job.

(complaints abount not being sa, even if I make sa...

correct, noeld.

if you have e.g. hp-openview monitoring software, you could have your last step raise an error (user defined errormessage / alert) to the windows eventlog, and hp-openview could pick it...

AFAIK there is no feedback to the job launched by sqlagent and it will only document that the job is started by the alert-related jobschedule. Based on this, I guess...

script it from the old db and run the script on the new db, removing the script-references to the old db.

- did you perform checkdisk ?

- does the server report memory-bank-problems ? (eventvwr/system)

how about this :

select e.deptno, e.ename, e.job, M.MaxSal

from emp e

inner join

(select deptno, max(sal) as MaxSal from emp group by deptno) M

on e.deptno = M.deptno

Keep it simple and stupid.

Follow Jonathan's guidelines.

check the ISDATE function in BOL