Executing T-SQL from VB

• pfd3

  SSC Veteran

  Points: 267

  More actions

  March 26, 2002 at 3:39 pm

  #78423

  I need to restore a database from a SQL Script. I cannot pass the script into a Recordset using ADODB, I get the the 'GO' error. Is there some other way that I can script the views and sps from the database and then restore them using the scripting method?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738347

  More actions

  March 26, 2002 at 5:05 pm

  #426139

  use SQL DMO

  Steve Jones

  steve@dkranch.net

• pfd3

  SSC Veteran

  Points: 267

  More actions

  March 26, 2002 at 5:07 pm

  #426141

  Thanks, I found the oDatabase.ExecuteImmediate method where I need to just pass in the Text file as a string. It works great thanks!