One Offs

on July 27, 2015 at 12:45 pm
Posted In: MS SQL Server (Cat)

select DB_ID(‘Maintenance’)

select OBJECT_ID(‘CommandLog’)

select * from sys.dm_db_index_physical_stats(13, 2105058535, -1, 0,NULL)

list traces — SELECT * FROM :: fn_trace_getinfo(default)

delete trace — oracle sp_trace_setstatus @traceid=?, @status =2

SELECT name FROM sys.databases


 

Â