ASP.NET架构表在VSTS导致问题 [英] ASP.NET Schema Tables Causing Issues in VSTS
问题描述
安装VSTS数据库GDR和导入SQL Server 2005数据库,其中包括ASP.NET提供架构表后,我得到以下警告:
After installing the VSTS Database GDR and importing a SQL Server 2005 database that includes the ASP.NET provider schema tables, I get the following warnings:
TSD04151:过程:。。[DBO] [aspnet_Users_DeleteUser]有一个未解决的参考对象[DBO] [sysobjects中] [名]
TSD04151: Procedure: [dbo].[aspnet_Users_DeleteUser] has an unresolved reference to object [dbo].[sysobjects].[name].
TSD04151:过程:。[DBO] [aspnet_Users_DeleteUser]有一个未解决的参考对象[DBO] [系统对象]
TSD04151: Procedure: [dbo].[aspnet_Users_DeleteUser] has an unresolved reference to object [dbo].[sysobjects].
TSD04151:过程:。。[DBO] [aspnet_AnyDataInTables]有一个未解决的参考对象[DBO] [sysobjects中] [类型]
TSD04151: Procedure: [dbo].[aspnet_AnyDataInTables] has an unresolved reference to object [dbo].[sysobjects].[type].
TSD04151:过程:。。[DBO] [aspnet_Users_DeleteUser]有一个未解决的参考对象[DBO] [sysobjects中] [类型]
TSD04151: Procedure: [dbo].[aspnet_Users_DeleteUser] has an unresolved reference to object [dbo].[sysobjects].[type].
TSD04151:过程:。[DBO] [aspnet_AnyDataInTables]有一个未解决的参考对象[DBO] [系统对象]
TSD04151: Procedure: [dbo].[aspnet_AnyDataInTables] has an unresolved reference to object [dbo].[sysobjects].
TSD04151:过程:。。[DBO] [aspnet_AnyDataInTables]有一个未解决的参考对象[DBO] [sysobjects中] [名]
TSD04151: Procedure: [dbo].[aspnet_AnyDataInTables] has an unresolved reference to object [dbo].[sysobjects].[name].
有谁知道如何摆脱这些警告?
Does anyone know how to get rid of these warnings?
推荐答案
我不知道,但咋一看似乎透露出以下。
在脚本中出错行似乎是:
I'm not sure, but a quick look seems to reveal the following. The offending line in the script seems to be:
42号线在程序[DBO] [aspnet_Users_DeleteUser] <击>(你怎么办强调了在这里?)罢工>的(就像这样:\\ _)的
Line 42 in procedure [dbo].[aspnet_Users_DeleteUser] (how do you do underscores here?) (like this: \_ )
(EXISTS(SELECT名FROM 系统对象 WHERE(名称= N'vw_aspnet_MembershipUsers')和(类型='V'))))
(EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_MembershipUsers') AND (type = 'V'))))
系统视图系统对象属于哪个不包括在数据库项目中的内置的系统架构SYS。其结果是数据库项目解析器认为(错误地)引用是没有得到解决。
the system view sysobjects belongs to the built in system schema 'sys' which is not included in the database project. As a result the database project parser thinks (wrongly) that the reference is unresolved.
我不认为有什么可以做,但选择忽略该项目设置了警告。 (请注意,这将隐藏你真正的错误,以及。)我想可能只是忽略警告。
I don't think there is anything you can do but select to ignore the warning from the project settings. (Be aware that that will hide real errors from you as well.) I would probably just ignore the warnings.
更新:
尝试添加引用:
Update: Try to add a reference to:
C:\\ Program Files文件\\微软的Visual Studio 9.0 \\ VSTSDB \\扩展\\ SqlServer的\\ 2008 \\ DBSchemas \\ master.dbschema
C:\Program Files\Microsoft Visual Studio 9.0\VSTSDB\Extensions\SqlServer\2008\DBSchemas\master.dbschema
这篇关于ASP.NET架构表在VSTS导致问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!