Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

The permissions granted to user ‘Domain\User’ are insufficient for performing this operation. (rsAccessDenied)

The permissions granted to user ‘Domain\User’ are insufficient for performing this operation. (rsAccessDenied) Hi friends in my previous post I had installed SQL Server 2016 – With Reporting Services. So I think a go through is must from reporting services, Although I am looking what Microsoft introduced new on Reporting Services. But after configuration end

How to Install SQL Server 2016

How to Install SQL Server 2016 Hi friends in this post we will learn how to install SQL Server 2016 or Installing SQL Server 2016. Here I am using Windows Server 2012 R2 Standard Edition 64 bit. I had applied all necessary updates & patches on windows server. Also install Windows Server 2012 KB2919355 &

Microsoft SQL Server 2016

Microsoft SQL Server 2016 Hi friends in this post we will discuss about Microsoft SQL Server 2016. Here we will discuss about SQL Server 2016 features, Download link etc.. Microsoft had just launched Microsoft SQL Server 2016 for Public, now anyone can download public Community Technology Preview (CTP2) for SQL Server 2016 from here  https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016. This

How to Search all Stored Procedures in a Database for a Particular String

How to Search all Stored Procedures in a Database for a Particular String Hi friends in this post we will discuss How to Search all Stored Procedures in a Database for a Particular String or Search all stored Procedures having a particular string. I have been asked by my Manager to send him a report all

Send SQL SERVER Query Result by Database Mail

Send SQL SERVER Query Result by Database Mail Hi friends in this topic we will learn how can we send query results through database mail in SQL SERVER, or you can say also how to Send SQL SERVER Query Result by Database Mail. Earlier we had discussed SQL Query Result set to Html Table. My manager told

TSQL-Checking Database Recovery Model

TSQL-Checking Database Recovery Model In this post we will learn how to check recovery model of all database hosted on your SQL Server or you can say TSQL-Checking Database Recovery Model. This is very easy we just have to run a script to do this. Earlier we had discussed about Change Data Capture in SQL Server, DDL Triggers