logo
Go to the homepage of the Vrije Universiteit. Go to the homepage of the faculty of sciences.

SQL Virus Using Self-Referential Queries for SQL Server


It may be possible to us SQL Server's syscacheobjects view to retrieve the currently running queries. However, this view is primarily a cache, which means that multiple different queries may map onto the same cached object. In this specific case, it seems that similar queries with different WHERE clauses don't add new entries to the cache. As a result of this, we have been unable to create a virus using this functionality.

As of the 2005 version, SQL Server provides the sys.dm_exec_sql_text view, which seems to offer the ability to retrieve the currently running query. However, we have been unable to test this.


Previous SQL Virus Using Self-Referential Queries for MySQL
Up SQL Virus Using Self-Referential Queries
SQL Virus Using Quines Next

Last modified: Thursday, 02 March 2006 21:33, CET
If you spot a mistake, please e-mail the maintainer of this page.
Your browser does not fully support CSS. This may result in visual artifacts.