Post reply

Executing T-SQL from VB

  • 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?

  • March 26, 2002 at 5:05 pm

    #426139

    use SQL DMO

    Steve Jones

    steve@dkranch.net

  • 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!

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

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