2005 Express Edition CREATE statement issues

Hello everyone,

i am using the Express Edition to build an application which requires rather large databases to store binary documents. I've been experiencing weird behaviour with the Express Edition on Vista and XP running the following CREATE statement:

Code Snippet

USE master;
GO
CREATE DATABASE [document_archive]
ON PRIMARY
( NAME='document_archive_Primary',
FILENAME='D:\Data\document_archive.mdf',
SIZE=32MB,
MAXSIZE=1536MB,
FILEGROWTH=10%)
LOG ON
( NAME='document_archive_Log',
FILENAME = 'D:\Data\document_archive.ldf',
SIZE=8MB,
MAXSIZE=64MB,
FILEGROWTH=10%);
GO

The server is telling me that everything went ok but the database doesent show up in the TreeView, nor it is accessible. Retrying to execute the script i cought an error telling me that the database couldnt be created because of existing files, which is the behaviour Id expect.

I dropped the database and went testing the script on a SQL 2000 Server Enterprise Edition which worked as expected, immediately showing up in the TreeView.

As far i remember the 2005 Express Edition can handle databases up to 2GB (or maybe 5GB? Dont remember exactly).

I am having a hard time to figure out what might cause the weird behaviour.

However, heres the system specs of the two 2005 Express installations:

Box#1: Vista RC1

Box#2: XP SP 2

Both running SQL Server 2005 Express Edition SP2, installed on 'C:\Program Files\Microsoft SQL Server', having tons of free disk space and spare resources to handle this CREATE statement and requests.

Any hint that might help solve my issue would be greatly appreciated

Many thanks in advance,

Yours,

trahho.

How are running this script?

When you run the script above, can you immediately run a select * from sys.databases and see if your database is listed.

The DB limit for Express is 4gb so there is not a problem there.