Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: IF EXISTS with LINKED SERVER failures.

    Try Dynamic SQL

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

    DECLARE @tSQLNvarchar(2000)

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

    exec dbo.sp_executesql...

  • RE: Client found response content type Error on RS

    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

     

Viewing 2 posts - 1 through 2 (of 2 total)