Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stored procedure run location Expand / Collapse
Author
Message
Posted Wednesday, July 18, 2012 12:33 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 4, 2016 2:37 PM
Points: 53, Visits: 64
All,

I have a remote MySQL database which has IP based security restrictions. If I create a stored procedure on a SQL Server 2000 instance and run it from a client will it run on the server or on the client?

I don't want to open up the IP restrictions to all our machines but I could open it up to allow the SQL server to have access.

Sorry for the basic question.

Thanks

Andrew
Post #1331742
Posted Wednesday, July 18, 2012 12:43 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:53 PM
Points: 14,325, Visits: 37,415
all code, whether a TSQL statment or a procedure, is executed on the SQL server, and the results(if any) are returned to the client.

so if you have a linked server to your mySQL database, the calling machine is the SQL server.

does that help?


Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1331755
Posted Wednesday, July 18, 2012 1:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 4, 2016 2:37 PM
Points: 53, Visits: 64
That really helps, thank you.

Post #1331770
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse