Cannot process the object "SET FMTONLY OFF;SET NOCOUNT ON;z_xxxxxx"
Publicado por Mende (2 intervenciones) el 22/01/2017 00:50:11
Al ejecutar un procedure desde otra base me sale error
El error
Cannot process the object "SET FMTONLY OFF;SET NOCOUNT ON;z_xxxxxx". The OLE DB provider "SQLNCLI10" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.
1
2
3
4
select * from FROM OPENROWSET('SQLNCLI10'
,'Server=1.1.1.1;Uid=XXXX;Pwd=XXXXX;Database=XXX'
,'SET FMTONLY OFF;SET NOCOUNT ON;EXEC z_xxxxxx')
GO
El error
Cannot process the object "SET FMTONLY OFF;SET NOCOUNT ON;z_xxxxxx". The OLE DB provider "SQLNCLI10" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.
Valora esta pregunta
0
