USE [tempdb];

------------------------------------------

GO
CREATE PROCEDURE dbo.TestReadOnlyWithNonTVP
(
	@Param INT = 5 READONLY
)
AS

SELECT @Param;
GO
/*
Msg 346, Level 15, State 1, Procedure TestReadOnlyWithNonTVP, Line XX [Batch Start Line YY]
The parameter "@Param" can not be declared READONLY since it is not a table-valued parameter
*/

------------------------------------------

CREATE TYPE dbo.TestTableType AS TABLE
(
	Col INT
);


GO
CREATE PROCEDURE dbo.TestNoReadOnlyWithTVP
(
	@Param dbo.TestTableType
)
AS

SELECT * FROM @Param;
GO
/*
Msg 352, Level 15, State 1, Procedure TestNoReadOnlyWithTVP, Line XX [Batch Start Line YY]
The table-valued parameter "@Param" must be declared with the READONLY option.
*/

------------------------------------------