Transactional Repliaction Error

Việt Hoàng 0 Reputation points
2023-10-25T09:38:16.32+00:00

How can I get the command generating the error?

Command attempted:

if @@trancount > 0 rollback tran

(Transaction sequence number: 0x0000062F000003B2000500000000, Command ID: 1)

Error messages:

Invalid object name 'dbo.test'. (Source: MSSQLServer, Error number: 208)

Get help: http://help/208

Invalid object name 'dbo.test'. (Source: MSSQLServer, Error number: 208)

Get help: http://help/208

Screenshot 2023-10-25 163941

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,116 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,582 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,591 Reputation points
    2023-10-26T01:57:56.71+00:00

    Hi @Việt Hoàng,

    Invalid object name 'dbo.test'. (Source: MSSQLServer, Error number: 208) Get help: http://help/208

    Possible Causes

    This error can be caused by one of the following problems:

    The object is not specified correctly.

    The object does not exist in the current database or in the specified database.

    The object exists, but could not be exposed to the user. For example, the user might not have permissions on the object or the object is created within an EXECUTE statement but accessed outside the scope of the EXECUTE statement.

    Check it out here.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.