|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Move MS SQL 2005 Express Edition Data Path
Hi!
I just installed Web Developer express edition on my Windows 2000 server machine. I just wanted to know how may I change the default data path of MS SQL Server 2005 express edition. Me If you already installed it, look in this registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\SQLDataRoot Changing this will require a restart of the SQL Server service. HTH, jens Suessmeyer.
Other interesting topics
SQL2K Function Print
cpu up with SQL2005 - higher FullScans/sec, lwr IndexSearches/sec Error inserting into iSeries DB2 table with long name via SQL Server 2000 linked Server BLOBS in a sql server database - yes or no? Connection between two domains query to identify all fields in a table Trying to create a maintenance plan Generate SCRIPT Server: Msg 7399, Level 16, State 1, Line 3 CLR integration & clustering....question |
|||||||||||||||||||||||