Microsoft SQL Server 7.0 ?????? ?????? ??????? ????? ??????? ? ???????

?????? ????????? ?????? ?????????
???? ???????: 235214 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ??? ??????? ??? ??????? ????????? ???????? ??? ????? ???????? ???????? ???? Microsoft Press ?????? Microsoft SQL Server 7.0 ?????? ??????? ????? ? ISBN 1-57231-827-9.

??? ????? ???????? ???????:
  • : ???????? ????? ??? ??? Runbcpa.cmd (????? 6)
  • xxx ??????: ??????? "?? ????? StudyNwind ?????"
  • 118 ??????: ????? ????? ??? ?????
  • 126 ??????: ????? ??? ????? RAID And ??????? ?? ??????? ??? ????
  • 162 ??????: ?????? 42 ????? ?????? ???? ??? ???? 38
  • ?????? 302: ???? Sp_addrolemember ??? ????
  • ??????? 354 ?????? 4: 2 ???? 5 ????? ??? ????
  • 474 ??????: ???? ??? ???? ?????? 8

??????? ????

: ???????? ????? ??? ??? Runbcpa.cmd (????? 6)

????? 143 ?????? ???? ??????? ??????? ???????? ???????? ?????? ???????? bcp. ??? ????? ??????? ??? ???? ???????? ???? ???????? ????? ?? ????? ???? ??, ???? ????? ?? ??? Runcpa.cmd (C:\Sqladmin\Exercise\Ch06\Runcpa.cmd) ?? ?? ??????. ??????? ??? "/ e" ? "C:\Sqladmin..." ???? ?? ?? ?????.

?????:
bcp StudyNwind..Products in c:\sqladmin\exercise\ch06\newprods.txt /c /t"," /r\n /ec:\sqladmin\exercise\ch06\newprods.err /b250 /m50 /SSQLSERVER /Usa

???:
bcp StudyNwind..Products in c:\sqladmin\exercise\ch06\newprods.txt /c /t"," /r\n /e c:\sqladmin\exercise\ch06\newprods.err /b250 /m50 /SSQLSERVER /Usa

?????? ???? ??? ??? ?? ????? ??? ??? ????? ?? ????? ?????? ??? "/ SSQLSERVER" ???? ???????? ???????? ??? ?????? ??? ??? ??? ?????? ??? SSQLSERVER.

xxx ??????: ??????? "?? ????? StudyNwind ?????"

??? "xxx ?????? ????????? ?????? ???????? ????? StudyNwind ?? ???? ??? ??? ?? ???? ???? SQL ????? ?????? ??? ???? ????????? ????? ?? ?????? ????? ??????. ?? ???????? ??? ?????? ??????? xix ? ?? ?????? SQL Server ??? 2 ?????.

??????: ???? ????? SQL Server ??? ????? ??? ???? ??? ?? ???? ?? ????????? ???????? ?? ????? ??????? ?????? "???????? ????? StudyNwind ??????".

118 ??????: ????? ????? ??? ?????

??? ?????? 118 ? ??? ?????? "???????? ????????? ?????? ???" ?? ?????? 4 ? 6 ?????? ???? ????? ???????? altering ????? DROP ??????.

?????:
"| DROP FILE logical_file"

"| DROP FILEGROUP filegroup"

???:
"| ?????? FILE logical_file"

"| ?????? FILEGROUP filegroup"

126 ??????: ????? ??? ????? RAID And ??????? ?? ??????? ??? ????

?? ?????? 126 ?? ?????? "??????? ?????? Windows NT Server ?? ???????" ??????? ??? ????? RAID ?? ??????? ?? ????? ??????? ??? ?????.

?????:
"????????? ????? ?????? ????? ?????? ??? ???? ??????? ?? ?????. RAID 0 ???? ?? ??????? ?? ????? ????? ???? RAID 5 ??????? ?? ????? ????."

???:
"RAID 0 ???? ?? ??????? ?? ????? ????? ???? RAID 1 ??????? ?? ????? ????"

162 ??????: ?????? 42 ????? ?????? ???? ??? ???? 38

?? ?????? 162, ?? ??????? ???? ??????? "????? ????? ?? DTS ????" ??????? 38 ? 42 ??????.

??? ????? ?????? 42:
"?? ??????" ?????? ???? "????? ????? ProductsCopy. ?? ?????? ?????? ??? ????. ???? ??? ?? ???? ????? "?????? ??????" ??? ???? ???? ??????? ???? ???????? ??? ?????? ?? Access ??? ???? SQL ????? ?? ?????? ??????. ???? ??? ????? ?????? ???? ?????? "????? ???" ?? ??? ???? ???????? ??? ?????? ?? Access ??? SQL Server."

?????? 302: ???? Sp_addrolemember ??? ????

302 ?????? ? ????? ?????? ?????:
?????:
"sp_addrolemember 'Carl' ? 'db_datareader'"

???:
"sp_addrolemember 'db_datareader' 'Carl'"

??????? 354 ?????? 4: 2 ???? 5 ????? ??? ????

?? ?????? 354, 4 ??????? ??????? ??????? ?? 2 ??? 5 ??????? ???????:

2. ?? ???? ???? ??????? ???? ??? ?????? ?????? ??? ?????? ? ???? ??? ?????. ???? ??? ????? ??????? "??????? ??????" ?? ???? ??? ?????.
3. ?? ??????? ???????? "??? ??????? ???????" ??? ??? ????? SQLServerAgent.
4. ???? ??? ??????.
???? ????? ???? ???? ????????. ???? ??? "?????" ?????? ???????.
5. ???? ??? ????? ?????? ???? ?????? ????? ???? SQL.
???? ????? ????? ??? ??? ??? ???? ????? ????? SQL Server ???? ??? ????????? ???? ??????? ????? ???????. ???? ??? "???". ???? ??? "?????" ??? ????? ????? ??????.

474 ??????: ???? ??? ???? ?????? 8

?? ?????? 474 ????? ??????? ?? ?????? 8 ?????? ?? ?????? ReplProducts.

??? ????? ????:
	USE PullSubs
	SELECT * FROM ReplProducts WHERE ProductID = 1
				

????? Microsoft Press ??? ????? ????? ??? ??????? ??????. ???? ????????? ?????????? ????????? ???????? ????? ?????? ???????? ?? printings ?????????? ?? ??? ??????. ??? ??? ???? ????? ???? ?? ??? ?????? ?? ????? ?????? ??? ???? ?? ???? ????????? ?????.

???????

???? ???????: 235214 - ????? ??? ??????: 21/???? ??????/1435 - ??????: 1.1
????? ???
  • MSPRESS Microsoft SQL Server 7.0 System Administration Training Kit ISBN 1-57231-827-9
????? ??????: 
kbnosurvey kbarchive kbmt kbdocerr kbdocfix kbinfo KB235214 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????235214

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com