http://sql-server-performance.com/Community/forums/5.aspxPlease post SQL Server 2005 general DBA questions here.en-USCommunityServer 2007 SP2 (Build: 20611.960)http://sql-server-performance.com/Community/forums/thread/7866.aspxTue, 05 Jun 2007 21:01:11 GMT5b41e7a1-0e3d-48f8-8160-247271f4496a:7866MohammedU0http://sql-server-performance.com/Community/forums/thread/7866.aspxhttp://sql-server-performance.com/Community/forums/commentrss.aspx?SectionID=5&PostID=7866Thanks for sharing the solution...<br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />http://sql-server-performance.com/Community/forums/thread/7865.aspxTue, 05 Jun 2007 14:50:36 GMT5b41e7a1-0e3d-48f8-8160-247271f4496a:7865jn4u0http://sql-server-performance.com/Community/forums/thread/7865.aspxhttp://sql-server-performance.com/Community/forums/commentrss.aspx?SectionID=5&PostID=7865The applications in the organisation were recorded macros, out of the it departments control <img src='/community/emoticons/emotion-5.gif' alt=';)' /> . To solve the problem with made search and replace APP=#%92Microsoft® Query#%92 to APP=#%92#%92. Updated excel.http://sql-server-performance.com/Community/forums/thread/7864.aspxMon, 04 Jun 2007 23:43:02 GMT5b41e7a1-0e3d-48f8-8160-247271f4496a:7864MohammedU0http://sql-server-performance.com/Community/forums/thread/7864.aspxhttp://sql-server-performance.com/Community/forums/commentrss.aspx?SectionID=5&PostID=7864Check it is sql 2005 change issue...<br /><br />Check the following may help you...<br />How do you connect sql 2005 using excel? via ODBC?<br /><br /<a target="_blank" href=http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=322312&SiteID=1>http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=322312&SiteID=1</a><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />http://sql-server-performance.com/Community/forums/thread/2192.aspxMon, 04 Jun 2007 09:22:49 GMT5b41e7a1-0e3d-48f8-8160-247271f4496a:2192jn4u0http://sql-server-performance.com/Community/forums/thread/2192.aspxhttp://sql-server-performance.com/Community/forums/commentrss.aspx?SectionID=5&PostID=2192We updated a server to 2005 this weekend got the problem with DBCC TRACEON(20<img src='/community/emoticons/emotion-11.gif' alt='8)' /> and excel 200? Do need to give sysadmin rights to user to run excel or are the any kb, or any other way to solve the problem for the users.<br /><br />"User 'public' does not have permission to run DBCC TRACEON"