Post reply

Database Problem

  • January 3, 2008 at 8:26 pm

    #70624

    We have a database named Foreign i cant query in this database because the word 'Foreign' is used in SQL Server and not recognized as a database name is there any possbile solution to this?

    Example:

    --When i run this script

    Foreign..sp_tables

    /*

    I recieved this error

    Server: Msg 156, Level 15, State 1, Line 1

    Incorrect syntax near the keyword 'Foreign'.

    */

    "-=Still Learning=-"

    Lester Policarpio

  • January 3, 2008 at 9:07 pm

    #764642

    Just enclose the word Foreign within box braces... [Foreign]

  • January 3, 2008 at 10:09 pm

    #764655

    Thank you very much so dumb to ever think of it hehehehe

    "-=Still Learning=-"

    Lester Policarpio

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply