T-SQL (Bulk Insert)

[lowbo]

I have been trying to perform a Bulk Insert using T-SQL with Toad for SQL Server. I receive an error saying I don't have permission to run this statement. Are we not allowed to use standard stored procs of SQL Server? Is there another way to load the data from a file, because single INSERTs is way to tedious.

[bruce]

bulk insert should be available for you to use.

you may be trying to insert into a database that you do not have access to. eg. the master db

[b]quote:Originally posted by lowbo

I have been trying to perform a Bulk Insert using T-SQL with Toad for SQL Server. I receive an error saying I don't have permission to run this statement. Are we not allowed to use standard stored procs of SQL Server? Is there another way to load the date from a file, because single INSERTs is way to tedious.
</blockquote id="quote"></font id="quote">

[lowbo]

Here is the response from Tech Support if anyone in the future runs into this problem.

Sorry that we do not allow BULK INSERT in our shared SQL environment. We cannot allow that since only sysadmin and bulkadmin fixed server roles can perform BULKK INSERT, which we cannot add customer to in a shared environment.

Thank you

DiscountASP.NET
The power of ASP.NET for less

[bruce]

Oops..

[:I]

[b]quote:Originally posted by lowbo

Here is the response from Tech Support if anyone in the future runs into this problem.

Sorry that we do not allow BULK INSERT in our shared SQL environment. We cannot allow that since only sysadmin and bulkadmin fixed server roles can perform BULKK INSERT, which we cannot add customer to in a shared environment.

Thank you

DiscountASP.NET
The power of ASP.NET for less
</blockquote id="quote"></font id="quote">