since you have already set the isolation level to read uncommitted, the only thing a SELECT statement will do (assuming "-- report stmt" is really a select)

is to take out...

ptownbro (5/28/2016)

---

It in fact turned out to be a security issue. I gave access to the site and the top folder, but apparently that doesn't apply to every folder....

here's a more robust example, for more than one row in the original table, and where the end_serial_Number might be null.

the MiniTally table has to contain an integer greater...

seen that error before.

you don't have to investigate any jobs, just fix the login.

the default database for the logins does not exist.

so if I migrated the login mydomain\Lowell with a...

something like this gets the desired code name, but which would you want with multiple matches?

SELECT row_number() over(partition By T2.code_name ORDER BY T2.code) AS RW,T2.code_name As DesiredCodeName,T1.*

FROM dbo.table1 T1

...

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...