What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  


How would you add a section to a table?

0 Answers  


Which is better statement or preparedstatement?

0 Answers  


What do you understand by physical_only option in dbcc checkdb?

0 Answers  


What is a coalesce function?

0 Answers  






How can I check if a view exists in a sql server database?

0 Answers  


what is differece between union and union all

6 Answers  


How do I start and stop sql server?

0 Answers  


How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,


How to create a simple user defined function in ms sql server?

0 Answers  


Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,


Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  


Categories