What is the max number of parameters that can be passed in stored procedure

Question

Server in qustion is SQL Server 2008.

On the same note, I need to know what is the max length of the string parameter passed in SP?

Answer 1

According to MSDN, SQL Server limits the number of parameters per stored procedure to 2,100.

Answer 2

What is the max number of parameters that can be passed in stored procedure?

A: 2100 - link shamelessly stolen from Andrew's answer.

On the same note, I need to know what is the max length of the string parameter passes in SP?

You can use VARCHAR(MAX)/NVARCHAR(MAX) datatype, it can store up to 2 GB of data.