Re: Default name for domain
- From: "Pablo Montilla" <melkor@xxxxxxxxxxxxxx>
- Date: Thu, 22 Mar 2007 09:32:57 -0300
Many thanks, I'll try that.
Pablo
On Wed, 21 Mar 2007 22:00:19 -0300, Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx> wrote:
One option is to use variables and dynamically build the
SQL statements to create the logins. You can get the server
name using
select @@servername
You can use that to build the login names specific for a
machine.
-Sue
On Wed, 21 Mar 2007 18:31:41 -0300, "Pablo Montilla"
<melkor@xxxxxxxxxxxxxx> wrote:
Hello, I'm creating a script that will create logins for groups of a
windows machine, and I want to know if there's a way for me not to have to
specify the machine domain name.
Something like the '.\sqlexpress' name to identify the sqlexpress instance
in running in the local machine:
CREATE LOGIN [.\O2 - Viewer] FROM WINDOWS
Does something like this exist?
Regards,
Pablo Montilla
.
- References:
- Default name for domain
- From: Pablo Montilla
- Re: Default name for domain
- From: Sue Hoegemeier
- Default name for domain
- Prev by Date: Re: I need to restrict [database].MDF file's using on other MSSQL server. HELP!!!
- Next by Date: Re: password expiration
- Previous by thread: Re: Default name for domain
- Next by thread: Re: How to assign Server roles to database role?
- Index(es):
Relevant Pages
|
|
