Post reply

Syntax Error

  • December 10, 2002 at 5:20 pm

    #81266

    The following query executes fine

    EXEC('SELECT a.* FROM OPENROWSET(''SQLOLEDB'', ''' + 'Trusted_connection=yes;' + 'Server=' + @Server_name + ''', ''SELECT * FROM msdb.dbo.sysdbmaintplan_history'') AS a')

    But if i try to use a where clause e.g. where activity = 'Backup Database', i'm receiving syntax errors. I'm messing up the quotes somehow. Can someone help me ?

  • December 10, 2002 at 7:13 pm

    #444024

    Try this

    Select ('SELECT a.* FROM OPENROWSET(''SQLOLEDB'', ''Trusted_connection=yes;Server='

    + @@Servername

    +''', ''SELECT * FROM msdb.dbo.sysdbmaintplan_history where activity = ''''Backup Database'''' '') AS a')

    Exec('SELECT a.* FROM OPENROWSET(''SQLOLEDB'', ''Trusted_connection=yes;Server='

    + @@Servername

    +''', ''SELECT * FROM msdb.dbo.sysdbmaintplan_history where activity = ''''Backup Database'''' '') AS a')

  • December 11, 2002 at 4:17 pm

    #444171

    Thanks numbers.

    That works fine.

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy