Okay, I know the maximum size limit on a database in SQL 2005 Express is 4GB, but what happens when you exceed that limit? I can't seem to find much info on that topic. What kind of error return would you get from a stored procedure attempting to do an insert that will exceed the 4GB limitation? Also what factors go into that maximum size, factors that might not be completely obvious of course?
Try the link below for all the info you need, what I can tell is the read access can be scaled to very high number, if you are doing inserts and updates you should limit it to 3.5gig so SQL Server can keep .5gig for house keeping. Hope this helps.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
No comments:
Post a Comment