whats the frequency of the letter a in:
ssc journeyman
points: 84
system.data.sqlclient.sqlerror: create database or alter database failed because the resulting cumulative database size would exceed your licensed limit of 10240 mb per database. (microsoft.sqlserver.express.smo)
ssc guru
points: 105661
sql server express has a limit of 10 gb per database.
actually, in sql server 2005 the limit was 4 gb, so you must be using some version from 2008r2 up.
-- gianluca sartori
how to post t-sql questions
spaghettidba.com
@spaghettidba
ssc journeyman
points: 84
we use window 2007,
can i used window server 2008 for solve this.
no such version as windows 2007...
the size limit in sql express for all versions 2008 r2 and above is 10gb. if you need a larger db than that, you need to purchase a licence for one of the paid editions of sql, probably standard edition. (or developer if this is a development-only environment)
gail shaw
microsoft certified master: sql server, mvp, m.sc (comp sci)
sql in the wild: discussions on db performance with occasional diversions into recoverability
viewing 4 posts - 1 through 4 (of 4 total)
user
In the text, there are sixty "a"s.
assistant