Has anyone successfully used Microsoft Query (MSQRY32.EXE) with SQL Server 2005?
I have created an ODBC connection using both a Native SQL Server 2005 Client ODBC and a SQL Server 2000 ODBC. Neither work.
MS Query sends the following to the server:
dbcc traceon(208) set ansi_nulls off set ansi_padding off set ansi_warnings off set concat_null_yields_null off set quoted_identifier off
The dbcc traceon(208) causes MS Query to err with:
User 'public' does not have permission to run DBCC TRACEON.
dbcc traceon(208) means SET QUOTED IDENTIFIERS ON. Without granting users dbo permissions, how can I modify the permissions of dbcc traceon?