ANSI - QUOTE IDENTIFIER

• cb-488631

  SSC Rookie

  Points: 37

  More actions

  February 26, 2008 at 6:03 am

  #187025

  Hello:

  i created a table valued function in MS 2005 and i am unable to open it because of the following error.

  "Property QuotedIdentifierStatus is not available for UDF......"

  I tried set ansi on but it doesn't work in a function.

  Can someone help please?

  Thanks,

  c

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  March 3, 2008 at 12:58 pm

  #784643

  do you have set commands in your function?

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/