Databases
Not what you're looking for?
As a team you will be responsible for completing the following actions:
Part 1
Create a role for a user to complete imports and exports of data. This role should be a user-defined role with the minimum appropriate permissions for a user who would complete imports and exports. Take screen shots of the critical role creation steps and provide a 1 - 2 paragraph explanation of your choices.
Create a user for the role. Again provide screen shots of the critical user creation steps with any necessary explanation.
Part 2
Study this text file's data and create a table in your database the data can be stored in. You can use the database you created in the previous learning event. You don't need to show the table creation steps, but do provide a screen shot of the table properties once it's been created.
Use the DTS utility to Import the data from the text file into your SQL Server database. Show screen shots of the import steps and provide a screen shot of the table rows in the Enterprise Manager once the data is imported.
Export that table to Excel using DTS. Provide screen shots of the various wizard screens and explanations of your choices. If the export doesn't work at first, be sure to document the error message. When the Excel file is created successfully, submit it along with your Word document.
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Javscript Basics
Quiz on basics of javascript programming language.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.