Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SteveH
Starting Member
27 Posts |
 Posted - 2006-02-28 : 14:36:58
|
| I want to install SQL Server so at least the tables are stored on a D: drive rather than the default C: drive. If I can get the whole thing there, it would be best. While installing S.S. the first time, I only came across one place to change a directory. After changing it, tables were still placed on the C: drive.I am working with SQL Server 2005 Standard edition and using default settings, except for the directory of course.Thanks for your help.Steve |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-28 : 14:39:27
|
| You have to do a custom setup if you want the drive to be D when you create your database using Enterprise Manager. But if you used Query Analyzer to create it via CREATE DATABASE command, then you can change the drive letter from code.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Install help for SQL Server 2005 newbie