Considder the following SP:

CREATE Procedure My_SP
	@Id uniqueidentifier,
	@Data binary(1024)
AS
INSERT INTO My_Table
	(Id, Data)
	VALUES 
	(@Id, @Data)

I pass a byte array of length 2048 bytes, but the SP executes just like normal. I have not examined the data that is inserted into the column yet, but I would expect this to raise some sort of exception (Exceptions are raised if I try to pass a string that is longer than 30 characters to a nvarchar(30) column).

Any thoughts on the issue?

Thanks,
Einar