Setting quoted identifier on in CLR stored proc

• Cowboy DBA

  SSCrazy

  Points: 2135

  More actions

  July 24, 2012 at 10:21 am

  #264672

  I've created a .NET CLR stored proc which exports binary to a file. However when I deploy it to the database server it violates the policy that quoted identifiers should be on.

  Any ideas how I can set this in VS 2010? :crazy:

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  July 24, 2012 at 1:45 pm

  #1517057

  In VS go to the menu -- Tools >> Options >> Database Tools >> Transact-SQL Editor >> Query Execution >> ANSI

  Here you will find the SET QUOTED_IDENTIFIER option (along with all the other ANSI options).

  
  
  A.J.
  DBA with an attitude

• Cowboy DBA

  SSCrazy

  Points: 2135

  More actions

  July 25, 2012 at 1:40 am

  #1517195

  Thanks for the tip but it doesn't seem to have worked. Basically my CLR is a modified version of this:

  http://stackoverflow.com/questions/10325338/fastest-way-to-export-blobs-from-table-into-individual-files

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  July 25, 2012 at 9:39 am

  #1517448

  Could you post an exact copy of the error?

  
  
  A.J.
  DBA with an attitude