Thanks for looking in to my question.
I have a SQL Server 2008R2 dev environment. I have set the default data and log files path to some other drives other than C: drive.
But when users create databases on the instance, they create it on the C: drive, which is causing the C: drive to run out of space.
Any idea how can I prevent this..?
I tried policy based management, but "on change prevent" is not available for datafile.