John,

Not to worry <g> ... SQL Server can handle it just fine. And 100 SP's is nothing!!

The nice thing about it is, if the server ever *does* get overwhelmed all the IT department has to do is throw more resources at it (more RAM, faster processors, more hard-drive space) or have a "server farm" and the problem is solved. SQL Server is *very* scalable that way.

~~Bonnie

>First I'm not a SQL guy so this may be a foolish question. I'm writing a new program that will connect to an existing SQL 7 server. The server is supporting over 100 SPs. I'll be adding a new database and about 20 tables. I'd like to use SPs but it occured to me that adding more SPs to the system is really asking a lot from a server. What would be a good rule to follow regarding SPs? How can I figure out if my SPs will be to much for the server. The hardware is a dual something with plenty of ram and scsi drives. Any help or information would be great. TIA
>John