32,767 per instance of sql server. If you put all the sp's into a common
db then how would you address the correct database?
Andrew J. Kelly
SQL Server MVP
"sunil" <sunil_godiyal> wrote in message
news:uKKHo5wRDHA.1324TK2MSFTNGP11.phx.gbl...> Experts please advise.
> We are expecting around 100 clients to use our product on web.
> The data for each client will be around 20MB max each year.
> Is this a wise approach to keep all stored procedures in a common database
> and data in each client's database.
> Also is there a limit on number of databases SQL Server handle?