PrepAway - Latest Free Exam Questions & Answers

Tag: query the name column in the sys master_files catalog view

Which Transact-SQL statement should you execute?

You have been hired as the database administrator of your company. You are responsible for managing aninstance of SQL Server 2008 that contains a database named
Corpdb . There are several database snapshots created for the Corpdb database. You want to identify the names of thesparse files that are created for the Corpdb
database. Which Transact-SQL statement should you execute?