What are the limits of Sql Server 2000?

 Posted by Neeks on 3/5/2009 | Category: Sql Server Interview questions | Views: 3412

When you are creating or changing a stored procedure,please keep in mind that
The name of the procedure is a standard Transact-SQL identifier. The maximum length of any identifier is 128 characters.
Stored procedures may contain up to 1,024 input and output parameters.
The body of the stored procedure consists of one or more
Transact-SQL statements. The maximum size of the body of the stored procedure is 128MB.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response