أستغفر الله العظيم ... سبحان الله وبحمده



العودة   منتديات داماس > برامج الكمبيوتر والانترنت > برامج


مواضيع مميزة  


آخر عشرة مواضيع المواضيع النشطة


29-11-2005, 04:42 PM
eXpert غير متصل
عضوية الشرف
رقم العضوية: 17239
تاريخ التسجيل: Jan 2005
الإقامة: Sweden
المشاركات: 4,130
إعجاب: 379
تلقى 494 إعجاب على 106 مشاركة
تلقى دعوات الى: 0 موضوع
    #1  

Microsoft SQL Server 2000 4 IN 1


Micr050ft SQL Server 2000 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. In this article, we'll cover six of the more frequently used tools: Enterprise Manager, Query Analyzer, SQL Profiler, Service Manager, Data Transformation Services and Books Online. Let's take a brief look at each:

Enterprise Manager is the main administrative console for SQL Server installations. It provides you with a graphical "birds-eye" view of all of the SQL Server installations on your network. You can perform high-level administrative functions that affect one or more servers, schedule common maintenance tasks or create and modify the structure of individual databases.
Query Analyzer offers a quick and dirty method for performing queries against any of your SQL Server databases.
Sponsored Links

SQL Profiler provides a window into the inner workings of your database. You can monitor many different event types and observe database performance in real time. SQL Profiler allows you to capture and replay system "traces" that log various activities. It's a great tool for optimizing databases with performance issues or troubleshooting particular problems.

Service Manager is used to control the MSSQLServer (the main SQL Server process), MSDTC (Micr050ft Distributed Transaction Coordinator) and SQLServerAgent processes. An icon for this service normally resides in the system tray of machines running SQL Server. You can use Service Manager to start, stop or pause any one of these services.

Data Transformation Services (DTS) provide an extremely flexible method for importing and exporting data between a Micr050ft SQL Server installation and a large variety of other formats. The most commonly used DTS application is the "Import and Export Data" wizard found in the SQL Server program group.

Books Online is an often overlooked resource provided with SQL Server that contains answers to a variety of administrative, development and installation issues. It's a great resource to consult before turning to the Internet or technical support.

Hopefully, this article has provided you with a brief introduction to the various tools available to Micr050ft SQL Server users. Now get out there and give them a whirl!




http://dl.njfiw.gov.cn/softwares/%b7...0IN%201%20.ISO

الموضوع: Microsoft SQL Server 2000 4 IN 1 بقسم برامج




المواضيع المشابهه
الموضوع كاتب الموضوع المنتدى مشاركات آخر مشاركة
Microsoft SQL Server 2005,2000 djsharawy برامج 0 31-05-2008 08:06 PM
Microsoft SQL Server 2000 djsharawy برامج 0 29-05-2008 03:03 PM
Microsoft multilanguage pack for 2000, xp and 2003 server rawhi 019 برامج 23 30-07-2007 06:40 PM
Microsoft SQL server 2000 سعد الدين إدارة الشبكات و حلول ومشاكل الشبكات 3 06-07-2004 09:05 PM
سؤال حول Microsoft Exchange Server 2000 مغروم برامج 0 25-03-2004 05:03 PM
29-11-2005, 05:12 PM
reda ghonim غير متصل
عضو مميز
رقم العضوية: 19796
تاريخ التسجيل: Apr 2005
المشاركات: 321
إعجاب: 3
تلقى إعجاب 1 على مشاركة واحدة
تلقى دعوات الى: 0 موضوع
    #2  
thanks man


 


Microsoft SQL Server 2000 4 IN 1

English

Powered by vBulletin® Version
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
The owner and operator of the site is not responsible for the availability of, or any content provided.
Topics that are written in the site reflect the opinion of the author.
جميع ما يُطرح من مواضيع ومشاركات تعبر عن رأي كاتبها ولا تعبر عن رأي مالك الموقع أو الإدارة بأي حال من الأحوال.