Thanks lowell

lowell,

how do you set the delimiter '|' option

This query makes us to load the data from .csv files to database. But, my question is to how to load the data from database to .csv files without...

Gila,

I have created an application role and given write permissions. But, I am not...

Thank you. Basically, I have a situation where when users log on through SSMS, they should have only "Read" access. But, the same users when they work through front-end applications,...

Does anyone know how to set a user an application role? I am still in process of assigning a single user with different level of access, as one if he...

This URL is helping me little bit..

http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/

The application where the users are trying to connect has the same credentials where they connect to the database. we want some trigger/ proc where when users connect to database..it...

Yes...you are right...

sounds good. Thank you

My CSV file is of "|" limiter. I am trying using the following BCP command but receives error.

SET IDENTITY_INSERT table1 On

DECLARE @cmd nvarchar(500)

SELECT @cmd = 'bcp slcdb.dbo.table1 IN...

I am receiving the following error..can some one please rectify..Thank you.

NULL

Starting copy...

SQLState = S1000, NativeError = 0

Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in BCP data-file

NULL

0 rows copied.

Network...

My file is in network location...I am trying to pull the file...onto server..but receiving error: file could not be opened....is bulk insert takes only local drive files.

Ya I just did that...but does the bcp won't take the files from network location..

Thanks much...What if we don't have permissions to run xp_cmdshell. Do we have any other options to import the data..