Error 3521
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am getting the following error "Error 3521: Improper Qualified Name (too many dots). I have not seen any other errors like this, but was wondering if any one has ran into it? I have taken all alias's out of my query and am still getting the same error.
- Labels:
- In Database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @cyoung3
Could you share some more context? This is from a query, but are you using the Input tool? to SQL Server? Can you share the query?
Have you tried putting the table name in quotes as suggested in this post?
https://stackoverflow.com/questions/51307067/periods-in-table-names-causing-errors
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As @CharlieS suggested, it happens maybe because you are not quotating table name with Non-standard identifiers.
https://stackoverflow.com/questions/51307067/periods-in-table-names-causing-errors
As documented in the manual in SQL, non-standard identifiers have to be quoted with double quotes:
