Forum Replies Created

Viewing 15 posts - 16 through 30 (of 40 total)

  • RE: SMTP - Possible permissions problem?

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

  • RE: selecting the first 7 out of 1000 rows. How can i do this?

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

  • RE: selecting the first 7 out of 1000 rows. How can i do this?

    select top 7 * from table-name

     

  • RE: DTS Problem

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

  • RE: DTS Problem

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

  • RE: Transaction Logs filling up

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

    Ian

  • RE: best way to send email from SQL Server 2000?

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

  • RE: Re-install ODBC?

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

  • RE: Re-install ODBC?

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

  • RE: Quick Ques about variables & speed...

    Thanks.

     

  • RE: best way to send email from SQL Server 2000?

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

  • RE: best way to send email from SQL Server 2000?

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

  • RE: Creating an Access table from SQL Query Analyzer

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

  • RE: Creating an Access table from SQL Query Analyzer

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

  • RE: DTS - How do I create and reference a global variable?

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

Viewing 15 posts - 16 through 30 (of 40 total)