ASP.NET 架构表导致 VSTS 中出现问题
安装 VSTS 数据库 GDR 并导入包含 ASP.NET 提供程序架构表的 SQL Server 2005 数据库后，我收到以下警告：
TSD04151：过程：[dbo].[aspnet_Users_DeleteUser] 具有对对象 [dbo] 的未解析引用。 [系统对象].[名称]。
TSD04151：过程：[dbo].[aspnet_Users_DeleteUser] 具有对对象 [dbo].[sysobjects] 的未解析引用。
TSD04151：过程：[dbo].[aspnet_AnyDataInTables] 具有对对象 [dbo].[sysobjects].[type] 的未解析引用。
TSD04151：过程：[dbo].[aspnet_Users_DeleteUser] 具有对对象 [dbo].[sysobjects].[type] 的未解析引用。
TSD04151：过程：[dbo].[aspnet_AnyDataInTables] 具有对对象 [dbo].[sysobjects] 的未解析引用。
TSD04151：过程：[dbo].[aspnet_AnyDataInTables] 具有对对象 [dbo].[sysobjects].[name] 的未解析引用。
有谁知道如何摆脱这些警告？
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: Procedure: [dbo].[aspnet_Users_DeleteUser] has an unresolved reference to object [dbo].[sysobjects].[name].
TSD04151: Procedure: [dbo].[aspnet_Users_DeleteUser] has an unresolved reference to object [dbo].[sysobjects].
TSD04151: Procedure: [dbo].[aspnet_AnyDataInTables] has an unresolved reference to object [dbo].[sysobjects].[type].
TSD04151: Procedure: [dbo].[aspnet_Users_DeleteUser] has an unresolved reference to object [dbo].[sysobjects].[type].
TSD04151: Procedure: [dbo].[aspnet_AnyDataInTables] has an unresolved reference to object [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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我不确定，但快速浏览一下似乎可以揭示以下内容。
脚本中的违规行似乎是：
过程 [dbo].[aspnet_Users_DeleteUser] 中的第 42 行
（这里如何做下划线？）（像这样： \_ ）(EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_MembershipUsers') AND (type = 'V'))))
系统视图 sysobjects 属于内置系统架构 'sys'不包含在数据库项目中。 因此，数据库项目解析器（错误地）认为引用未解析。
我认为除了选择忽略项目设置中的警告之外，您别无选择。 （请注意，这也会向您隐藏真正的错误。）我可能会忽略这些警告。
更新：
尝试添加对：
C:\Program Files\Microsoft Visual Studio 9.0\VSTSDB\Extensions\SqlServer\2008\DBSchemas\master.dbschema 的引用
I'm not sure, but a quick look seems to reveal the following.
The offending line in the script seems to be:
Line 42 in procedure [dbo].[aspnet_Users_DeleteUser]
(how do you do underscores here?)(like this: \_ )(EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_MembershipUsers') AND (type = 'V'))))
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\Microsoft Visual Studio 9.0\VSTSDB\Extensions\SqlServer\2008\DBSchemas\master.dbschema
Kim 的上述回答非常适合我要求的情况。 但是，我还发现您可以过滤每个文件的构建警告。 查看 http://blogs.msdn.com/gertd/archive/2009/01/11/file-level-build-warning-suppression-in-the-gdr.aspx
Kim's answer above works perfectly for the situation I asked for. But, I also found out that you can filter the build warnings per file. Look at http://blogs.msdn.com/gertd/archive/2009/01/11/file-level-build-warning-suppression-in-the-gdr.aspx