Forum Replies Created

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

  • RE: Pros and Cons

    In the instance with dealing with a law environment, multiple instances on the same server would probably be a bad idea.  Using the firm I work for as an example, our...

  • RE: Need to create SQL Login using SQL-DMO

    Nevermind.  I answered my own question yet again.

    I completely forgot about the SQLServer.Databases object.

    For anyone who's interested...

    oServer.Databases("myProgsDB").ExecuteImmediate "EXEC sp_addlogin 'NewLogin', 'password', myProgsDB"

    oServer.ExecuteImmediate "GO"

    That does it perfectly.

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