• I've just ran the small script that you can see bellow on SQL Server 2012 and it worked without any problems, so I don't think that the problem is that it doesn't recognize the table because of its name. Try to run the script in your environment and see if it works.

    Problems that I've encountered in the past that may or may not be relevant in your case are – you are misspelling the object, object was dropped and you are not aware about it, the server is case sensitive and the table's name is not just with capital letters, you are using the wrong server name/database name/schema name when you use the 4 name convention.

    use tempdb

    go

    create table STOPLIST (I INT)

    go

    insert into STOPLIST (I) values (1)

    select * from STOPLIST

    go

    drop table STOPLIST

    go

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/