ManageEngine SupportCenter Plus: Changing Request Starting ID
How to change the starting request ID number in ManageEngine SupportCenter Plus. For ServiceDesk Plus MSP
Read More ManageEngine SupportCenter Plus: Changing Request Starting IDMSSQL
MSSQL Find Last Date & Time Database Table Accessed
This is a T-SQL that will show all the last access date and time for Select, tables in a database.
Read More MSSQL Find Last Date & Time Database Table AccessedMSSQL Server Uptime Using T-SQL
A sample T-SQL for determining uptime of a Microsoft SQL Server.
Read More MSSQL Server Uptime Using T-SQLGet ALL table and column descriptions in MSSQL
Get MS_Description from all tables AND columns in a database. Suh-weet. SELECT u.name + ‘.’ + t.name AS [table], td.value AS [table_desc], c.name AS [column], cd.value AS [column_desc] FROM sysobjects t INNER JOIN sysusers u ON u.uid = t.uid LEFT OUTER JOIN sys.extended_properties td ON td.major_id = t.id AND td.minor_id = 0 AND td.name =…
Read More Get ALL table and column descriptions in MSSQLSQL Show Jobs that Will Run
This will show jobs that will run. I lost the link I found this at. Eventually, I need to add a few columns to report scheduling information, etc. This is a nice start though. USE msdb ;WITH CTE AS (SELECT schedule_id, job_id, RIGHT(‘0’+CAST(next_run_time AS VARCHAR(6)),6) AS next_run_time, next_run_date FROM sysjobschedules) SELECT A.name Job_Name, ‘Will be…
Read More SQL Show Jobs that Will RunCheck Fragmentation on Objects in SQL Database
tsql so I can remember in the future. declare @db_id int declare @object_id int set @db_id = DB_ID(‘EMR’) set @object_id = 0 select db_name(@db_id) as [database], object_id, object_name(object_id, @db_id) as object_name, index_id, avg_fragmentation_in_percent, page_count from sys.dm_db_index_physical_stats(@db_id, null, null, null, ‘LIMITED’) where page_count > 1000 and avg_fragmentation_in_percent > 35 order by avg_fragmentation_in_percent desc database object_id object_name…
Read More Check Fragmentation on Objects in SQL Database