Help please on OpenRowSet

• jme9314

  Valued Member

  Points: 51

  More actions

  October 11, 2011 at 6:56 pm

  #249859

  Hi All,

  I have this query below:

  Set @TableNameSQL ='Select Count(*) from' + @TableNameVar

  INSERT INTO @tempTable (DevServer)

  SELECT a.*

  FROM OPENROWSET('SQLOLEDB',

  'Server';'uname';'password',

  ' + @TableNameSQL + ' ) AS a

  I need to pass the Query on the openrowset is this possible or how do I do it.

  Please help.

  Thanks in advance.

• October 12, 2011 at 1:52 am

  This was removed by the editor as SPAM

• Performance Guard (Shehap)

  Ten Centuries

  Points: 1297

  More actions

  October 12, 2011 at 8:58 am

  #1393517

  you have to enable Ad Hoc Distributed Queries by running the below query

  sp_configure 'show advanced options', 1;

  GO

  RECONFIGURE;

  GO

  sp_configure 'Ad Hoc Distributed Queries', 1;

  GO

  RECONFIGURE

  GO

  [font="Arial Black"]Performance Guard[/font]

  [font="Courier New"]Just ask me to get 0 sec for all queries[/font]