use [master] go SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame order by 2 desc SELECT * FROM sys.dm_exec_sessions where host_name is not…
select CHARINDEX(<char>,<columnname>,[<startpoint>]) from <tablename>;
use [XYZ] — your database name go select name, type_desc from sys.all_objects where object_id in (select object_id from sys.all_columns where upper(name)='<your column name>’) go
use [<dbname>] go SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) – SUM(a.used_pages)) * 8 AS UnusedSpaceKB FROM sys.tables t INNER JOIN…
Many of the Windows admin tools can be quickly accessed by launching them from an administrator command prompt. AD Domains and Trusts domain.msc Active Directory Management admgmt.msc AD Sites and Serrvices dssite.msc AD Users and…
When migrating or moving a database from one instance to another, be careful with logins and database owners. Ideally, all logins, principals etc. on the source instance should be present on the new instance. after…