Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Friday, November 1, 2013 3:28 PM
Points: 53, Visits: 63
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 @ 8:08 AM
Points: 12,903, Visits: 32,146
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
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: Friday, November 1, 2013 3:28 PM
Points: 53, Visits: 63
That really helps, thank you.

Post #1331770
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse