specific error is probably helpful; i suspect it's the column name is misspelled due to copy paste?

or is it because the table busidentity is not in the join criteria on...

there's a pair of functions that you can use to get either the things the views reference, or the things that the view consumes.

--objects that USE the views

SELECT

schema_name(vwz.schema_id) As...

that's a tough one, since the bat could be doing anything, and it's outside of SQL server.

you could open up Task Manager on the server, but the real question is...

i have specific jobs that are identical on all servers, things like backups, statistics, indexing.

i connect via Central Management servers, and run the create job script on all of them...

not quite sure what...

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