Hello:

in SQL 2005 SP3 (.4035), I used the Management Studio to access the
properties of the model database. I want to tell the model database
transaction log file to point to a different directory on the server.

But, there was no ellipsis button that I could use to point it. I thought
that there would be.

Anyway, how do I tell the model database to point to another location?

SQL Programmer (it's just a name)

SQL Programmer (SQLProgrammer (AT) discussions (DOT) microsoft.com) writes:
Check out the topic "Moving system databases" in Books Online.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx