Create Login like another login...

One bit of functionality I like in Oracle's Enterprise manager, that I
haven't located in SQL Server is the ability to create a new login with all
the same rights, roles etc of an existing user.
I am using SQL Server 2005. I have tried
USP_GEN_USER_RIGHTS_BASED_ON_EXISTING_LO
GIN written by GREG LARSEN, but I ge
t
an error when executing it.
==================
Msg 213, Level 16, State 7, Line 2
Insert Error: Column name or number of supplied values does not match table
definition.
==================
Does anyone point me to a way of doing this?
PaulThat's a pretty old script you're using and it's written for SQL Server
2000, calling objects in the master database.
You can update the script using some of the security catalog views instead
of tables in master. For example, fn_my_permissions will tell you what
effective permissions the current user has.
As for the error message below, it looks like you probably had a typo
somewhere when creating or running the sproc. Probably a datatype mismatch.
joe.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:CFECA19B-9C34-4D52-B9FC-1FA95817EE78@.microsoft.com...
> One bit of functionality I like in Oracle's Enterprise manager, that I
> haven't located in SQL Server is the ability to create a new login with
> all
> the same rights, roles etc of an existing user.
> I am using SQL Server 2005. I have tried
> USP_GEN_USER_RIGHTS_BASED_ON_EXISTING_LO
GIN written by GREG LARSEN, but I
> get
> an error when executing it.
> ==================
> Msg 213, Level 16, State 7, Line 2
> Insert Error: Column name or number of supplied values does not match
> table
> definition.
> ==================
> Does anyone point me to a way of doing this?
> Paul

Create database on NAS

I am using SQL 2005 std edtition. Everyone time I create a new database with
files being located to say \\nas\db2. I get 5110 error.(5110 (File
'file_name' Is On A Network Device Not Supported For Database Files).
I read about traceon and other MS KBs but no luck. Anyone ?
thanks(a) I strongly recommend NOT using a NAS for SQL Server... this is not
exactly a robust environment to be running a high performance database
application.
(b) if you really want to go through with it, then you should be mapping a
driver letter for the SQL Server service account user (and any other user
that will need to access it). Ideally, SQL Server uses a local drive (even
if we are talking SAN / direct attached storage), but barring that, it at
least needs to *look* like a local drive.
A
"andyoye" <andyoye@.nospam.com> wrote in message
news:%23RA0%23q04HHA.1484@.TK2MSFTNGP06.phx.gbl...
>I am using SQL 2005 std edtition. Everyone time I create a new database
>with files being located to say \\nas\db2. I get 5110 error.(5110 (File
>'file_name' Is On A Network Device Not Supported For Database Files).
> I read about traceon and other MS KBs but no luck. Anyone ?
> thanks
>
>|||And here's a KB on the topic:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uiZtE104HHA.4476@.TK2MSFTNGP06.phx.gbl...
> (a) I strongly recommend NOT using a NAS for SQL Server... this is not exactly a robust
> environment to be running a high performance database application.
> (b) if you really want to go through with it, then you should be mapping a driver letter for the
> SQL Server service account user (and any other user that will need to access it). Ideally, SQL
> Server uses a local drive (even if we are talking SAN / direct attached storage), but barring
> that, it at least needs to *look* like a local drive.
> A
>
> "andyoye" <andyoye@.nospam.com> wrote in message news:%23RA0%23q04HHA.1484@.TK2MSFTNGP06.phx.gbl...
>>I am using SQL 2005 std edtition. Everyone time I create a new database with files being located
>>to say \\nas\db2. I get 5110 error.(5110 (File 'file_name' Is On A Network Device Not Supported
>>For Database Files).
>> I read about traceon and other MS KBs but no luck. Anyone ?
>> thanks
>>
>