Search code examples
sqlsql-serversqlexceptionsql-server-2005-express

What's the sql exception error number if the maximum limit of the database has been reached

For example SQL Server 2005 Express has a limit of 4gb on the database size, and it has been reached after cumulative inserts of data. What will be the corresponding error number?

Solution

  • I think these are the error codes you are looking for.

    Error 1827:

    "CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft SQL Server, Error: 1827)"

    Error 1105:

    "Could not allocate space for object 'dbo.t' in database 'ext' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup."

    Hope this helps