October 22, 2007 at 4:08 pm
How can I quickly check to see if SQL rpc is turned on?
If it is off how do you turn it on both from a T-SQL query as well as from the SSMS?
What are the pro's and con's of rpc turned on?
Obviously I'd like to be able to run specific T-SQL commands to alter DB objects but security is an issue.
Thanks
October 23, 2007 at 6:47 am
It is a security issue. You have to make that determination for yourself. It's off by default. Run sp_configure. It's the setting 'Remote Proc Trans' and setting it to 1 turns it on.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2007 at 8:54 am
Ignore my last post. It's utterly wrong.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2007 at 9:28 am
Thanks for the reply. I've decided not to turn it on.
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply