SQL Server

• Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication

Run a command on each table in a database

Use the sp_msforeachtable undocumented system stored proc, for example:

sp_msforeachTable @command1='select count(*) NR from ? where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''