Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: Microsoft SQL Server: Error 208 - Invalid Object Name

Results 1 to 5 of 5
Share This Thread →
  1. #1
    banuachu is offline Registered User
    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
    micky's Avatar
    micky is offline Couch Potato Wizard
    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!

  3. #3
    banuachu is offline Registered User
    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

  4. #4
    micky's Avatar
    micky is offline Couch Potato Wizard
    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

  5. #5
    banuachu is offline Registered User
    Join Date
    Apr 2006
    Posts
    4
    Rep Power
    0
    Quote 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

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates