Month: September 2014

Find all tables containing column with a certain name

Published by xavier on September 29, 2014

SELECT c.name AS ColName, t.name AS TableName
FROM sys.columns c
    JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%LookingForThisColumn%'

Cisco SPA303 – Dial Plan

Published by xavier on September 7, 2014

I’m new to the SPA303 phone. I had trouble figuring out how to set it up so I don’t have to dial the area code for a phone number within the same area code. Below is an example I found.

 Original string:

(*xx|[3469]11|0|00|[2-9]xxxxxx|1xxx[2-9]xxxxxxS0|xxxxxxxxxxxx.)

 Modified string: (lets assume my area code is 999)

(*xx|[3469]11|0|00|<:1999>[2-9]xxxxxx|1xxx[2-9]xxxxxxS0|xxxxxxxxxxxx.)