Question: Still stuck on this please help. Hide Assignment Information Instructions Transaction Log Exercise Instructions: 1. Create a new database called TransLogDb 2. Create a table

Still stuck on this please help.

Hide Assignment Information

Instructions

Transaction Log Exercise

Instructions:

1. Create a new database called TransLogDb

2. Create a table called Students

Add 5 columns

Add 5 records to the table

The table should be well formed with a unique identifier

Each field must be flagged as NULL or NOT NULL in scope

3. Write a SQL script/statement to check the log file for the newly created database to check what processes and steps SQL Server took to create the database and table.

What to Submit - TWO files

a. A single SQL file with ALL queries

b. A Word file with all screenshots of the database, table and records in the table, transaction log result screen

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!