Anything that you can do as a normal T/SQL statement can be done via a stored procedure. In some cases you may have to use dynamic SQL do to them however. For example you can’t create a stored procedure from within another stored procedure unless you use dynamic SQL. The big requirement is that you have to have access to perform the operation.
REGISTER or login: