A stored procedure is limited in length to abut 250MB. Stored procedures can contain any number of statements as long as the total length does not exceed this limit.
Find a good text editor to write your code. Or, if you want use Access. Set up a data project to an existing databse and link to your SQL Server database, then you can use Access's designers for creating stored procedures and/or views.
Custom Apps, Inc.