What is Sp_addlogin?

Question

Description. Adds a new user account to Adaptive Server; specifies the password expiration interval, the minimum password length, and the maximum number of failed logins allowed for a specified login at creation.

What is Sp_addrole?

Creates a new database role in the current database. sp_addrole is included for compatibility with earlier versions of MicrosoftSQL Server and may not be supported in a future release. Use CREATE ROLE instead. Transact-SQL Syntax Conventions.

What happens to database logins when you restore the database on another server?

Sometimes, it is necessary to move the database from one server to another. The problem is that usually the logins and the database users are mapped. If that is the case, when you backup a Database and restore a database in another server, the logins are lost.

Expert · Answer

Creates a new database role in the current database. sp_addrole is included for compatibility with earlier versions of MicrosoftSQL Server and may not be supported in a future release. Use CREATE ROLE instead. Transact-SQL Syntax Conventions.

Expert · Answer

Sometimes, it is necessary to move the database from one server to another. The problem is that usually the logins and the database users are mapped. If that is the case, when you backup a Database and restore a database in another server, the logins are lost.

What is Sp_addlogin?

What is Sp_addrole?

What happens to database logins when you restore the database on another server?

Related Questions