I am creating a web site portal which pulls data from tables in SQL Server. Only 5-6 tables are required to be created. Can we create those tables in a master database of SQL Server or should i create a separate database. Because i heard that using master database might for such purposes may pose problems.
Kindly help me in this.
Thanks in advance.
Create your own database and maintain it seperately. The master database is a system database maintained by Microsoft and subject to change as service packs and bug fixes come out. You should not place your own critical information inside that database or you could come into a situation where you could lose it.
Also, giving people access to the master database could give them access to certain controls on your server, again, a dangerous thing to do.
By and large you should not mess with msdb, tempdb or the master database. You should get backups in place for msdb and master. You can manipulate the model database, by design. Changes to it, objects placed inside of it, automatically are created when you create a new database.
answered Jun 22, 2010 at 08:36 AM
Grant Fritchey ♦♦