If, when attempting to start SQL Server instance, you get an error 1814, this means there's a problem with the tempdb database. Either it can't be created because the disk or volume is not accessible for writing (i.e. a security permission problem), or the volume on which the tempdb resides does not have enough space available. If the latter is the problem, you'll need at least 2 MB of free space for tempdb to be created.
You can retrieve a list of stored procedures in a SQL Server database through T-SQL by querying the built-in information_schema partition.
SELECT * FROM db_name.information_schema.routines WHERE routine_type = 'PROCEDURE'
Replace db_name with the name of the database you wish to retrieve the list of stored procedures. You can adjust the WHERE-clause even more to get a more narrow list.
You can also do this with the master database which will return all (system and non-system) stored procedures.
Probably MSSQL 101, but this is how to quickly retrieve the structure of a table:
EXEC sp_help tbl_name GO
tbl_name is the name of the table.
To change a user's (login's) password via Transact-SQL, use this:
read more
ALTER LOGIN User WITH
PASSWORD = 'new-password'
OLD_PASSWORD = 'old-password';
GO
