Viewing 15 posts - 16 through 30 (of 40 total)
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...
January 12, 2005 at 10:03 pm
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...
January 4, 2005 at 1:27 pm
select top 7 * from table-name
January 4, 2005 at 11:56 am
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...
January 4, 2005 at 10:57 am
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...
January 4, 2005 at 7:46 am
I wonder how quickly the LOG is filling? I.e. could we have some sort of loop going on between triggers say?
Ian
January 4, 2005 at 7:29 am
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...
October 14, 2004 at 11:11 pm
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...
October 5, 2004 at 7:45 pm
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...
September 24, 2004 at 6:07 pm
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...
June 26, 2004 at 3:06 am
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...
June 25, 2004 at 2:27 am
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...
May 17, 2004 at 12:30 am
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...
May 6, 2004 at 10:59 pm
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...
April 12, 2004 at 12:26 pm
Viewing 15 posts - 16 through 30 (of 40 total)