I have a question... I've changed the script to use C:\ for both files as follows:

Create Database Mytestdb

on

( name ='Mytest_1', Filename= 'C:\MyTEST.mp3', size = 2000 KB

)log on(

name ='MyTest_2', Filename= 'C:\MYTEST.doc', size= 512 kb)

and get the following error:

Msg 5123, Level 16, State 1, Line 1

CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\MyTEST.mp3'.

Msg 1802, Level 16, State 4, Line 1

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

I am administrator of my machine and the DB is installed locally and I'm sysadmin....

When I change the files to C:\temp\filenames... (with temp folder being existant)... it works!!! :ermm:

Can someone explain if this behavior is normal?? I'm suspecting that it's some type of setting on my account... :doze: