sqlserverdba
asked on
linked server create index
What would be the syntax to create, drop an index across a linked server connection on the other server?
I tried using the four part name, but the maximum number of prefixes allowed was 2. I tried to use parentheses [] for the first 3 parts of the name. parsed successfully but, executing gives error
Msg 1088, Level 16, State 12, Line 1
Cannot find the object because it does not exist or you do not have permissions.
The linked server connection login is the database owner for the db and the object exists
I tried using the four part name, but the maximum number of prefixes allowed was 2. I tried to use parentheses [] for the first 3 parts of the name. parsed successfully but, executing gives error
Msg 1088, Level 16, State 12, Line 1
Cannot find the object because it does not exist or you do not have permissions.
The linked server connection login is the database owner for the db and the object exists
I would suggest to create SP on the linked server and do index creation from there. Maybe via dynamic SQL
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.