#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Apr 2006
    Posts
    4
    Rep Power
    0

    Unhappy Microsoft SQL Server: Error 208 - Invalid Object Name


    Hi
    I ahve a stored procedure reprting all call log's...When i execute the procedure wiht query analyser i get the error...


    Microsoft SQL Server: Error 208 - Invalid Object Name
    Invalid object name "table name"

    Will be grateful if someone can help me..

    Thanks in advance...Please help me...I am veyr much in need of this procedure to run
    Banu
  2. #2
  3. Couch Potato Wizard
    ASP Mastermind (5000+ posts)

    Join Date
    Jan 2005
    Location
    India
    Posts
    13,652
    Rep Power
    2685
    hi banu, welcome to the forum
    i think there might be a wrong table name in ur stored procedure.
    but if u want anybody to help u, u'll need to post the relevant code here.
    Laziness is my religion and Sunday is my God

    Get the Mantra!
  4. #3
  5. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Apr 2006
    Posts
    4
    Rep Power
    0
    Hi micky..Thanks for that reply...

    That was very quick...Glad...Well my code is very simple I ahve seven tables form which i am extracting data ...so i use a few joins and doing it...

    This is my procedure..I am new to SQL and not sure whether this is ok to extract the data..Hope u could helpo me in this...

    create procedure rpt_call_log @ rpttime int as

    SELECT AHD_issue.id, AHD_issue.ref_num, AHD_ctct.c_last_name, AHD_ctct.c_public_phone, AHD_issue.description, AHD_issue.status, AHD_isscat.sym, AHD_issue.active_flag, AHD_repmeth.sym, AHD_toc.sym, AHD_perscon.sym, AHD_issue.priority, AHD_ctct_1.c_last_name, AHD_issue.group_id, AHD_issue.support_lev, AHD_issue.open_date, AHD_issue.resolve_date, AHD_issue.close_date, AHD_issue.actions, AHD_issue.log_agent
    FROM AHD_isscat
    RIGHT JOIN (AHD_repmeth RIGHT JOIN (((AHD_ctct AS AHD_ctct_1 RIGHT JOIN (AHD_issue LEFT JOIN AHD_ctct ON AHD_issue.requestor = AHD_ctct.id) ON AHD_ctct_1.id = AHD_issue.assignee) LEFT JOIN AHD_toc ON AHD_issue.type_of_contact = AHD_toc.id) LEFT JOIN AHD_perscon ON AHD_issue.person_contacting = AHD_perscon.id) ON AHD_repmeth.id = AHD_issue.reporting_method) ON AHD_isscat.code = AHD_issue.category;


    Banu
  6. #4
  7. Couch Potato Wizard
    ASP Mastermind (5000+ posts)

    Join Date
    Jan 2005
    Location
    India
    Posts
    13,652
    Rep Power
    2685
    Sorry Banu, i myself am poor in writing queries using Joins
    but there r lot of experts here, but u'll need to wait little for them
    sorry cudnt help u
  8. #5
  9. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Apr 2006
    Posts
    4
    Rep Power
    0
    Originally Posted by micky
    Sorry Banu, i myself am poor in writing queries using Joins
    but there r lot of experts here, but u'll need to wait little for them
    sorry cudnt help u
    No problem...Hope somebody helps me out...Thanks

Similar Threads

  1. Microsoft SQL server setting
    By sinner8347 in forum Microsoft SQL Server
    Replies: 1
    Last Post: April 17th, 2006, 07:40 AM
  2. Executing SQL
    By erickh in forum ASP Development
    Replies: 5
    Last Post: March 31st, 2006, 03:39 AM
  3. Having trouble with AND, iCounter in SQL
    By gilgalbiblewhee in forum ASP Development
    Replies: 3
    Last Post: April 6th, 2005, 12:44 PM
  4. insert query
    By jamesjohn in forum ASP Development
    Replies: 1
    Last Post: March 17th, 2004, 11:36 PM
  5. MS SQL Server 7 access is denied in EM after SP4
    By Hawkinpaul in forum Microsoft SQL Server
    Replies: 1
    Last Post: October 30th, 2003, 04:45 PM

IMN logo majestic logo threadwatch logo seochat tools logo