Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Error with CLR Stored Procedures

Zdenek Sery Jun 17, 2013 06:03PM AEST

Hi,

I try project from existing DB and next I click to validate with this results:

Error: : The three-part object identifier [DS].[StoredProcedures].[p_FileExist] is not permitted as this could cause cross-database object or data modification. For intra-database references use a two-part name instead, e.g. [StoredProcedures].[p_FileExist]

there is code:
CREATE PROCEDURE [COMMON].[p_FileExist]
@path [nvarchar](4000),
@name [nvarchar](4000),
@myDomainname [nvarchar](4000),
@exist [bit] OUTPUT
AS
EXTERNAL NAME [DS].[StoredProcedures].[p_FileExist]

----------------------------------------------------------
SP is c# procedure (Assembly DS).

Thanks for help.

2 Community Answers

Best Answer
Daniel Nolan Mar 22, 2014 12:47AM AEDT

Hi Zdenek,

We’ve recently made some significant improvements to our support for SQLCLR within ReadyRoll.

Version 1.8.1 features a new workflow that allows you to include assemblies as an “inline dependency” within your migration scripts.

Read more about this feature here:
http://ready-roll.com/blog/2014/03/21/developing-and-deploying-net-sqlclr

Best Regards,

Daniel

View in conversation


Up -5 rated Down
Daniel Nolan Jun 24, 2013 06:20PM AEST ReadyRoll Agent

Hi Zdenek,

(Posting the resolution that I provided in our offline discussion on JUN 17TH, 2013)

Sorry that you’ve encountered an error while attempting to import your CLR stored procedures.

I can confirm that this is a bug in ReadyRoll version 1.5.2. The error being reported should only apply to cross-database references, not CLR stored procedure/function references.

A fix will be available in ReadyRoll 1.6, due for release by June 28th, 2013. In the meantime, the only workaround available is to exclude (uncheck) these types of objects when importing your database.

Best Regards,

Daniel

Up 1 rated Down
Daniel Nolan Best Answer Mar 22, 2014 12:47AM AEDT ReadyRoll Agent

Hi Zdenek,

We’ve recently made some significant improvements to our support for SQLCLR within ReadyRoll.

Version 1.8.1 features a new workflow that allows you to include assemblies as an “inline dependency” within your migration scripts.

Read more about this feature here:
http://ready-roll.com/blog/2014/03/21/developing-and-deploying-net-sqlclr

Best Regards,

Daniel

This question has received the maximum number of answers.

readyroll.support@red-gate.com
http://assets3.desk.com/
false
readyrollsql
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete