Hello, In MS SQL 2005 I need to give a user access to sp_addlinkedserver and sp_addlinkedsrvlogin so he can connect to another server within a stored procedure, but I need to do this without putting him in the sysadmin or setupadmin group. I looked at GRANT first, but MSDN specifically says this can't be used unless the user is in the sysadmin group.
Any ideas on how to set this up without opening up the entire server? Thanks -- Alex --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx <p><a href="http://feeds.feedburner.com/DotNetDevelopment";><img src="http://feeds.feedburner.com/~fc/DotNetDevelopment?bg=99CCFF&fg=444444&anim=1"; height="26" width="88" style="border:0" alt="" /></a></p> -~----------~----~----~----~------~----~------~--~---
