Archive for the ‘Toolbox’ Category
Site Folder Permission and App Pool Setting for test development sites in IIS 7.5
Leave a commentFolder Permissions for the root folder of the site:
- IUSR (Read, Execute)
- IIS AppPool\<Application Pool Name>(Read, Execute)
In IIS > App Pool > Advanced Settings:
- If using MVC – .Net CLR Version = v4.0
- Load User Profile – False
SQL Server – Finding tables for column name
Needed to know which tables in the database I was working on had any FK columns I needed to consider. Here is a nice query to help.
USE [database-name]
GO
SELECT
t.name AS Table_Name,
SCHEMA_NAME(schema_id) AS Schema_Name,
c.name AS Column_Name
FROM
sys.tables AS t
INNER JOIN sys.columns c
ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%Service%'
ORDER BY Schema_Name, Table_Name;
JavaScriptShadow 