October 2022 - Page 2 of 2 -

3 Oct, 2022

Sybase Replication: How to check table level replication 0 (0)

Sybase Replication #sybase replication, MSA, table level replication, warmstandby

3 Oct, 2022

T-SQL script to get list of logins having Sysadmin permission 0 (0)

MSSQL, T-SQL Scripts bulkadmin, dbcreator, diskadmin, processadmin, securityadmin, setupadmin, SQL server, sysadmin, TSQL

Below query can be used to check Sysadmin Server role in SQL Server.

select @@servername as Server,sp.name as LoginName,
type_desc as LoginType
from sys.server_principals sp
inner join sys.syslogins sl
on sp.sid=sl.sid
where Sl.sysadmin=1

Sample Output:

… Read the rest

3 Oct, 2022

T-SQL query to check failed SQL Agent Jobs in the Last 24 Hour 0 (0)

MSSQL, T-SQL Scripts SQL agent job, SQL server, SQL Server Agent

Below query can be used to check SQL Agent failed jobs in last 24 hours. This query can be used in the monitoring script to find out failed job in SQL server agent.

SELECT sj.[name] AS "Failed Job Name", jh.run_date,jh.[message]

… Read the rest

2 Oct, 2022

T-SQL script to check server level permission in SQL Server 5 (1)

MSSQL, T-SQL Scripts SQL server, SQL server access, view server state

Below query script can be used to check server level access for specified user in SQL Server.

SELECT spr.name as grantee_name, sp.state_desc, sp.permission_name FROM
sys.server_permissions AS sp JOIN sys.server_principals AS spr ON
sp.grantee_principal_id = spr.principal_id
where spr.name not like '%##%'

… Read the rest

1 Oct, 2022

How to Write Events to Windows Event Viewer log in SQL Server 5 (1)

MSSQL event viewer, SQL server, SQL Server event viewer

Monthly Archives: October 2022

Sybase Replication: How to check table level replication 0 (0)

T-SQL script to get list of logins having Sysadmin permission 0 (0)

T-SQL query to check failed SQL Agent Jobs in the Last 24 Hour 0 (0)

T-SQL script to check server level permission in SQL Server 5 (1)

How to Write Events to Windows Event Viewer log in SQL Server 5 (1)