One other thing. When I install SQL Server, I set the default data and log file locations to a different folder that isn't in the Program Files or Windows folders hierarchy. The issue with elevation is not needed.
>It works. Thanks
>
>If this is only for that option, that for simply querying, SSMS with regular rights should be ok.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
