▼
▼
Showing posts with label mssql. Show all posts
Showing posts with label mssql. Show all posts
Friday, 14 May 2021

How to check roles for sql users

›
  The following query returns the members of the database roles. SELECT  DP1.name  AS  DatabaseRoleName,        isnull  (DP2.name,  'No ...
Thursday, 22 April 2021

Search by keyword in Stored procedure, Views, Functions And Tables

›
Purpose: The [util].[SearchAll] stored procedure searches for a specified string ( @strFind ) in the following database objects: Procedures...
Thursday, 25 February 2021

How to give SQL User access to execute Stored procedures and read/write access to database

›
Assumptions: stored procedures and tables are created under schema dbo. in case different schema, change the below code accordingly.   --Cre...
Wednesday, 6 January 2021

How to create XSD schema from MSSQL Database table

›
 You'll need Microsoft SQL Server Management Studio to run the below query.  Select the database where you want to run the query against...
Wednesday, 11 November 2020

How To create SSIS user in Azure SQL server

›
I've assumed you have already configured domain in azure and have created a domain user. Create Application in app registration    First...
Tuesday, 22 September 2020

How to find first weekday in the month in MSSQL

›
declare @n datetime = dateadd(mm,0,getDate())    declare @FirstWeekDayOfMonth int    SELECT @FirstWeekDayOfMonth= CASE          WHEN Dat...
Monday, 17 August 2020

Create Azure SQL User and add a sql role

›
I wanted to add a new sql user "sqluser" in Azure SQL server to access a database "sanjeeb".   Steps to create a new SQL...