“/”应用程序中的服务器错误。

信息：拒绝了对对象 'sysobjects' (数据库 'mssqlsystemresource'，架构 'sys')的 SELECT 权限。堆栈： at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at nms_data.cls_db.query_records(String connstring, String sqlstring, DataTable& dt) 发生错误对象：Microsoft OLE DB Provider for SQL Server 发生错误方法：Void ExecuteCommandTextErrorHandling(Int32) 数据库语句： declare @tablename as varchar(100) declare @sql as varchar(1000) set @tablename =(SELECT TOP 1 name FROM dbo.sysobjects WHERE (xtype = 'U') AND (name LIKE 'Blog_UserArticleInfo%') ORDER BY crdate DESC) set @sql='select count( distinct userid) as counts,'''+@tablename+''' as tablename from '+@tablename exec(@sql) 数据库链接：Provider=SQLOLEDB.1;Persist Security Info=False;user id=chetxbbs;Initial Catalog=blog;Data Source=192.168.7.180;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column collation when possible=False

说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Exception: 信息：拒绝了对对象 'sysobjects' (数据库 'mssqlsystemresource'，架构 'sys')的 SELECT 权限。堆栈： at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at nms_data.cls_db.query_records(String connstring, String sqlstring, DataTable& dt) 发生错误对象：Microsoft OLE DB Provider for SQL Server 发生错误方法：Void ExecuteCommandTextErrorHandling(Int32) 数据库语句： declare @tablename as varchar(100) declare @sql as varchar(1000) set @tablename =(SELECT TOP 1 name FROM dbo.sysobjects WHERE (xtype = 'U') AND (name LIKE 'Blog_UserArticleInfo%') ORDER BY crdate DESC) set @sql='select count( distinct userid) as counts,'''+@tablename+''' as tablename from '+@tablename exec(@sql) 数据库链接：Provider=SQLOLEDB.1;Persist Security Info=False;user id=chetxbbs;Initial Catalog=blog;Data Source=192.168.7.180;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column collation when possible=False

源错误:



执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。

堆栈跟踪:


[Exception: 信息：拒绝了对对象 'sysobjects' (数据库 'mssqlsystemresource'，架构 'sys')的 SELECT 权限。
堆栈：   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at nms_data.cls_db.query_records(String connstring, String sqlstring, DataTable& dt)
发生错误对象：Microsoft OLE DB Provider for SQL Server
发生错误方法：Void ExecuteCommandTextErrorHandling(Int32)
数据库语句： declare @tablename as varchar(100)  declare @sql as varchar(1000)  set @tablename =(SELECT TOP 1 name FROM dbo.sysobjects WHERE (xtype = 'U') AND (name LIKE 'Blog_UserArticleInfo%') ORDER BY crdate DESC)  set @sql='select count( distinct userid) as counts,'''+@tablename+''' as tablename from '+@tablename  exec(@sql) 
数据库链接：Provider=SQLOLEDB.1;Persist Security Info=False;user id=chetxbbs;Initial Catalog=blog;Data Source=192.168.7.180;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column collation when possible=False
]
   nms_data.cls_db.query_records(String connstring, String sqlstring, DataTable& dt)
   nms_data.cls_db_blog.InsertBlogUserInfo(String username, Int32 userid, String UserInfoTable)
   nms_function.Cls_Blog.Get_DT_UserInfo(String username)
   nms_function.Cls_Blog.GetUserInfo(Cache m_cache, String username)
   BLOG.NewBlog.blog.Page_Load(Object sender, EventArgs e)
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750

版本信息: Microsoft .NET Framework 版本:1.1.4322.2407; ASP.NET 版本:1.1.4322.2407