Script Size Limit in SQL Server Management Studio

Question

For example: how many lines of

insert into foo ( '1','2' )

could one have in a file. I remember it being around 100k but searching with google has proved fruitless thus far.

Answer 1

I'm not sure if there is a hard limit, my largest file, generated by the Database Publisher is around 270K and that runs fine.

Answer 2

According to this article on how to specify the script size at which IntelliSense functionality is disabled you are allowed more than 2MB, in SQL Server 2008 at least.