Программирование и комп-ры : MS SQL server6.5

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.