реферат MS SQL server6.5
MS SQL SERVER 6.5
---?????---
???????? ?? MS SQL Server ?? ???? ?????? ??????? ?????? ??????
?????? ?????? ?????? ????? ?????? ??? ???????? ???? ???
???? ??? ????? ??????. ???? ?? ????? ?????? ?????? ?????.
??? ?? ???????? ???? ???? ???? ????? ?????? ???? ??? ??? ????.
????? ?? ????? ?????? ????? ??????? ?????? ?????, ??????????? ??????
?????? ????.
MS SQL Server 6.5 ??? ?????? ????? ??? ??? ??????? ???? ????.
????? ??? ????.
---???? MS SQL Server 6.5---
MS SQL Server 6.5 ????? ????? ?? ????? ????? Windows NT.
? MS SQL Server ???? ?? ?????, ?? ???? ????????? ???? ??????? ???,
????, ???? ????? ??? ????? ?? ???? ????? MS SQL Server ??????
????? ????. ??? ????? ??? ???? ?????? ?? ?? ??? ????? ??
WindowsNT (???? ????? ?? Intel, Alpha, MIPS,PowerPC).
???? ????? Windows NT ???? ? MS SQL Server ????? ???????????
TCP/IP, NWLink IPX/SPX, Named Pipes (NetBEUI), Banian Vines,
AppleTalk (ADSP), DECNet.
????? 6.5 ?????? ??? ????? ??? ????? – multiprotocol network
library ?????? "?????? " TCP IP Ports,SPX, ?named Pipes ??????? ????
??? ????? ??????.
?????? ????? ?? multiprotocol ??? ??? ?? ????? ?????
?????? ????? ??? ??????? ????? ???????? ??????? ????? ???????? ????,
???? - ?????? ?????? ???? ????? ?????.
---?????---
????? ?? ???? ????????? ?? ?????? ????? ????? ?? Windows NT ???????
????? ????? ? MS SQL Server ???? ????? ?????? OLTP ?DSS.
?? ????? ?????? ?????? ?? ????? ?? ??? ???? ???????. ???????
???????? ???? ? MS SQL Server ???? ????? ????? ?? 3500 ???????
??????? ?? ?????.
???? ??? ??? 10.95-12.96 ????? ?? MS SQL Server ????? ??? ????? ??
TPC-C, ???? ?2454 ?? 7521 ????????? ????, ??? ????? ???? ??? 3.
????? ?????? , ???? ?? ???? ???? ?? ????????? ??????
VISA ????? ?10 ??40 ?????? ?MS SQL Server ?? 7500 ????????? ????
????? ??? ???? ?11 ?????? ????????? ?24 ????.
---???????? ?? ???? ????????----
?????? ?? MS SQL Server ????? SQLMail Utility ??????? ?????? ?????
?? Microsoft Exchange Server ????? ????? ????? ?????? ??? ?????????
?????? ???????? ?????? ????????? MAPI . ?????????? ??? ??????
xp_startmail ? xp_stopmail ????? ????? ?????? SQLMail , xp_sendmail
?????? ??????,xp_findnextmsg ?????? ????? ???? ????? ????????,
xp_readmail ?????? ?????? ??????, xp_deletemail ??????. ?? ???
?????? ?????? sqlmap60.dll ??????? ???? ????????? ?? Transact SQL,
????????? ??????, Triggers ??”?.
---????? ?????---
???? ?? ???? ??? ???? ????? ???? ???????? ?? ????, ??? ??????? ??????
????? ?????? ??????? ????? ???? on-line. MS SQL Server ???? ??????
?????? ??????, ??? ????? ????? ???? ???????? ?????? ?????? ?????????
?"? ???????.
???? ????? ??????, ????? ???? ??"? ?????? ?????? ??????? ????? ?? ??
????? ??????? ?? ???? ????? ????? ??? ??????? ?? ???? ??????
??????. ?? ?????????? ???????? ?????? ???? ????????? ????? ??????,
????????? ??? ???????, ??? ????? ??? ???? ?????? ???? ????? ?????? –
?????? ???? ??????????.
---????? ????---
MS SQL Server ???? ????? ?? ????? ???? ???? ????.
?????? ?????? ?????? ?? ????? ?????? ??? ?? ??? ?????
(????? ?login name) ??????? ?????????? ????? ?????? ????? ??????.
???? ?? ???? ?????? ?? ????? ????? ???? ???? ???? ?? ?????
(user name) ??????? ????? ?????????? ?????.
????? ?????? ????? ??? Login id ????? ?????? ????? ??????, ???
????? ??????? ??????? ??????? ????? ?????? ?????? ?????.
????? ????? ?? ??????? ????? ???? ??? ?SQL Enterprise Manager.
?????? ????? ?????? ?????? ???? ????? ?? SQL – DMO.
??--????---
??? ????? ?????? MS SQL Server ??? ?? ?????? ?? ????? ????? ?????
?????????? ??? ??????. ?????? ??? ?????? ????? ????? ?????? ???? ?????
??????? ?? ???????? ?????? ???????.
MS SQL Server 6.5 ?????? ??? ????? ?????????? ?? ?????
????? ?? MS BackOffice ?? ?????? ????? ????? ?????????? ?? ?????
?????? ????, ???? ????????, ???? ?? internet/itranet ????????? ??"?.
MS SQL Server ???? ??????? ????-??? ??????? ??? ??????? ??
??????. ??? ????? ??????? ?????? ????????? ??????? ???? ?????
? - Microsoft Transaction Server.