CODEWITHSUNDEEP
sqlsql-serverssms
Ben McNiel
Ben McNiel

Reputation: 8801

Script Size Limit in SQL Server Management Studio

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.

Upvotes: 3

Views: 5928

Answers (2)

stuartd
stuartd

Reputation: 73313

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.

Upvotes: 1

MrTelly
MrTelly

Reputation: 14875

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.

Upvotes: 0

Related Questions