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

Redgates tools are awesome, i ponied up and bought them for myself, but they are expensive.

on a cheaper note, if you've installed SSDT, you can easily use the built in...

I see you posted in SQL2008, you need to install the tools like SSMS and BIDS on your workstation from some production media, or from a 2008/R2 developer editions...

i'm pretty close to Jez's methodology; i've pretty much had one specific account for 90% of my proxy situations; it's mostly about accessing network resources. i tend to use that...

you probably need to simply join three groups of data together to create your view; it might be slow;

CREATE VIEW vwGeneralTransactionsMultiSite

AS

SELECT T1.Site,

T1.Trans_num,

...

my keyboard has a light to signify caps lock on or off, isn't that significantly easier than asking for one specific application to show it's status? just glance at...

carol can you simpyl test your users xp_cmdshell permissions? does this still give permissions errors?

EXECUTE AS USER='pvtreader' --test as our specific users permissions.

exec xp_cmdshell 'whoami'

REVERT; --change back into myself