Article ID: 970584 - View products that this article applies to.
When you import a schema model and then deploy a database project in Microsoft Visual Studio Team System Database Edition 2008 GDR, you receive error messages that resemble the following in the Output window:
However, the error messages do not specify which object causes the failure. Therefore, it takes you a long time to troubleshoot.
Error TSD03041: Unknown permission type: EXEC
Error TSD02010: Incorrect syntax near SET.
Project_name.dbschema(0,0)Error TSD01234: Failed to import target model Test. Detailed message A fatal error occurred while the model was being imported.
To resolve this problem, upgrade to Microsoft Visual Studio Team System 2008 Database Edition GDR R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/970479/ )List of fixed issues in the Microsoft Visual Studio Team System 2008 Database Edition GDR R2
Note Microsoft Visual Studio Team System 2008 Database Edition GDR R2 replaces Microsoft Visual Studio Team System 2008 Database Edition GDR.
After you upgrade to Microsoft Visual Studio Team System 2008 Database Edition GDR R2, you will also receive the following messages:
How to enable the tracingTo do this, follow these steps:
Note When you complete the trace diagnosis, you must set the values of the TraceToLogFile registry entry and the TraceSwitch registry entry to 0 to disable the tracing function. Otherwise, you will have performance issues.
The following table lists the registry entries that are included in the tracing.reg registry file.
For more information about how to diagnose problems in the Visual Studio 2008 Team System Database Edition GDR and GDR R2, visit the following Microsoft Web sites:
Collapse this tableExpand this table