sql express problem, very urgent

忆茹天使

Does not exist, sure!

shadowhele

Mine can, just tested.

Your error message:

You try another path filename='c:\tes.mdf' put it on another disk

seaeva

Maybe the C drive does not have permission to write, change a drive, D drive

use master
go
xp_cmdshell'mkdir d:\project', NO_OUTPUT - create a folder project, xp_cmdshell is a system stored procedure
--Check whether the database exists, if it is true, delete this database -
IF EXISTS(SELECT NAME FROM master.dbo.SYSDATABASES WHERE NAME=N'test')
DROP DATABASE stuDB

GO

--Create database--
CREATE DATABASE test
ON
(NAME=N'stuDB',
FILENAME='d:\project\testDB.mdf',
SIZE=1mb,
MAXSIZE=10mb,
FILEGROWTH=15%)
LOG ON
(NAME=N'stuDB_log',
  FILENAME='d:\project\testDB.ldf',
  SIZE=1mb,
  MAXSIZE=4mb,
  FILEGROWTH=15%)

GO

vgf10002

Will it be a problem with ntfs permissions

忆茹天使

After reading foreign posts,
Just figured it out,
It turned out that the login permissions were wrong
That's what (xqq) said.
thank you all.

zcgood

I also encountered the same situation, but never found the reason. Looking at your post is that the login permissions are wrong. I wonder if I can suggest more details. Just make changes wherever. Thank you!