Try Dynamic SQL

I had the same problem and resolved as code given below.

DECLARE @tSQL Nvarchar(2000)

SET @tSQL = 'SELECT * FROM RemoteSQL.MyDB.INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '''+'dbo'+''' AND TABLE_NAME = '''+'MyTablel'+''''

exec dbo.sp_executesql...

Hello,

I am not able to connect to reporting services using Management Studio. I have installed SQL Server 2005 for Developer on my Vista Desktop.

Thanks

Vinod