>When I created a new database on the server, it never prompted me where I wanted it install. How can I change that so it would be under d:\data?
Your question got me thinking about my Vista issues.
SQL server is installed under the Program Files directory, so the database file (*.mdf and *.ldf) are under the the Program Files directory. The database files are modified and this is in "violation" with Vista rules about not modifying files under the Program Files directory. Is that correct?
Should I create the database files under a dirrerent folder?
Thanks,
Einar
Semper ubi sub ubi.