Master Data Services many tables starting with starting tbl

  •  

    Hi All, I can see many tables under MasterDataServices like below in an existing server. tbl_* and others within mdm schema. Any idea or hints/links how these would have got created? Is this automatically created by the MDS setup/process itself? Context is we are migrating all the MDS data to another sql server and have no idea on these tables and how they are created.

    Screenshot 2025-02-20 at 11.13.20

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • You don't have anybody building databases in Access do you? That's where I'd look.  My guess is that someone has permissions on your Master Data Services instance that he shouldn't. "tbl" is "Hungarian" notation for a table in Access, so my guess is that it either came from there, or you have an Access developer playing with one of your SQL Server instances.

Viewing 0 posts

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