Many times you need to add namespaces to your application, here I sharing how you can add “System.ServiceProcess” required to incorporate windows services to your application.

Follow the below steps add references:

1) Right click on solution explore and click on “Add reference..

2) go to Assembly => Framework and look for “System.ServiceProcess” and enable it.

--

--

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

When trying to execute store procedure having bulk insert, getting error as

“You do not have permission to use the bulk load statement.

Error is popping up due to permission is not granted to SQL user accessing DB. So Below I am sharing how you can provide permission to user to fix this issue.

1) Go to MS SQL server management and connect to db.

2) In Object Explorer, go to Security and then login.

3) Look for your user and right click on it.

4) “Login Properties” popup will open

5) Click on “Server Roles” and check “bulkadmin”.

--

--