Post reply

powershell

  • April 28, 2015 at 7:11 am

    #317803

    Hi,

    I'm trying to create a table using powershell..following is my syntax

    $conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=.\sqlexpress; Initial Catalog=testdata1; Integrated Security=SSPI")

    $conn.Open()

    $db= $srv.Databases.Item("TestData1")

    $tb = new-object Microsoft.SqlServer.Management.Smo.Table($db, "companytable")

    $col1 = new-object Microsoft.SqlServer.Management.Smo.Column($tb,"CompanyName", [Microsoft.SqlServer.Management.Smo.DataType]::NChar(50))

    $tb.Columns.Add($col1)

    $tb.Create()****

    $cmd.ExecuteNonQuery()

    $conn.Close()

    My error is on the $tb.Create()

    can someone tell me what am I missing here

    Thanks

  • April 29, 2015 at 2:15 am

    #1794214

    thnx for your help..

    I solved it

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

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