Stored procedure run location

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Security » Stored procedure run location

Stored procedure run location

Rate Topic

Display Mode

Topic Options

Author

Message

Andrew Smith-2007

Posted Wednesday, July 18, 2012 12:33 PM

Valued Member

Group: General Forum Members
Last Login: Friday, July 20, 2012 2:22 PM
Points: 53, Visits: 53

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

Lowell

Posted Wednesday, July 18, 2012 12:43 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 5:23 AM
Points: 11,638, Visits: 27,715

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

Andrew Smith-2007

Posted Wednesday, July 18, 2012 1:00 PM

Valued Member

Group: General Forum Members
Last Login: Friday, July 20, 2012 2:22 PM
Points: 53, Visits: 53

That really helps, thank you.

Post #1331770

« Prev Topic | Next Topic »

Permissions