← Back to Knowledge Base

KB #240094: How to capture output of sp_n_enumfiles into a table

⏱️ 1 min read
 

Type:

Information
Summary:
API sp_n_enumfiles gives a report of encrypted database files currently attached to SQL Server. This KB Article gives instructions on how to capture the result set into a table.

 

Additional Information:
The following example puts the result set of sp_n_enumfiles into a temporary table named #dbfiles and checks to see if any files containing the name ‘northwind’ are included

Create Table #dbfiles(dbfile varchar(128))
Insert #dbfiles EXEC sp_n_enumfiles
select dbfile from #dbfiles
IF EXISTS (SELECT dbfile FROM #dbfiles WHERE dbfile like '%northwind%') begin
  select 'northwind found'
end
drop table #dbfiles

Was this article helpful?

Related Articles

KB #240056: Encrypt/Decrypt Wizard: Error – could not access file

Type: Tip Summary: The Encryptionizer Encrypt/Decrypt Wizard must have access to a file to be…

KB #240084: SQL will not start. The System cannot find the file specified

Type Information Summary: SQL Server does not start and the System Event log has an…

KB #240091: NLCBTASK Service fails to start with error “The system cannot find the file specified”

Type: Fix Summary: The installer added the ImagePath for the NLCBTASK Service without surrounding quotes. This…

Still need help?

Our support team is here to assist you.

NetLib Security
AI Assistant · Online
Hi! I'm the NetLib Security assistant. I can answer questions about our encryption solutions, HIPAA compliance, Encryptionizer, and more. How can I help you today?