a really nice feature is you an update on a cte affects the base table, so if you generate an identifier for dupes, you update everything that is a dupe.

WITH...

so your applicaiton has sysadmin rights, and whenever it creates a login, it makes it sysadmin, and then adds a user i guess.

if you kill it in a trigger, you'll...

SqlBarbarian (5/6/2016)

---

thanks! Exactly what I'm wonder. With SQL Sentry Plan explorer they anonymize to "column1", but all the column references in plan are consistent. So I was thinking something would...

remember there is a difference between a LOGIN and a USER.

nothing gets any rights unless you add them to a group or role that gives them permissions.

so, never add a...

obfuscate object names? that might make things difficult to get help with, because someone might suggest a change to the schema of a table, you have the mapping issue; but...

ok, here's how i would tackle it;

assuming your analysis on the two chars is correct, this produces both "versions"

of the data;

now i would simply test for high ascii, and take...

SQLRO (5/6/2016)

---

If I try to remove leading zero from 0x0231 with

STUFF(column_name,1,1,'') then it removes 02 as that is the first character in binary and makes the binary pattern as 0x31...

I'm always confused about what a data analyst title really covers as well, i tend to think of it as using statistics to find both trends and outliers, maybe with...

wow that's an interesting puzzle.

so is the varbinary string stored as a string datatype, or is it a varbinary(max)?

for a solution , we need the datatype as it is stored...

unless you have an extended event or audit already in place, you cannot capture that data; SQL executes a query and throws it away, but it might save the plan(the...

for a sandbox, My labs exist in either VirtualBox or VMWare; i have both installed on my beefy laptop. VirtualBox even has a portable edition, so you can keep them...

is the CAC card number in table anyplace, or can it be used to get CACNumber +email, so it can be joined to your ADObj table?

your snippet was incomplete/not syntactically...

also SQLServercentral is an awesome resource, besides the Stairways Series , and free ebooks,

read these forums.

a lot of us go to a bit of trouble to make sure there...

Danny987654 (5/5/2016)

---

Thanks for the responses.

I have installed the tools on my workstation but this was from the free version. I assume the developer edition is one we would need to...

this link has a couple of screenshots and an explanation that can help:

http://stackoverflow.com/questions/5772667/how-to-create-an-error-log-or-custom-error-log-within-an-ssis-package

basically, SSIS has a built in error logging mechanism, and you can have it write to one or...