October 16, 2007 at 12:03 pm
Is it possible to drop/create an index on a table that's in a database you are connected to that is a linked server?
If so, can someone give an example?
Assume the linked server is already linked with the name SQLnk, the DB name is STUFF, table name is OWNER and the index name should be OWNER_idx.
Thanks
October 16, 2007 at 1:07 pm
Look up the EXECUTE statement in BOL:
EXECUTE ('USE STUFF;DROP INDEX OWNER_idx ON dbo.OWNER')
AT SQLnk
The linked server has to support RPC calls:
EXEC master.dbo.sp_serveroption @server=N'SQLnk', @optname=N'rpc', @optvalue=N'true'
Oh, and, Warren Peace: SKY HIGH RULES!
----------------------------------------------------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 16, 2007 at 3:18 pm
How can I query to see if rpc is on or off?
October 17, 2007 at 5:28 am
System catalog view:
SELECT * FROM sys.servers
It's one of the properties, is_rpc_out_enabled.
----------------------------------------------------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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply