Hi,

I'm still at a loss on this one.

Company expert suggests I write my own utility however I am heavily invested in sp_send_cdonts so am considering a re-installation of SQL server.

Any...

Steve is absolutely right.

Order by __ ASC\DESC, where __ and even indexing etc. can all play a part depending upon how the table is set up and what the actual output...

select top 7 * from table-name

When you manually run a DTS package, YOUR own logon account (credentials and permissions) are used for all access requirements. 

Note: SQLSERVERAGENT is a Windows service and NOT part of SQL Server.

Think of SQLSERVERAGENT...

Just a caution that SQLSERVERAGENT account may also require suitable access on the local server.

For this we used a generic account (owned by dba) which was given admin access on local...

I wonder how quickly the LOG is filling? I.e. could we have some sort of loop going on between triggers say?

Ian

Hi,

We're on Lotus Notes and I send e-mails from an intranet server and also from SQL Server CDO.

We had to have the Company (internal) SMTP mail server set to accept...

Many thanks for the kind assistance. Sorry for late response (working almost 24/7)

The day after posting thread I got SQL Server re-installed. What a rush - deadlines etc.

Did many things I.e. removing...

Hi again,

Ran Office "Detect and Repair" which also bombed out with Error 1919 and ODBC Error 6 relating to "Component not found in registry"

Phew, never realised un-installing SQL was so...

Thanks.

Glad it (CDO) worked for you too.

My company (a UK/International Logistics firm) also runs Lotus Notes however installing Notes Clients on SQL Servers was seen as less efficient (than CDO) and more costly...

Were you using sp_send_cdontsmail? If so, you could make copies of it in any databases where it is needed?

sp_send_cdontsmail is found in the Master db which requires sysadmin permission however, copies of it will work...

Snap. I'm in a very similiar situation.

Until I (eventually) get all Access tables and functionality into SQL Server, I have to update (DTS) each night and use SMTP email to...

Perhaps I'm missing the point here -

a. to datestamp new records I would create a DATE FIELD and set the DEFAULT value to [getdate()]

b. user-stamping records depends on the...

Thank you to both of you,

Had tried code however I was unable to reference global variable in EXEC SQL tasks.

Seemed a choice between doing everything in code or everything in...