[.NET] VB.Net Restore SQL Database ไม่ได้อ่ะค่ะ มันติดตรง objCmd.ExecuteNonQuery()

    Public Shared Function RunSQLScript() As Boolean
        Dim suc As Boolean = False
        Dim s As New StringBuilder()
        Dim scConnection As New ServerConnection(New SqlConnection() With {
                                                                           .ConnectionString = "Data Source=ServerName;Initial Catalog=xDB;User ID=sa;Password=1234"
                                                                          })
        Dim sqlServer As New Microsoft.SqlServer.Management.Smo.Server(scConnection)
        sqlServer.ConnectionContext.SqlExecutionModes = SqlExecutionModes.ExecuteSql

        '******************************
        'ควรจะอ่านค่ามาจากไฟล์ yourFiles123456.sql หรือ Text Files xxx.text
        '******************************
        s.Append("USE yourDB")
        s.Append("GO")
        s.Append("BEGIN TRANSACTION")
        s.Append("SET QUOTED_IDENTIFIER ON")
        s.Append("SET ARITHABORT ON")
        s.Append("SET NUMERIC_ROUNDABORT OFF")
        s.Append("SET CONCAT_NULL_YIELDS_NULL ON")
        s.Append("SET ANSI_NULLS ON")
        s.Append("SET ANSI_PADDING ON")
        s.Append("SET ANSI_WARNINGS ON")
        s.Append("COMMIT")
        s.Append("BEGIN TRANSACTION")
        s.Append("GO")
        s.Append("ALTER TABLE dbo.yourTable ADD yourNewColumn varchar(100) NULL")
        s.Append("GO")
        s.Append("ALTER TABLE dbo.xTable SET (LOCK_ESCALATION = TABLE)")
        s.Append("GO")
        s.Append("COMMIT")

        Try
            sqlServer.ConnectionContext.ExecuteNonQuery(s.ToString())
        Catch ex As Exception
            'TO DO
        End Try

        Return suc
    End Function

        Try
            sqlServer.ConnectionContext.ExecuteNonQuery(s.ToString())
            suc = True  
        Catch ex As Exception
            'TO DO
        End Try

        s.Append("ALTER TABLE dbo.yourTable ADD yourNewColumn varchar(100) NULL")
        s.Append("GO")
        s.Append("ALTER TABLE dbo.yourTable  SET (LOCK_ESCALATION = TABLE)")

#NO 7 ท่านเจ้าของกระทู้ลองศึกษาคำสั่งแต่ละคำสั่งดูครับ (มันต้องเข้าใจอย่างลึกซึ้ง)
           งานแบบนี้ โชคดีไม่ได้อยู่ข้างเรา

1. Select * From sys.Tables
2. Select * From sysobjects Where xtype='U'
3. Select * From INFORMATION_SCHEMA.TABLES
...

USE yourDB
GO 5
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'yourTableName' And TABLE_SCHEMA = 'dbo'