error message: "Msg 208, Level 16, State 1, Line 1: Invalid object name 'dbo.Customers'.

vivek 25 Reputation points
2024-02-25T15:33:48.63+00:00

Hai guys Whenever I try to execute a query, I keep getting the following error message: "Msg 208, Level 16, State 1, Line 1: Invalid object name 'dbo.Customers'. im sure that the 'Customers' table exists in my database.

Azure SQL Database
{count} vote

Accepted answer
  1. Azar 29,520 Reputation points MVP Volunteer Moderator
    2024-02-25T15:54:45.7266667+00:00

    Hi vivek

    I guess tihs indicates that the SQL Server is unable to find the specified object, 'dbo.Customers', in your database. Let me drop you a few troubleshoot

    Double-check the schema and table name in your query. Ensure that 'Customers' is indeed located in the 'dbo' schema. If the schema is different, make sure to qualify the table name appropriately in your query (e.g., 'myschema.Customers').

    verrify that you're connected to the correct database in your SQL query session. Sometimes, users may unintentionally execute queries in the wrong database context, leading to object not found errors.

    Make Ensure that the user executing the query has the necessary permissions to access the 'Customers' table. Check for any permission issues or role memberships that might be restricting access to the table.

    If this helps kindly accept the answer thanks much

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.