I have changed the Default Database locations AFTER installation of SQL server. If i create a db in the UI it uses the new locations yet if I run a simple script "Create database TEST1" it uses the old locations. I restarted the SQL service and created TEST2 and it used the NEW locations. My question is, is there a way to update the SQL engine to use the new locations without restarting the service?
"I'm still learning the things i thought i knew!"