Updating sys servers
This enables you to bypass the need for directory services (such as LDAP or an interfaces file) for the server when using the CT-Library.
In order to attach the databases rather that perform a restore on each one of them from backups (reasons: time consuming, backups are not up to date, backups don’t exist), I have to change the physical path for all user databases inside master database to point to an existing location with enough space, so that at the next SQL startup the databases will all come online as well.For all other principals it is a unique identifier similar to a GUID.However, the only place the SID is used internally by SQL Server is to link a login to a database user.Servers table has a row per linked or remote server including a row for itself, while the sys.linked_logins returns the login mapping for each linked server.The sys.server_principals table then returns the server-level principal information for each linked server There are several methods for viewing the details of linked servers in SQL Server.Rather than viewing limited information or having to manually view the set-up code for each linked server, a query to the system tables will show amazing detail of all linked servers in one go.
is the name used to address the server on your system.
sp_addserver adds a row to the sysservers table if there is no entry already present for lname.
Server names must be unique and must conform to the rules for identifiers.
is the name in the interfaces file for the server named lname.
This enables you to establish local aliases for other Adaptive Servers or Backup Servers that you may need to communicate with. Component Integration Services only – You can use pname to specify the hostname or IP address and the port of the server you wish to connect to.
SQL Server utilizes a two level authentication system: Logins and Users.