March 19, 2005 at 4:28 pm
I'm trying to call a stored procedure from an ASP.net web app, but the data is in a linked server in SQL Server 2000, not in one of the databases. I can see how to set up and call stored procedures in regular databases, but I don't see how to do it against data in a linked server. Where do you create the stored procedure? I'm not seeing an option in the linked server menus. Thanks in advance!
March 21, 2005 at 12:56 pm
Create the stored procedure on the server where the linked server is created. Access all the data from the linked server in the stored procedure. Call the stored procedure from asp.net.
If I have understood your question correctly this should do the trick.
Yash
March 21, 2005 at 5:22 pm
Where do I create it on the server though? I can see how to create them within each database that resides on a particular server, but wouldn't these only be able to access data within that database? In the menu tree, I don't see an option for creating a stored procedure on the linked server.
March 21, 2005 at 5:39 pm
A stored procedure can query data in databases other than the database it exists in, via 3 part naming (DBName.DBOwner.TableName) or on linked servers via 4 part naming.
CREATE PROCEDURE TestProc
As
BEGIN
SELECT * FROM SomeOtherDB.dbo.YourTable
END
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy