sp_help_job returns information about jobs that are used by SQLServerAgent service to perform automated activities in SQL Server. EXEC MSDB.DBO.SP_HELP_JOB
Month: March 2008
List all the database on SQL Servers. SQL SERVER 2005 System Procedures EXEC sp_databases EXEC sp_helpdb SQL 2000 Method still works in SQL Server 2005 SELECT name FROM sys.databases SELECT name FROM sys.sysdatabases
The UNC is a standardized method for naming servers, files, and directories in shared computer networks and for identifying the location of shared peripheral devices, such as printers, scanners, or other such resources. The format of a UNC file name usually uses two backslashes (\\) to designate a server and a single backslash to name […]
The db_datareader role The db_datareader role has the ability to run a SELECT statement against any table or view in the database. This role is often used in reporting databases where users would be coming in via a third-party reporting tool and building their own ad-hoc queries. If you need to restrict a user to […]