April 15, 2009 at 11:45 am
I took a drive off from my sql server machine where it use to point all database files for default database created. Now when i create new database from a script it still points to the old drive which i removed and gives me an error. It works Ok when i run it from SSMS but fails when database is created from a proc.
April 15, 2009 at 11:58 am
Did you update the model DB settings?
April 15, 2009 at 12:03 pm
I dont think database file location will be taken from model, its a server level setting.
anywyas my model database points c drive where sql server is installed.
April 15, 2009 at 12:08 pm
Oh Okay i see now.
April 15, 2009 at 12:16 pm
I did some more digging and found this article: http://www.dbforums.com/microsoft-sql-server/1609971-changing-default-location-new-database.html
Perhaps that is what you are looking for.
April 15, 2009 at 2:52 pm
I'm pretty sure you can change it in management studio by right clicking the server ---> select Properties --->select database settings
You then can select your database default locations.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply