SQL SERVER 2005
MS SQL SERVER is a database
management system developed and marketed by Microsoft. The SQL SERVER database
system was originally developed and implemented by Sybase Inc. Microsoft
licensed this DBMS in 1988 for OS/2 operating system and began implementing it
for Windows operating system in the early 1990s. At almost the same time, the
further development of SQL SERVER for OS/2 was canceled.
In April 1994, Microsoft ended
their cooperative agreement with Sybase Inc.
MS SQL SERVER runs exclusively
under Microsoft operating systems windows 2000, 2003 Server and XP.
SQL SERVER was, from the
beginning, designed as a client/server DBMS. The Client/Server architecture has
been developed to manage a large number of different computers, which are
connected using a network. The functionality of SQL Server is divided between
clients and server. A client provides one or more different requests to Server.
The Server processes this request and sends the result back to the client.
Versions SQL SERVER
1. SQL Server 4.0
2. SQL Server 4.2
3. SQL Server 6.0
4. SQL Server 6.5
5. SQL Server 7.0
6. SQL Server 8.0 or SQL Server
2000
7. SQL Server 9.0 or SQL Server
2005
8. SQL Server 10.0 or SQL Server
2008
Editions of SQL Server
- Standard Edition
- Developer Edition
- Workgroup Edition
- Mobile Edition or Compact Edition
- Express Edition (Free Edition we can download it from www.microsoft.com)
SQL Server Enterprise
SQL Server
Standard Edition. This edition is the affordable option for small- and
medium-sized organizations that do not require advanced scalability and
availability features or all of the more advanced analysis features of the SQL
Server 2000 Enterprise Edition. You can use the Standard Edition on symmetric
multi-processing systems with up to four CPUs and 2 GB of RAM.
¡ SQL Server
Expess Edition. This edition includes a full set of management tools
and most of the functionality of the Standard Edition, but it is optimized for
personal use. In addition to running on Microsoft’s server operating systems,
the Personal Edition runs on non-server operating systems, including Windows
2000 Professional, Windows NT Workstation 4.0, and Windows 98. Dual-processor
systems are also supported. While this edition supports databases of any size,
its performance is optimized for single users and small workgroups and degrades
with workloads generated by more than five concurrent users.
¡ SQL Server Developer Edition. This SQL Server
offering enables developers to build any type of application on top of SQL
Server. This edition includes all of the functionality of the Enterprise
Edition but with a special development and test end-user license agreement
(EULA) that prohibits production deployment.
¡ SQL Server
Desktop Engine (MSDE). This edition has the basic database engine
features of SQL Server 2000. This edition does not include a user interface,
management tools, analysis capabilities, merge replication support, client
access licenses, developer libraries, or Books Online. This edition also limits
the database size and user workload. Desktop Engine has the smallest footprint
of any edition of SQL Server 2000 and is thus an ideal embedded or offline data
store.
¡ SQL Server
Windows CE Edition. This edition is the version of SQL Server 2000
for devices and appliances running Windows CE. This edition is programmatically
compatible with the other editions of SQL Server 2000, so developers can
leverage their existing skills and applications to extend the power of a
relational data store to solutions running on new classes of devices.
FEATURES
OF SQL SERVER:
1.
Security: Provides login and password to interact with
data in database
2.
Data Redundancy: Less Data reputation
3.
Data Integrity: Data validation/Data Checking Process
facility
4.
Backup and Recovery(Restore)
5.
Introducing support for XML
6.
User defined function are introduced.
7.
OLAP (online analytical process) services available in
SQL server 7.0 are now called as SQL server 2005 analysis services
8.
Repository components available in SQL server now
called Meta data services.
Requirements To
Install SQL Server 2005 in your work station
- Operating
System: Windows Xp, Windows 2000/NT/Professional,
- Primary Memory: 512 MB Ram or above
- Secondary memory: 1GB or above
- Processor: 500 Mhz or above
- Internet explorer: 5.0 or above
- Windows Installer 3.1
- .Net Framework 2.o
SP_HELPTEXT ‘T1’
DDL TRIGGERS (2005 Triggers):
These triggers are fired when user performs DDL operations in
the database and these triggers belong to database. It means we can define triggers on the current
database.
Syntax:
CREATE TRIGGER TRIGGERNAME ON DATABASE
FOR/ AFTER {DROP,/ALTER/ CREATE}
AS
BEGIN
SQL STATEMENT.
END
E.g.:
USE PUBS
CREATE TRIGGER DROP_TRG ON DATABASE FOR DROP-TABLE
AS
BEGIN
PRINT ‘TABLE DROPPED’
ROLLBACK
END
E.g.:
USE PUBS
CREATE TRIGGER DROP_TRG ON DATABASE INSTEAD OF DROP-TABLE
AS
BEGIN
PRINT ‘U CANNOT DROP THE TABLE’
ROLLBACK
END
No comments:
Post a Comment