SQL Server common system tables

1. Querying the user tables in the current database

Select *from sysobjects where xtype= ' U ';

2. Get the maximum number of simultaneous user connections allowed by SQL Server

SELECT @ @MAX_CONNECTIONS;

3. Get connection information for the currently specified database

SELECT * from master.dbo.sysprocesses WHERE dbid in

(

SELECT dbid from master.dbo.sysdatabases

WHERE name= ' YourDatabaseName '

)

--Change yourdatabasename as needed

4. Get all the connection details of the current SQL Server, the query results include: System process and user process. If you just want to check the user process, you need to use the following method 5

SELECT *from sysprocesses

5. Gets the number of connections or attempts to connect since the last time the SQL Server service was started

SELECT @ @CONNECTIONS

SQL Server common system tables