---
title: "Resolve references: Error TSD03006 IN VSTS DB GDR"
description: "Resolve references: Error TSD03006 IN VSTS DB GDR"
---
# Resolve references: Error TSD03006 IN VSTS DB GDR
Posted by Ryan Riehle - July 07, 2009
- [**](https://www.facebook.com/sharer/sharer.php?u=https://blogs.incyclesoftware.com/2009/07/resolve-references-error-tsd03006-in-vsts-db-gdr/)
- [**](https://www.linkedin.com/shareArticle?mini=true&url=https://blogs.incyclesoftware.com/2009/07/resolve-references-error-tsd03006-in-vsts-db-gdr/&title=&summary=&source=)
- [**](https://twitter.com/home?status=)
- [**](mailto:?&subject=https://blogs.incyclesoftware.com/2009/07/resolve-references-error-tsd03006-in-vsts-db-gdr/&body=https://blogs.incyclesoftware.com/2009/07/resolve-references-error-tsd03006-in-vsts-db-gdr/)
**
Are you getting an error with VSTSDB relating to references of system views / objects in your database, like INFORMATION_SCHEMA or sys.columns? I was too – my first thought was to create a reference to the master database or a server project, but that didn’t work. To resolve this error, you need to know about some of the dbschema meta-data files included with the installation of the GDR. I’ll explain the purpose and the appropriate use of these files,including how to get rid of your TSD03006 error, and how these .dbschema files differ from the ones that are created when you build your database (and server)projects. Please note that the information here relates to VSTS Database Edition GDR R2, and may apply a little differently (if at all) to earlier versions of VSTS Database Edition (VSTSDB).
When you create a new database project and import an existing database, VSTS creates a model of your database, but it doesn’t include everything by default. In order to improve project loading time and the performance of database projects, Microsoft isolated database system views and objects like INFORMATION_SCHEMA, splitting out certain objects and meta-data into separate schema files that can be found (by default) at:
*C:\Program Files\Microsoft Visual Studio 9.0\VSTSDB\Extensions\SqlServer\2005\DBSchemas*
You can replace the 2005 with 2000 or 2008 in the path, depending on the version of SQL Server you are dealing with. The schema files you’ll find in this folder are:
- master.dbschema
- msdb.dbschema
- Microsoft.SqlTypes.dbschema.
# master.dbschema
Master.dbschema contains system object types like system views and stored procedures (see the table below for more details). I was working with a client that had views referencing INFORMATION_SCHEMA.COLUMNS. For example:
```
CREATE VIEW vErrorLog_Columns
```
```
AS
```
```
SELECT COLUMN_NAME AS col
```
```
FROM AdventureWorks.INFORMATION_SCHEMA.COLUMNS
```
```
WHERE TABLE_NAME = 'ErrorLog'
```
If you create a new database project and import the schema of an existing database that contains a reference to this view, or if you create a new view in your project that contains a similar reference, you will get errors similar to the following:
> *TSD03006: View: [dbo].[vErrorLog_Columns] has an unresolved reference to object [AdventureWorks].[INFORMATION_SCHEMA].[COLUMNS].*
Adding a reference to the master.dbschema file I mentioned above will resolve the references; However, there are a LOT of objects defined in the master.dbschema file, and so adding a reference to it will likely slow down your project enough to be annoying, so you may want to trim it down considerably. Before doing so, you’ll want to create a copy of the master.dbschema file, as you’ll want to save the original for future changes. You can start by deleting everything from within the element, and then adding back only the elements for objects you are referencing in your database project. It’s a good idea to include this file with in your source control repository or put it in a central location so that other database developers working on the database can get to it.
Apparently, errors related to tempdb can be [resolved in a similar fashion](http://blogs.msdn.com/gertd/archive/2009/06/10/system-objects-in-tempdb.aspx).
# Referencing Server Projects vs. master.dbscHema
OK, so what else is in this large master.dbschema file, and how is referencing master.dbschema any different than referencing a server project or a .dbschema file built from a server project – after all, isn’t a server project composed of objects that are in the system master table? hrmmm….
As I mentioned earlier, the following table lists the different types of objects within the master.dbschema,file:
| **Contents of master.dbschema** |
| --- |
| INFORMATION SCHEMA views |
| system catalog views |
| system dynamic management views |
| system dynamic management functions |
| system stored procedures |
| system extended stored procedures |
| system compatibility views |
It turns out that the master.dbschema file and the .dbschema file built from a server project are mostly unrelated, in that they serve different purposes. It’s confusing in part because a Server project contains data imported from the master database, and well… master.dbschema also relates to the system master table and has the word “master” in the file name.
Nothing you do to your server will effect the contents of the master.dbschema file; It holds static definitions of *system *objects. These are defined in the master database, and are inherent to the capabilities of the version of the SQL Server instance you have installed; The system objects are not deployed to the resulting server, as it is assumed that they already exist on that target server; they are part of the SQL Server version you are using and if they are different or missing, chances are that you have a corrupt installation.
On the other hand, Server projects consist of user objects added to the master database that can be deployed to the target environment; these include logins, linked servers, etc… So, while the contents of the master.dbschema file will only validate references to system objects in your T-SQL, referencing server projects will effect your deployment as they can include custom objects.
# msdb.dbschema
Contents of the msdb.dbschema include a model of the msdb database, so if your database contains references to objects in the msdb database, which are typically used to store information about SQL Server Agent jobs and replication activities, then you will want to create a reference to this file in the same way. This file isn’t small, but you should avoid making changes to it; some of the changes I made trying to trim it down led to errors related to missing references.
# Microsoft.SqlTypes.dbschema (2008 only)
The Microsoft.SqlTypes.dbschema is specific to SQL Server 2008 and was added to support its [new built-in data types](http://technet.microsoft.com/en-us/magazine/2008.04.datatypes.aspx?pr=blog): *geometry*, *geography*, and *heirarchyId.* If your project is not a SQL Server 2008 or does not use these datatypes, you can safely remove the reference. Though, it is pretty small compared to the other .dbschema files we mentioned, so referencing it shouldn’t effect the performance of your project to any noticeable degree.
Topics: [Blog](https://blogs.incyclesoftware.com/topic/blog)
---
### Recent Posts
By InCycle - 07 July, 2009
#### InCycle Wins Prestigious Microsoft Global Partner of the Year Award
[](https://blogs.incyclesoftware.com/incycle-wins-prestigious-microsoft-global-partner-of-the-year-award)
By InCycle - 07 July, 2009
#### Top 5 Questions On Elevate for App Modernization
[](https://blogs.incyclesoftware.com/top-five-questions-on-elevate-for-app-modernization)
By InCycle - 07 July, 2009
#### GitHub Universe 2025 Top Announcements
[](https://blogs.incyclesoftware.com/github-universe-2025-top-announcements)
---
### Subscribe to Blog
### 
### About this blog
Since 2002, InCycle has been providing challenging thought leadership to help customers successfully combine modern application designs, IT platforms and DevOps practices to achieve new levels of success. As a leader in app modernization, these blogs are written by our expert consultants and provide useful information to help on your journey to the cloud and better software. Happy reading!
### Platform Engineering Webinar on Demand
PE deep dive and demo!
[](https://cta-redirect.hubspot.com/cta/redirect/707613/aae0556f-2d26-4ce4-9b32-e7bebd443c9a)
### Recent Posts
### Migrating to GitHub?
Start with a GitHub Migration Strategy and Roadmap (at no cost!)
[](https://cta-redirect.hubspot.com/cta/redirect/707613/312dc03f-1f78-4907-aaaf-3c0aa3cccd8f)
### Posts by Topic
- [Blog (194)](https://blogs.incyclesoftware.com/topic/blog)
- [Video (32)](https://blogs.incyclesoftware.com/topic/video)
- [Azure (25)](https://blogs.incyclesoftware.com/topic/azure)
- [DevOps (20)](https://blogs.incyclesoftware.com/topic/devops)
- [GitHub (13)](https://blogs.incyclesoftware.com/topic/github)
- [InRelease (12)](https://blogs.incyclesoftware.com/topic/inrelease)
- [Containers (11)](https://blogs.incyclesoftware.com/topic/containers)
- [release management (11)](https://blogs.incyclesoftware.com/topic/release-management)
- [AKS (10)](https://blogs.incyclesoftware.com/topic/aks)
- [CI/CD (10)](https://blogs.incyclesoftware.com/topic/ci-cd)
- [Kubernetes (10)](https://blogs.incyclesoftware.com/topic/kubernetes)
- [Azure DevOps (9)](https://blogs.incyclesoftware.com/topic/azure-devops)
- [Migration (9)](https://blogs.incyclesoftware.com/topic/migration)
- [Platform Engineering (PE) (9)](https://blogs.incyclesoftware.com/topic/platform-engineering-pe)
- [GenAI (8)](https://blogs.incyclesoftware.com/topic/genai)
- [Microsoft Azure (8)](https://blogs.incyclesoftware.com/topic/microsoft-azure)
- [Visual Studio (8)](https://blogs.incyclesoftware.com/topic/visual-studio)
- [tfs (8)](https://blogs.incyclesoftware.com/topic/tfs)
- [Awards (7)](https://blogs.incyclesoftware.com/topic/awards)
- [Big Data (6)](https://blogs.incyclesoftware.com/topic/big-data)
- [Innovation (6)](https://blogs.incyclesoftware.com/topic/innovation)
- [Microsoft (6)](https://blogs.incyclesoftware.com/topic/microsoft)
- [agile (6)](https://blogs.incyclesoftware.com/topic/agile)
- [vsts (6)](https://blogs.incyclesoftware.com/topic/vsts)
- [Data (5)](https://blogs.incyclesoftware.com/topic/data)
- [Modernization (5)](https://blogs.incyclesoftware.com/topic/modernization)
- [App Modernization (4)](https://blogs.incyclesoftware.com/topic/app-modernization)
- [Automated Testing (4)](https://blogs.incyclesoftware.com/topic/automated-testing)
- [Data & AI (4)](https://blogs.incyclesoftware.com/topic/data-ai)
- [Event (4)](https://blogs.incyclesoftware.com/topic/event)
- [MLOps (4)](https://blogs.incyclesoftware.com/topic/mlops)
- [Modern Apps (4)](https://blogs.incyclesoftware.com/topic/modern-apps)
- [Visual Studio 2017 (4)](https://blogs.incyclesoftware.com/topic/visual-studio-2017)
- [DevTest (3)](https://blogs.incyclesoftware.com/topic/devtest)
- [Events (3)](https://blogs.incyclesoftware.com/topic/events)
- [Governance (3)](https://blogs.incyclesoftware.com/topic/governance)
- [VSO (3)](https://blogs.incyclesoftware.com/topic/vso)
- [Data Analytics (2)](https://blogs.incyclesoftware.com/topic/data-analytics)
- [Docker (2)](https://blogs.incyclesoftware.com/topic/docker)
- [Integration (2)](https://blogs.incyclesoftware.com/topic/integration)
- [Microsoft Connect (2)](https://blogs.incyclesoftware.com/topic/microsoft-connect)
- [Mobile Development (2)](https://blogs.incyclesoftware.com/topic/mobile-development)
- [RM (2)](https://blogs.incyclesoftware.com/topic/rm)
- [SQL (2)](https://blogs.incyclesoftware.com/topic/sql)
- [SaaS (2)](https://blogs.incyclesoftware.com/topic/saas)
- [TFS 15 Preview (2)](https://blogs.incyclesoftware.com/topic/tfs-15-preview)
- [TFS 2017 (2)](https://blogs.incyclesoftware.com/topic/tfs-2017)
- [Uncategorized (2)](https://blogs.incyclesoftware.com/topic/uncategorized)
- [Visual Studio 2015 (2)](https://blogs.incyclesoftware.com/topic/visual-studio-2015)
- [Xamarin (2)](https://blogs.incyclesoftware.com/topic/xamarin)
- [ADX (1)](https://blogs.incyclesoftware.com/topic/adx)
- [AI (1)](https://blogs.incyclesoftware.com/topic/ai)
- [Android (1)](https://blogs.incyclesoftware.com/topic/android)
- [Application Monitoring (1)](https://blogs.incyclesoftware.com/topic/application-monitoring)
- [Apps (1)](https://blogs.incyclesoftware.com/topic/apps)
- [BI (1)](https://blogs.incyclesoftware.com/topic/bi)
- [Brian Harry (1)](https://blogs.incyclesoftware.com/topic/brian-harry)
- [Cloud Azure (1)](https://blogs.incyclesoftware.com/topic/cloud-azure)
- [Cloud Services (1)](https://blogs.incyclesoftware.com/topic/cloud-services)
- [Connect (1)](https://blogs.incyclesoftware.com/topic/connect)
- [Connect 2016 (1)](https://blogs.incyclesoftware.com/topic/connect-2016)
- [Consultants (1)](https://blogs.incyclesoftware.com/topic/consultants)
- [Cosmos DB (1)](https://blogs.incyclesoftware.com/topic/cosmos-db)
- [Data Center (1)](https://blogs.incyclesoftware.com/topic/data-center)
- [Development (1)](https://blogs.incyclesoftware.com/topic/development)
- [EA (1)](https://blogs.incyclesoftware.com/topic/ea)
- [Git (1)](https://blogs.incyclesoftware.com/topic/git)
- [Hybrid (1)](https://blogs.incyclesoftware.com/topic/hybrid)
- [IntelliTes (1)](https://blogs.incyclesoftware.com/topic/intellites)
- [IntelliTest (1)](https://blogs.incyclesoftware.com/topic/intellitest)
- [Lab Management (1)](https://blogs.incyclesoftware.com/topic/lab-management)
- [Live Unit Testing (1)](https://blogs.incyclesoftware.com/topic/live-unit-testing)
- [Load Testing (1)](https://blogs.incyclesoftware.com/topic/load-testing)
- [MSDN (1)](https://blogs.incyclesoftware.com/topic/msdn)
- [MSTest (1)](https://blogs.incyclesoftware.com/topic/mstest)
- [MTM (1)](https://blogs.incyclesoftware.com/topic/mtm)
- [Machine Learning (1)](https://blogs.incyclesoftware.com/topic/machine-learning)
- [Media & Entertainment (1)](https://blogs.incyclesoftware.com/topic/media-entertainment)
- [Microsoft Visual Studio (1)](https://blogs.incyclesoftware.com/topic/microsoft-visual-studio)
- [Microsoft nationally managed partner (1)](https://blogs.incyclesoftware.com/topic/microsoft-nationally-managed-partner)
- [NUnit (1)](https://blogs.incyclesoftware.com/topic/nunit)
- [OpsHub (1)](https://blogs.incyclesoftware.com/topic/opshub)
- [PaaS (1)](https://blogs.incyclesoftware.com/topic/paas)
- [Pipelines (1)](https://blogs.incyclesoftware.com/topic/pipelines)
- [PowerShell (1)](https://blogs.incyclesoftware.com/topic/powershell)
- [Principles and Practices of DevOps (1)](https://blogs.incyclesoftware.com/topic/principles-and-practices-of-devops)
- [Programs (1)](https://blogs.incyclesoftware.com/topic/programs)
- [RC (1)](https://blogs.incyclesoftware.com/topic/rc)
- [Release Candidate (1)](https://blogs.incyclesoftware.com/topic/release-candidate)
- [SQL Databases (1)](https://blogs.incyclesoftware.com/topic/sql-databases)
- [SQL server (1)](https://blogs.incyclesoftware.com/topic/sql-server)
- [SSDT (1)](https://blogs.incyclesoftware.com/topic/ssdt)
- [Software (1)](https://blogs.incyclesoftware.com/topic/software)
- [Subscription & Billing Management (1)](https://blogs.incyclesoftware.com/topic/subscription-billing-management)
- [TFS 15 (1)](https://blogs.incyclesoftware.com/topic/tfs-15)
- [TFS 2015 update (1)](https://blogs.incyclesoftware.com/topic/tfs-2015-update)
- [TFS 2016 (1)](https://blogs.incyclesoftware.com/topic/tfs-2016)
- [TFS ALM (1)](https://blogs.incyclesoftware.com/topic/tfs-alm)
- [TestMethods (1)](https://blogs.incyclesoftware.com/topic/testmethods)
- [UI (1)](https://blogs.incyclesoftware.com/topic/ui)
- [UX (1)](https://blogs.incyclesoftware.com/topic/ux)
- [VS2017 (1)](https://blogs.incyclesoftware.com/topic/vs2017)
- [Validation (1)](https://blogs.incyclesoftware.com/topic/validation)
- [Virtual Machines (1)](https://blogs.incyclesoftware.com/topic/virtual-machines)
- [WPC 2016 (1)](https://blogs.incyclesoftware.com/topic/wpc-2016)
- [Web (1)](https://blogs.incyclesoftware.com/topic/web)
- [Windows (1)](https://blogs.incyclesoftware.com/topic/windows)
- [World Partner Conference (1)](https://blogs.incyclesoftware.com/topic/world-partner-conference)
- [XUnit (1)](https://blogs.incyclesoftware.com/topic/xunit)
- [alm (1)](https://blogs.incyclesoftware.com/topic/alm)
- [automation (1)](https://blogs.incyclesoftware.com/topic/automation)
- [build (1)](https://blogs.incyclesoftware.com/topic/build)
- [code (1)](https://blogs.incyclesoftware.com/topic/code)
- [nationally managed partner (1)](https://blogs.incyclesoftware.com/topic/nationally-managed-partner)
- [sql server 2008 (1)](https://blogs.incyclesoftware.com/topic/sql-server-2008)
- [unit testing (1)](https://blogs.incyclesoftware.com/topic/unit-testing)
- [vm (1)](https://blogs.incyclesoftware.com/topic/vm)
[see all](https://blogs.incyclesoftware.com/2009/07/resolve-references-error-tsd03006-in-vsts-db-gdr/#)
### Blog Archive
- [November 2012 (17)](https://blogs.incyclesoftware.com/archive/2012/11)
- [September 2025 (14)](https://blogs.incyclesoftware.com/archive/2025/09)
- [October 2014 (12)](https://blogs.incyclesoftware.com/archive/2014/10)
- [July 2012 (10)](https://blogs.incyclesoftware.com/archive/2012/07)
- [October 2012 (9)](https://blogs.incyclesoftware.com/archive/2012/10)
- [**](https://twitter.com/incyclesoftware?lang=en)
- [**](https://ca.linkedin.com/company/incycle-software)
- [**](https://www.facebook.com/InCycleSoftware/)
### About us
At InCycle, we believe there is always a better way and today, that includes the cloud.
[](https://www.incyclesoftware.com/)
### Learn more
- [Why Incycle?](https://www.incyclesoftware.com/why-incycle)
- [Success Stories](https://www.incyclesoftware.com/customer-success-stories)
- [Events](https://www.incyclesoftware.com/events)
- [Careers](https://www.incyclesoftware.com/careers)
- [About](https://www.incyclesoftware.com/about-incycle-software)
### 1-800-565-0510 [info@incyclesoftware.com](mailto:info@incyclesoftware.com)
###   
© 2025 InCycle Software
[Privacy policy](https://www.incyclesoftware.com/privacy)
**
 
```json
{
"@context" : "https://schema.org",
"@type" : "BlogPosting",
"author" : {
"@type" : "Person",
"name" : "Ryan Riehle",
"url" : "https://blogs.incyclesoftware.com/author/ryan-riehle"
},
"datePublished" : "2009-07-07T11:21:00.000Z",
"headline" : "Resolve references: Error TSD03006 IN VSTS DB GDR",
"mainEntityOfPage" : {
"@id" : "https://blogs.incyclesoftware.com/2009/07/resolve-references-error-tsd03006-in-vsts-db-gdr/",
"@type" : "WebPage"
},
"publisher" : {
"@type" : "Organization",
"logo" : {
"@type" : "ImageObject",
"url" : "https://blogs.incyclesoftware.com/hubfs/logo-InCycle-New-Blue---transparent.png"
},
"name" : "InCycle Software Inc."
}
}
```