CODEWITHSUNDEEP
sqlsql-servert-sqldatabase-administration
pritamS
pritamS

Reputation: 137

User accessing database files in SQL Server

Is it possible in SQL Server to find which users writing data in database files? For example: there are two users SA and microsoft\thomas on an instance. ABC database is accessed by both the users and it has three files ABC1.mdf , ABC2.ndf and ABC3.ldf . Can we find who is writing how much data on which files?

I need to to track users writing heavily on the databases as the disks become full because of them.

Upvotes: 1

Views: 62

Answers (1)

pritamS
pritamS

Reputation: 137

So i think its not possible to track which user writing how much data and on which data files.

Upvotes: 1

Related Questions