Re: SQL 2005 - SQLDMO - Adding Logins/ Users

I don't know about the tempdb thing, but anytime I want to know how to
do something with script I'll just load up profiler and do it through
the GUI, then pick through the script and clean it up a bit.

Erland Sommarskog wrote:
Will (wmlpez@xxxxxxx) writes:
I do not understand the sequence in which to add logins/users. A couple
of things to note. I can not use vbscript - it has to be done using the
sqldmo objects (or in a sql script).

The sequence I use now is:

1- create login, set default db
2- add login to sql server
3- set db owner
4- create user
5- add user to master db
6- add user to tempdb - blows up here
Error 'Microsoft SQL-DMO: [SQL-DMO]This object is already in a
collection.'

I need the user in 3 dbs. Any help greatly appreciated. Thinking about
it...I bet by adding it to the master db that it is automatically added
to tempdb so I will try to add it to the 2rd db and see if that works.

Permit me to be curious why you need to add the user to master and tempdb?
There is rarely any reason to do this, least of all in master.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: master database
    ... script to create stored procs only to realize I was in the ... Without a working master, your server is ... >stored procs only to realize I was in the wrong DB.... ... >> I support the Professional Association of SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Upgrading of Machine
    ... Once you copy the Master, ... What do I need to take note for SQL Server 2000? ... > including master, tempdb, msdb, model...and user dbf? ...
    (microsoft.public.sqlserver.setup)
  • clear tempdb
    ... i know that the tempdb gets cleared upon restarting of sql server, ... there a script that will do this? ...
    (microsoft.public.sqlserver.programming)
  • Re: Set seperate Log/Data file locations during install
    ... Generally it's only really tempdb that needs to be moved ... master and msdb tend to remain small enough for ... Jasper Smith (SQL Server MVP) ... > all data files but there is no way to specify one location for log files ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 - SQLDMO - Adding Logins/ Users
    ... sqldmo objects. ... it...I bet by adding it to the master db that it is automatically added ... to tempdb so I will try to add it to the 2rd db and see if that works. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)