Skip to main content

[MSSQL]: Common T-SQL



-- Check version
PRINT @@Version


 SELECT * FROM sys.configurations


-- Show all processes
SELECT * FROM sys.sysprocesses


-- Check active connections
SELECT DB_NAME(dbid) AS DBName, COUNT(dbid) AS NumberOfConnections, loginame
FROM sys.sysprocesses
GROUP BY dbid, loginame
ORDER BY DB_NAME(dbid)


-- Check Collation used by all databases
USE Master
GO 
SELECT NAME, COLLATION_NAME 
FROM sys.Databases 
ORDER BY DATABASE_ID ASC 
GO

-- Enable 'sa' login
ALTER LOGIN [sa] ENABLE
GO

Popular posts from this blog

nmap - The Network Mapper

WARNING : It is ILLEGAL to scan hosts without permission.
Read more

GitHub CLI

GitHub CLI brings GitHub to your terminal. Free and open source. Official website: https://cli.github.com
Read more

Microsoft Windows Server 2003 R2 Enterprise Edition VHD

Windows Server 2003 R2 Enterprise Edition with Service Pack 2 This download comes as a pre-configured VHD and helps you evaluate the new features of Windows Server 2003 R2, the most productive infrastructure platform for powering connected applications, networks, and Web services from the workgroup to the data center. https://www.microsoft.com/en-us/download/details.aspx?id=19727 Username: Administrator Password: Evaluation1
Read more