May 2010
Intermediate to advanced
815 pages
21h 55m
English
book
SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond
by Tom Carpenter
Content preview from SQL Server® 2008 Administration: Real World Skills for MCITP Certification and BeyondBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter Essentials
Introducing the Command Prompt The Windows command prompt is a valuable tool for administration, troubleshooting, and automation. The most efficient Windows administrators know the command-prompt interface well.
General Commands In order to use the command prompt, you must have several commands memorized and mastered. These commands include DIR, CD, COPY, ROBOCOPY, CLS, ECHO, and TYPE, among others.
Batch Files When you want to automate mundane or routing tasks, batch files are frequently an excellent solution. With batch files, you can make decisions, execute dozens or hundreds of commands, and quickly modify them without any requirements for compilation.
Mastering SQLCMD With the command prompt's fundamentals under your belt, ...