your original six part WHERE finds everything that is "OK", ie does not match the double spaced indexes.

this might work as w to find your exceptions and outliers:

select p_code

from Postcode

where...

i only see some minor suggestions so far, still reading, but it looks fine to me.

my permissions concert is alleviated by the EXECUTE AS statement.

Besides TCP that you are testing...

i think you can just search for double spaces, and not whether they follow the rest/standard formatting for like rules right?

if double spaces are not allowed, you could just replace...

i would lean more towards a logic error in the trigger.

the login trigger clearly rejected the login, but that might be because the login user does not have read permissions...

I've found the best way to resolve this issue is to sync the sids.

SQL users generate a unique Id that is different on each login...so My login[Bob] is not the...

Sql audit can track who made changes in general, and when, but to the best of my knowledge cannot say what row changed, but not whether your statusflag column was...

i think for whodunnit information, a trigger is going to be the best, followed by a SQL Audit(which uses Extended events anyway...so it's a pre-built tool that writes to the...

here's something i recently built to move specific clustered indexes to a new filegroup, and also enable page compression on some specific tables;

you'll see some commented artifacts referencing a table...

sure; there's a system view named sys.database_permissions.

this will give you users and groups that have the permission you are looking for...but you might need to expand group members if you...

DouglasH (5/25/2016)

---

You'll have to access the Extended File Properties of the file but I don't think you can do it with TSQL. The Extended Properties vary according to the...

In my case, i was bitten by the 2./3.0 when i wax using Export-Csv i think, which added -Appen parameter.

I ended up using a command line call to the...

can you run $PSVersionTable?

i'm thinking the script is for Powershell 3.0, but it's running under 2.0 context?

the third error i would think can occur if the string $DestinationFile has...

in that case, your count, as you currently have it, would always be one, since the WHERE statement is limiting data to the same day the person died.

you have to...

i would think do the following

add a new column, ie

update it to the equiv orig value, maybe in small batches

rename orig column

rename new column

drop orig column

ALTER TABLE myTable...

boehnc (5/24/2016)

---

thanks so much for your response Lowell. If, for example, a person who dies on Jan 1, 2015, I would need a count of visits from Jan 1, 2014...