We have a reporting tool that needs to access sysobjects.
This tool is used by most of our users but now it does not work on SQL
Server 2005 as the security is different. Not even sa can see
sysobjects. What should I do to allow sa (or any other user) to access
sysobjects?
I searched the net, books online and I'm giving up.
I'm the only programmer within the company and I'm running out of time.
We don't have a dba person, all our SQL Servers 2005 were set up by a
contractor who left, and he was not dba either, his role was to put
software on our 12 servers.
Re: Select with serial number column ... Select Name From SysObjects Where type = 'U' Order By Name asc ... On SQL 2005: ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...Books Online for SQL Server 2005 at ... (comp.databases.ms-sqlserver)
Re: repetitive query to sysobjects in an ADP ... in our application database that does not resolve Active Directory since we ... I cannot comment on SQL 2005. ...sysobjects sofk, sysobjects sotblfk, sysobjects ... Apparently access is querying the system table for every single relationship ... (microsoft.public.access.adp.sqlserver)
Re: SQL Server 6.5 Data Conversion ... If you want to do it with wizards etc, you need to first get hold of SQL... FROM sysobjects... I encourage to you look closer in Books Online... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... (microsoft.public.sqlserver.tools)
Re: SQL Server Verbindung ... > Es handelt sich allerdings um ein Access-Projekt (.adp)... Im Prinzip schon.In der SysObjects werden alle Objekte des SQL Servers...Tabellen werden hier zusätzlich die Verbindungseigenschaften hinterlegt. ... (microsoft.public.de.access.clientserver)
Re: system tables in MS SQL server 5 ... I treid to see some system tables which are sysobjects, syscolumns, ... There are no such tables in SQL 2005. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...Books Online for SQL Server 2005 at ... (comp.databases.ms-sqlserver)
