What is the basic functions for master, msdb, model, tempdb databases? | SansSQL

Thursday, June 12, 2008

What is the basic functions for master, msdb, model, tempdb databases?

The Master database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care.
The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.
The tempdb holds temporary objects such as global and local temporary tables and stored procedures.
The model is essentially a template database used in the creation of any new user database created in the instance.

80 comments:

Anonymous said...

hi sandesh,
i m dwarkesh...i develope one project in asp.net with c# and i need to create database for contact us form which used 4 text box and 1 button .

but i m new to sql server so i don't know how to whole process work .
plz give me info' to this mail id d4deks@gmail.com

Sandesh Segu said...

Hi Dwarkesh,
To create a database in sql 2000, follow the below steps,
1.Go to all programs
2.Microsoft SQL server
3.Enterprise Manager
4.Expand "Microsoft SQL Servers"
5.Expand "SQL Server Group"
6.Expand "(local)" (if it is the default instance in that server)
7.Expand "Databases"
8.Right-click on the databases and select "New Database"
9.Give the name of the database
10. Click OK
11.check for the newly created database in the databases folder.

latesttechnologyblogs said...

Really good information to show through this blog. I really appreciate you for all the valuable information that you are providing us through your blog. SQL server dba Online Course

mary Brown said...

A IEEE project Domain is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project DOmains Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project domains for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities in their respective domains.


Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

tike mik said...

One more disadvantages start with the trip to the casino. Depending on where you live, you might have to drive for several hours, or fly, just to get there., on the other hand, When you choose an online casino, you remain in control.

sbobet88 mobile

tike mik said...

Under these circumstances, coaches and teachers (and parents if possible) have a very important responsibility to ensure that our athletes are well prepared for competition. dart bord

Huongkvb said...

Aivivu chuyên vé máy bay, tham khảo

vé máy bay đi Mỹ

vé máy bay từ los angeles về việt nam

giá vé máy bay từ canada về Việt Nam

nhật về việt nam

mua ve may bay tu han quoc ve viet nam

Vé máy bay từ Đài Loan về VN

chi phí vé máy bay cho chuyên gia nước ngoài

Tam Richard said...

Thank you for helping people get the information they need. Great stuff as usual. Keep up the great work!!!
แทงSicboonline

charissa said...

It's the most exciting article. i thank you for sharing รีวิวเกมสล็อตReel love

charissa said...

"Is the best article I appreciate you sharing this much useful information.
รีวิวRed Tiger
เล่นสล็อตเวลาไหนดี"

Luckyslot said...

Thanks for another great article. ทางเข้าเล่นสล็อตออนไลน์

Luckyslot said...

This is a good article. I read it many times คาสิโนออนไลน์ Ufa800

charissa said...

"Thank you for sharing your knowledge. and new things to study รีวิวค่ายสล็อต
Red Tiger"

charissa said...

well written article that is easy to understand. <a href=" https://ppanther581701.wixsite.com/slot2online/%E0%B8%A7-%E0%B8%98-%E0%B9%80%E0%B8%AD%E0%B8%B2%E0%B8%8A%E0%B8%99%E0%B8%B0%E0%B9%80%E0%B8%81%E0%B8%A1%E0%B8%A2-%E0%B8%87%E0%B8%9B%E0%B8%A5%E0%B8%B2%E0%B9%81%E0%B8%9A%E0%B8%9A%E0%B9%80%E0%B8%8B-%E0%B8%A2%E0%B8%99 >วิธีเล่นเกมยิงปลา</a>

Long Night said...

I want to read more of your good articles. Well done.
เกมขึ้นยานค่ายไหนดี

gaco88 home said...

main di sini aja Gaco88

game paling gacor Gaco88

saya mengajak anda di Gaco88

melakukan Login di Gaco88

jangan lupa online di Gaco88

Long Night said...

Good article good job thanks เกมยิงปลาออนไลน์

Duke221 said...

Thank you for liking, press share
I exactly got what you mean, thanks for posting. And, I am too much happy to find this website on the world of Google
สมัคร sa gaming
sa casino online

Duke221 said...

สมัคร sa gaming
sa casino online
I am thankful to you for sharing this plethora of useful information. I found this resource utmost beneficial for me. Thanks a lot for hard work.

Duke221 said...

Good advice. Thank you for the advice.
สมัคร sa gaming
sa casino online

Comfortreview said...

Thank you for writing this blog. แทงบาคาร่า10บาท

Duke221 said...

Good advice. Thank you for the advice. เดิมพันsagaming

Unknown said...

your article is very good Can you give me some advice on my writing method เกมสล็อตออนไลน์มาแรงที่สุด

Little Planet said...

Thank you for recommending a good thread.
ทำเงินด้วยสล็อตDragon Tiger Luck

Unknown said...

your article is very good Can you give me some advice on my writing method รีวิวสล็อตออนไลน์

Unknown said...

your article is very good Can you give me some advice on my writing method รีวิวเกมสล็อตออนไลน์น่าเล่น

Comfortreview said...

I think it's a good blog. Thank you. SA Gamingฝากถอนไม่มีขั้นต่ำ

Comfortreview said...

Nice content. Thank you. SA Gamingทดลองเล่น

Kennocha said...

I was reading your article and wondered if you had considered creating an ebook on this subject. Your writing would sell it fast. You have a lot of writing talent.เว็บพนันSA Gaming

Kennocha said...

Thank you for liking, press share
I exactly got what you mean, thanks for posting. And, I am too much happy to find this website on the world of Google SA GAMINGเว็บไหนดี

Comfortreview said...

Nice content. Thanks. ทดลองเล่นไฮโลไทย

Unknown said...

your article is very good Can you give me some advice on my writing method รีวิวเกมสล็อตมาแรง

Kennocha said...

ค่ายjoker Thanks for the blog filled with so many information. Stopping by your blog helped me to get what I was looking for. Now my task has become as easy as ABC.

Kennocha said...

Thanks for the blog filled with so many information. Stopping by your blog helped me to get what I was looking for. Now my task has become as easy as ABC. แทงบาคาร่าออนไลน์

Comfortreview said...

Great content. Thank you so much. เกมยิงปลาออนไลน์

Clear sky said...

The article was very useful to me, Thank You.
เว็บสล็อตแตกง่าย 2022

Comfortreview said...

Nice advice. Thank you for this blog. แทงบาคาร่าออนไลน์

Reviewgame said...

i like this blog And I want my friends to see สล็อตค่าย joker

Kennocha said...

เล่นพนันเกมยิงปลา Thank you for liking, press share
I exactly got what you mean, thanks for posting. And, I am too much happy to find this website on the world of Google

Amando said...

The blog written is extremely impressive, with a great topic. เว็บเกมขึ้นยานเครดิตฟรี

Amando said...

Thank you for recommending a good thread. เว็บเกมขึ้นยานเครดิตฟรี

Comfortreview said...

Awesome content. Thank you. เว็บพนันบอลออนไลน์ดีที่สุด

Oki said...

your website is very amazing ! เว็บผลบอลสด And this one too. เว็บข่าวบอลวันนี้

Lastone12341 said...

Good advice. Thank you for the advice.
สมัคร SA Gaming

แทงบอลสด said...

Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog
สล็อตยูฟ่า777

tanapol said...

Thank you for liking, press share
I exactly got what you mean thanks for 7M

tee said...

Let's meet some good things about sports. ผลบอลสด365 แจกฟรีทีเด็ดบอล

Cannon said...

I gained knowledge from your article, Thank youทีเด็ดบอลล่าสุด ผลการแข่งขัน

แทงบอลสด said...

Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog
รีวิวคาสิโนสดufabet

Cannon said...

I feel so good with your topic, Thank you.ผลบอลสด365 ผลบอลย้อนหลัง

Kennocha said...

เว็บบอลออนไลน์ I have read it, it feels good and it is very useful to me.

Cannon said...

I gained knowledge from your article, Thank youอัพเดตผลบอล ทีเด็ดฟุตบอลคืนนี้ล

tanapol said...

Thank you for visiting the comments Please continue to comment 7mผลบอลสด

Cannon said...

I feel so good with your article, Thank you.ทีเด็ดบอลวันนี้ ผลบอลเมื่อวาน

phkhnsmburn said...

That's good news, I've been following for a long time.ทรรศนะบอลคืนนี้ I am always searching online for storys that can accommodate me ทีเด็ดบอลเต็ง

phkhnsmburn said...

It's good news that I've been following all the time.อ่านข่าวแมนยู I am always searching online for storys that can accommodate me ข่าวแมนยู

Lasttwo232 said...

A very useful for this article. เว็บสล็อตแตกง่าย

wanon said...

Wohh just what I was looking for, regards for posting.
สล็อตออนไลน์

pgSlot365x said...

Photos available on your site even though producing attention rapidly some quantity submits. รีวิวPG SLOTเปิดใหม่

tee said...

It's very knowledgeable Thank you for the comm. ทีเด็ดบอลสูง-ต่ำ ผลบอลย้อนหลัง

ball said...

ลิเวอร์พูลIt is extremely helpful for me.ข่าวหงส์แดง

UnoGeeks said...

Thank you for sharing such a nice and interesting blog and really very helpful article. If you want to become Oracle Fusion SCM Certified Consultant, attend this Best Oracle SCM Training Course offered by the Unogeeks

pgSlot365x said...

Wohh just what I was looking for, regards for posting.

แทงบอลออนไลน์บนมือถือ

pgSlot365x said...

I conceive you have noted some very interesting points, regards for the post. Pgslot365x.com

ball said...

ไฮไลท์ลิเวอร์พูลล่าสุดIt is extremely helpful for me.ไฮไลท์ลิเวอร์พูล

pgSlot365x said...

Thank you for visiting the comments Please continue to comment


เว็บแทงบอลสเต็ปมาแรง2022

wanon said...

Wow, I'm so excited to come across this information
SA GAMING CASINO

pgSlot365x said...

Photos available on your site even though producing attention rapidly some quantity submits.
เว็บเล่นสล็อตPG

tanapol said...

Thank you for liking, press share I exactly got what you mean thanks I am too much happy to find this website on the world
ข่าวฟุตบอลต่างประเทศ
ข่าวฟุตบอล

Reviewgame said...

I love reading old articles, especially this one เดิมพันบาคาร่าออนไลน์

usop said...

It is tthe little changes that will make the greatest changes. Thanks a lot for sharing!
ข่าวฟุตบอลต่างประเทศ
ข่าวฟุตบอล

pup said...

ข่าวฟุตบอล I am always searching online for storys that can accommodate me ข่าวฟุตบอลต่างประเทศ

pgSlot365x said...

Thank you for recommending a good thread.
เว็บPG SLOT365X

pgSlot365x said...

Why visitors still use to read news papers when in this technological world all is accessible on net?

คาสิโนUFABET

nuggetgoal said...

After I read it It made me get to know many stories that happened. I think you for such a great article. ทีเด็ดฟุตบอล ทีเด็ดฟุตบอลออนไลน์

pgSlot365x said...

Wohh just what I was looking for, regards for posting.

เว็บแทงบอลออนไลน์

pgSlot365x said...

Wohh just what I was looking for, regards for posting.


เดิมพันเกมสล็อตเว็บตรง

pgSlot365x said...

Wohh just what I was looking for, regards for posting.


รวมค่ายเกมสล็อต

Kennocha said...

This is a good article. I read it many times บาคาร่ายูฟ่าเว็บไหนดี

Kennocha said...

This is a good article. I read it many times บาคาร่ายูฟ่าเว็บไหนดี

Post a Comment

Ads