SQL-Server 2005: Login name as variable?
- From: wolfram.hubert@xxxxxx
- Date: Mon, 14 Jan 2008 12:43:24 -0800 (PST)
Hello,
this follow code run successfull:
ALTER PROCEDURE [dbo].[test_user]
AS
DECLARE @sql nvarchar(150)
BEGIN
CREATE LOGIN [HM\WHubert] FROM WINDOWS WITH DEFAULT_DATABASE=[TEST],
DEFAULT_LANGUAGE=[Deutsch];
END
I will the code flexible. The login name even as variable. See you
next code:
SET @sql = 'HM\WHubert';
CREATE LOGIN [@sql] FROM WINDOWS WITH DEFAULT_DATABASE=[TEST],
DEFAULT_LANGUAGE=[Deutsch];
This Code generate the follow error message:
'@sql' ist kein gültiger Windows NT-Name. Geben Sie den vollständigen
Namen im folgenden Format an: <domain>\<username>.
A other variante with exec:
SET @sql = 'CREATE LOGIN [HM\WHubert] FROM WINDOWS WITH
DEFAULT_DATABASE=[TEST], DEFAULT_LANGUAGE=[Deutsch]'
EXEC @sql
This Code generate the follow error message:
Der Name 'CREATE LOGIN [HM\WHubert] FROM WINDOWS WITH
DEFAULT_DATABASE=[TEST], DEFAULT_LANGUAGE=[Deutsch]' ist kein gültiger
Bezeichner.
The login name is possible most flexible?
My environment: SQL2005 version: 9.00.3161.00
Cu
Wolfram Hubert
.
- Prev by Date: Biztalk vs SSIS as an ETL tool
- Next by Date: Re: How do I export a table to a text file of SQL statements?
- Previous by thread: Biztalk vs SSIS as an ETL tool
- Next by thread: Managing and viewing open files in SQL Server Management Studio
- Index(es):
Relevant Pages
|
