They are called
system procedures and they usually start with "sp" or "xp". Think of them as commands that the good ole folks from SQL Server team created for your comfort. They can be very helpful too.
You can query database details using the
sp_helpdb system proc or add a user using the
sp_addlogin system proc.
here, try this
Code:
exec sp_addlogin 'melvik', 'a_password', 'Northwind'
go
use Northwind
exec sp_grantdbaccess 'melvik'
go
exec sp_revokedbaccess 'melvik'
go
exec sp_droplogin 'melvik'
go
use master
go
exec sp_helpdb 'Northwind
go
see online books for more system/extended procedures
extra tables in MS-SQL Server
