Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
|
Enterprise Manager
|
a.Gives permissions
b.gives group permissions c. run backups d. restore e. register instances f. instances - named instances i.e. server/instance name Larry/curly Larry/Moe (Installation) |
|
|
DTS
|
Data Transformation Wizard
|
|
|
Server Service Manager
|
Used to start, stop, or modify SQL Server services
|
|
|
Command Prompt Utilities
|
OSQL
SCM - Service Manager BCM - Like DTS DTSRun - Runs existing DTS packaging |
|
|
System Databases
|
Master
Temp Model MSDB - used to schedule |
|
|
Where are all temporary tables and stored procedures created by users, as well as temporary worktables used by the relational database engine itself created?
|
Tempdb
|
|
|
Model
|
Serves as a template for new databases
|
|
|
MSDB
|
SQL Server Agent used for scheduling alerts and jobs
|
|
|
Data types
|
Integer
Bit Numeric Money and small money Date time and small date Char/var char |
|
|
Heap
|
The table is not indexed
|
