SQL server Archives - Page 2 of 3 -

27 Sep, 2022

T-SQL query to check last Full, Differential and Log Backup Times 0 (0)

MSSQL, T-SQL Scripts Differential Backup, Full Backup, Log backup, SQL server, TSQL

Below query can be used to check last full, differential and transaction log backup times in SQL Server.

SELECT sd.[Name] AS DatabaseName,
LastFullBackUpTime=(SELECT MAX(bs.backup_finish_date) FROM msdb.dbo.backupset bs WHERE
bs.[database_name]=sd.[name] AND bs.[type]='D'),
LastDiffBackUpTime=(SELECT MAX(bs.backup_finish_date) FROM msdb.dbo.backupset bs WHERE
bs.[database_name]=sd.[name] AND bs.[type]='I'),

… Read the rest

26 Sep, 2022

T-SQL script to get list of SQL Server Agent job 0 (0)

MSSQL, T-SQL Scripts SQL server, SQL Server Agent, SQL Server Agent Job

Below query can be used to get list of all the SQL Agent Job details in SQL Server.

use msdb;
go
SELECT Convert(varchar(22),SERVERPROPERTY('ServerName')) AS 'ServerName',
convert(varchar(35),j.name) as 'JobName',
j.enabled,
CASE j.enabled WHEN 1 THEN 'Enabled' Else 'Disabled' END AS 'JobStatus',

… Read the rest

25 Sep, 2022

SQL Server: T-SQL Script to find object level permission for specific user 5 (1)

MSSQL, T-SQL Scripts database access, object level permission, SQL server, table level permission, TSQL

Below query can be used to find object level permission for specific user in SQL Server database.

use <DB-- replace database name here
go
select @@servername as Server, db_name() as 'Database', su.name as 'UserName', so.name as Object, permission_name as

… Read the rest

23 Sep, 2022

T-SQL query to get list of logins with bulkadmin role in SQL Server 0 (0)

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

Below query can be used to check bulkadmin 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.bulkadmin=1

Sample Output:

… Read the rest

22 Sep, 2022

The EXECUTE permission was denied on object 'sp_send_dbmail' 0 (0)

MSSQL msdb, sp_send_dbmail, SQL server

21 Sep, 2022

T-SQL query to find repetitive failed logins in SQL Server 0 (0)

MSSQL, T-SQL Scripts login failed, SQL server, TSQL

Below script is used to find logins which are failing repeatedly since 1 day. you can change the number of days as per your requirement. this script is taken from Here

SET NOCOUNT ON

	DECLARE @ErrorLogCount INT 
	DECLARE @LastLogDate DATETIME

… Read the rest

20 Sep, 2022

T-SQL query to script out database user permission in SQL Server 0 (0)

MSSQL, T-SQL Scripts database restore, database user permission, SQL server, SQL Server restore, TSQL

19 Sep, 2022

How to read SQL Server error logs using the xp_readerrorlog 5 (1)

MSSQL, T-SQL Scripts SQL server, SQL Server error log, sql server management studio, SSMS, xp_readerrorlog

In this article, we are going to explore xp_readerrorlog for reading SQL Server error logs using T-SQL command.

Reading SQL Server error log using T-SQL:

xp_readerrorlog

xp_readerrorlog Parameters Value Details:

xp_readerrorlog <paramter#1>,<paramter#2>,<paramter#3>,<paramter#4>,<paramter#5>,<paramter#6>,<paramter#7>

Parameter#1:… Read the rest

18 Sep, 2022

How to Install and Configure SQL Server Reporting Services (SSRS) 5 (1)

MSSQL Reporting Services, SQL server, SQL Server Reporting Services, SSRS

16 Sep, 2022

T-SQL query to check SQL server agent status 0 (0)

MSSQL, T-SQL Scripts SQL Agent, SQL server

Tag Archives: SQL server