Using "USE DB GO" within an OPENQUERY

• GA.Kramer

  SSC Eights!

  Points: 954

  More actions

  January 7, 2010 at 3:17 am

  #141410

  Hi guys,

  retrieving data from some servers I try to use the next syntax

  SELECT * FROM OPENQUERY( [linked server],'SET FMTONLY OFF; EXEC (''DBCC showfilestats WITH NO_INFOMSGS '')')

  but this retrieves the filestats from master only.

  How can I use this syntax going to a specific database.

  --------------

  Or ;

  Why does the syntaxs;

  USE database

  GO

  EXEC ('DBCC showfilestats WITH NO_INFOMSGS ')

  works fine and

  USE database GO EXEC ('DBCC showfilestats WITH NO_INFOMSGS ')

  does not work??

  Who can help me out on this?

  Regards.

  Guus Kramer

  The Netherlands

• Mike01

  SSChampion

  Points: 11381

  More actions

  January 7, 2010 at 6:44 am

  #1100153

  you need to put the Use statement in the Exec call.

  SELECT * FROM OPENQUERY( [linked server],'SET FMTONLY OFF; EXEC (''USE DATABASE; DBCC showfilestats WITH NO_INFOMSGS '')')

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/