"Rajah" <raj***@zrgwortz.com> wrote in message
news:1131631336.774261.157340@g49g2000cwa.googlegroups.com...
> I'm using the release version of SQL Server 2005 tools (Microsoft SQL
> Server Management Studio 9.00.1399.00) and .NET Framework 2.0
> (2.0.50727.42) on Windows XP SP2.
>
> My desire was to use the new tools against my existing SQL 2000 servers
> as well as newly installed SQL 2005 so as to only have one place to
> work in and access to new tool features.  This has worked great except
> for one issue.  When trying to modify or script some table-valued
> functions under Management Studio I get the following error:
>
> ===================================
> Property QuotedIdentifierStatus is not available for
> UserDefinedFunction '[dbo].[fnFunction]'. This property may not exist
> for this object, or may not be retrievable due to insufficient access
> rights.  (Microsoft.SqlServer.Smo)
> ===================================
>
> I can edit/script the function in the 2000 tools (Enterprise Manager
> and SQL Analyzer) without problem.  I can edit some table-valued
> functions in Management Studio but not others.  I have tried dropping
> the functions and re-creating them in both 2000 and 2005 tools - the
> create works fine in both places, but it remains
> un-modifiable/scriptable in the 2005 tools.
>
> Anyone else run into this problem?
>
>>R<
>
>
> Additional info available for the error
> ===================================
> Program Location:
>   at
> Microsoft.SqlServer.Management.Smo.PropertyCollection.HandleNullValue(Int32
> index)
>   at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetPropValueOptional(String
> propName)
>   at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetPropValueOptional[T](String
> propName, T defaultValue)
>   at
> Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.CheckTextCorectness(String
> ddlText, Boolean enforceCreate, Boolean checkName, String[]
> expectedObjectTypes, DdlTextParserHeaderInfo& headerInfo)
>   at
> Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.CheckAndManipulateText(String
> ddlText, String[] expectedObjectTypes, ScriptingOptions so, Boolean
> forCreate)
>   at
> Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.GetTextHeader(Boolean
> forAlter)
>   at
> Microsoft.SqlServer.Management.Smo.UserDefinedFunction.ScriptHeader(Boolean
> forAlter)
>   at
> Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.ScriptExistingTextObjectToWindow(IManagedConnection
> mc)
>   at
> Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.InvokeTextObject(IManagedConnection
> connection)
>   at
> Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.Invoke()
> ===================================
>