Create user similar to 'sa'

[cbhrook]

In SQL Server 2000, how do you create a new user that essentially has the same permissions as the default 'sa' user, preferrable through Enterprise Manager?

[ck9663]

I believe (read: not sure) so. Just give him all the rights. During user creation, grant him all the server rights.

-- CK

[Jim Doherty]

In SQL Server 2000, how do you create a new user that essentially has the same permissions as the default 'sa' user, preferrable through Enterprise Manager?

Grant Access as a Server Administrator

Enterprise manager...secur ity node...logins.. .select the user...double click ...Server roles tab .....then tick Server Administrator