Can we store our own objects in master database if yes then what is the best option?

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

Can we store our own objects in master database if yes then what is the best option?
Question Posted on 16 Jul 2022

Home >> DataBase >> sql questions >> Can we store our own objects in master database if yes then what is the best option?

Can we store our own objects in master database if yes then what is the best option?
Our answer is that SQL Server will allow to add objects to master database. But this should happen very rarely. My advice to add storedprocedure like sp_whoisactiveto master database. And other objects should be placed in user database.
Mostly DBAs add different objects like those which support database maintenance to master database. And it would be better to creata a new user database to house those objects. And it is true if there is a log table among objects.

	0
	0


Input Your Comments Or suggestions(If Any)
Name
Email		(optional)
Comments

Other Important Questions

Define N in nvarchar and in nchar?

difference between drop and truncate command

difference between procedure and function

different types of databases in sql

Difference Between Update Lock and Exclusive Lock

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions

PHP | Biztalk | Testing | SAP | HR |

Privacy policy | Terms and Conditions | Blog

If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)