Hi. I have a problem with my two database Sql server. My databases are on the same server but if i try to execute a stored procedure from the first database to the second it doesn't work. I have tryed also to create a linked server but i don't have permission to do it. Same for create a new user with the same username that i already use for the second database. Any Suggestion for me? Thanks
You might want to take a look at this forum post: http://forum.Winhost.com/showthread.php?t=7974 You should also be able to create a Linked Server from your local SQL Server instance, not on our servers. (I hope I phrased that correctly.) You should also take a look at the EXECUTE AS Clause: http://msdn.microsoft.com/en-us/library/ms188354.aspx