How can we help you today? How can we help you today?

Can't update UDF's created for SqlClr

I am unable to update the UDF's created by the Visual Studio 2005 deployment of SqlClr code. Any idea what's going on? Thanks.

Using SQL Server 2005, RedGate 5.3.0.44.

Here is the error:
The following error message was returned from the SQL Server:

[1001] Line 1: Length or precision specification 0 is invalid.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'EXTERNAL'.

The following SQL command caused the error:

CREATE FUNCTION [dbo].[fnIntegerListToTable] (@list [nvarchar] (0))
RETURNS TABLE (
[number] [int] NULL)
WITH EXECUTE AS CALLER
EXTERNAL NAME [SwSqlClr].[UserDefinedFunctions].[InitIntegerListToTable]

The following messages were returned from the SQL Server:

[5701] Changed database context to 'ESPIntegration'.
[5703] Changed language setting to us_english.
[0] Dropping [dbo].[DelimitedList_Concat]
[0] Dropping [dbo].[DelimitedList_Space]
[0] Dropping [dbo].[DelimitedList_Comma]
[0] Dropping [dbo].[fnConvertBase64ToBinary]
[0] Dropping [dbo].[fnStringListToTable]
[0] Dropping [dbo].[fnBankersRound]
[0] Dropping [dbo].[fnIntegerListToTable]
[0] Dropping CLR assemblies
[0] Creating CLR assemblies
[0] Creating [dbo].[fnIntegerListToTable]


Here is the text of the UDF it is trying to deploy:
USE [ESP]
GO
/****** Object:  UserDefinedFunction [dbo].[fnIntegerListToTable]    Script Date: 06/11/2007 16:00:11 ******/
ALTER FUNCTION [dbo].[fnIntegerListToTable](@list [nvarchar](max))
RETURNS  TABLE (
	[number] [int] NULL
) WITH EXECUTE AS CALLER
AS 
EXTERNAL NAME [SwSqlClr].[UserDefinedFunctions].[InitIntegerListToTable]
dkent
0

Comments

7 comments

Sort by
  • Brian Donahue
    Hi,

    Thanks for letting us know. A fix for this is scheduled for version 6. It looks like an attempt to fix it in version 5.3 had failed. (bug 62441)
    Brian Donahue
    0
  • dkent
    OK, thanks. When is 6.0 going to be released?
    dkent
    0
  • Simon L
    Hi,

    There should be an official release within the next two weeks.

    Regards
    Simon
    Simon L
    0
  • dkent
    Cool, thanks. We look forward to the release.
    dkent
    0
  • mdavide
    Hi,
    Will this also correct this same issue in the SQL Packager product? I'm getting the exact same issue as OP.

    Thanks,

    Mike
    mdavide
    0
  • Brian Donahue
    Hi Mike,

    I've had a look at the SQL Bundle today, and I've noticed that the shared components for SQL Compare 6 are in their own separate folder. The SQL Compare 6 update, therefore, does not affect Packager as yet.

    Sorry for the inconvenience.
    Brian Donahue
    0
  • mdavide
    Brian,
    Any idea when this will be implemented in the SQL Packager application? This makes it a little difficult.

    Thanks,

    Mike
    mdavide
    0

Add comment

Please sign in to leave a comment.