find view details from linked server

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

PravB4u Default port Points: 1401 More actions · Answer 1

try this

EXEC [SERVERNAME].[DBNAME].dbo.sp_Help 'ViewName'

Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com

abhas SSCarpal Tunnel Points: 4681 More actions · Answer 2

Thanks Praveen for reply. I tried but I am getting below error.

Server 'servername' is not configured for RPC

Thanks

Abhas.

PravB4u Default port Points: 1401 More actions · Answer 3

hi,

refer this link.

Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com