anyone else unable to check in functions with inline = off

as per the title really we have some (SQL 2019) functions with inline turned off. This causes the whole check in to fail.
The only way so far we have found to workaround is to keep this line commented out when checking in.
example:

create function dbo.inlinefail
(
@input as int
)
returns int
with inline = off
as
begin
return 2;
end

we are using source control 7.4.6.16xxx
We already raised a ticket, but have been told it wont be addressed. So have other people found a better workaround?

Answers

  • Hi @swisssi

    Hoping you do find a workaround for this issue, in the interim I would also suggest making a post on the SQL Source Control UserVoice page:
    https://redgate.uservoice.com/forums/39019-sql-source-control

    UserVoice is a place for functionality/feature requests to be made and are viewed directly by our product and development teams. 

    It may be another avenue for your inquiry. When posting on UserVoice it's recommended to include any impact that the request is having on your organisation or how a change such as this would help your pipeline/processes by using our software.
    Jon Kirkwood | Technical Support Engineer | Redgate Software
Sign In or Register to comment.