Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Rob1412

    EXCHANGE SERVER NOT SEEN IN LAN WHEN THERE IS NO INTERNET.

    WHEN I DISCONECT MY INTERNET CONECTION OR WHEN MY ISPs conection is down , MY LOCAL USERS CAN NOT SEE THE MAIL SERVER , SEND LOCAL E-MAILS OR CHECK ANYTHING THROUGH THEIR OUTLOOK CLIENTS. I AM SEEING THE FOLLOWING ERROR MESSAGE IN THE EVENT LOG. Process MAD.EXE (PID=2580). All Global Catalog...
  2. Rob1412

    Error send E-mail CDO Object

    Nope doesn't work when i comment the Sendusing Line. An error message is given "The Sendusing configuration value is invalid".... How could i be certain which port to use??? Where can i see which ports are used for what???.. Can this code be run on any client computer????
  3. Rob1412

    Error send E-mail CDO Object

    Need help here... I got this code from another thread i would apreciate anybody giving a hand When I set the variable cdoSendUsingPort = 25 as indicated in the original trhread i get an error message "Error 3749 Fields Update Failed. For further information , examine the Status property of...
  4. Rob1412

    Cursor error when executing Job

    OK , Everyone seems to have the same opinion on the use of cursors, could you give me a simple example on how to avoid using them. Because i really don't see anyway around them. Enlighten Me
  5. Rob1412

    Cursor error when executing Job

    I'm afraid it doesn't have anything to do with users because the job starts of fine and it seems to work alright when i'm processing one day it completes the job. To be a little more exact here is a bit of code where i seem to have the problem but i've noticed that the problem happens in the...
  6. Rob1412

    Cursor error when executing Job

    I have a job which executes a Stored procedure which in turn executes a series a stored procedures. Now I've executed this main stored procedure through the query analyzer and it executes correctly , but when i try to execute it through a job i get error The cursor is not open. [SQLSTATE...
  7. Rob1412

    NULL DOESN'T BEHAVE IN STORED PROCEDURES

    I have this function but the if does'nt seem to be working correctly , I believe it's because of the comparison with null, I've had this problem before but gotten around it using the 2nd method which i'm not really fond of. ---------------method wanted ALTER FUNCTION RETURN_BLOQUEO...
  8. Rob1412

    execute stored procedure with job

    Thanks alot. I'll use it right away then.
  9. Rob1412

    execute stored procedure with job

    I was wondering if I executed the following sp through Access so that i could start a job, would access wait till the job would finish or would it give me a time out due to the fact that the job is extensive? exec sp_start_job @job

Part and Inventory Search

Back
Top