Archive

Tag SQL server

Using a Format File to Bulk Import Data in SQL Server

Posted on February 5, 2019 by Suresh Kamrushi in SQL Server

+10 SQL Server OPENROWSET (starting with 2008) supports bulk operations through a built-in BULK provider that enables data from a file to be read and …

ASP. net MVC 4 – You do not have permission to use the bulk load statement.

Posted on April 6, 2018 by Suresh Kamrushi in C#

+20 When trying to execute store procedure having bulk insert, getting error as “You do not have permission to use the bulk load statement.” Error …

Creating new Database User in SQL Server using Management Studio

Posted on February 26, 2018 by Suresh Kamrushi in SQL Server

+30 Follow below steps to create a database user using SQL Server Management Studio. 1) Open SQL Server Management Studio and open “Object Explorer” and …

Exporting database using SQL server management studio

Posted on December 29, 2017 by Suresh Kamrushi in General

+30 Exporting database from SQL Management studio is very easy and it provides various options to make developer life easy, like: 1) Export the whole …