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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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