Forum Replies Created

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

  • RE: Using SMO with Powershell

    Setting PrimaryObjects to false works for scripting permissions-only for tables, views and UDFs.

    However for sprocs it doesn't - the whole sproc is scripted with the permissions at the end.

    Your idea...

  • RE: Backing Up a Database with SMO

    Useful article. A few typos in the code though maybe?

    Module CreateInitialConnection Public ProdServer As New Server()

    Public ProdConn As ServerConnection

    [...]

    should read (note line break)

    Module CreateInitialConnection

    Public ProdServer As New...

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