Viewing 15 posts - 2,221 through 2,235 (of 9,725 total)
xsevensinzx (11/6/2015)
Jeff Moden (11/5/2015)
Precisely. I couldn't have said it better myself. It's a bit like interviewing a mechanic. If they can't describe the difference between and open...
November 6, 2015 at 4:25 am
Lynn Pettis (11/5/2015)
November 5, 2015 at 12:07 pm
Grant Fritchey (11/5/2015)
GilaMonster (11/5/2015)
Grant Fritchey (11/5/2015)
I'd strongly suggest looking at Excel and, maybe even more importantly, PowerBI. the technology is wildly different from what we think.
PowerBI is very pretty, and...
November 5, 2015 at 10:21 am
Erland Sommarskog (11/5/2015)
Glad to see that you got it working. Permit me, however, to point out that the solution was exactly what I was telling you. 🙂
Um, not quite. Using...
November 5, 2015 at 10:14 am
And I appreciate the double-check. Keeps me honest. @=)
November 5, 2015 at 9:52 am
Ed Wagner (11/5/2015)
First of all, don't forget to revoke that CONTROL SERVER permission you granted earlier. 😉
Did that as soon as I figured out it didn't work.
I thought you were...
November 5, 2015 at 9:15 am
BWFC (11/5/2015)
I've been asked to look into ad-hoc reporting solutions so users can create their own reports.
All I know is it's a SQL Server...
November 5, 2015 at 6:02 am
AAAAAAHHHHHH!
create credential ##xp_cmdshell_proxy_account## with identity = 'Domain\DomainUser', secret = 'password'
This let me create the credential for the service account without having to create a proxy account (which...
November 5, 2015 at 5:56 am
Ed Wagner (11/4/2015)
November 5, 2015 at 5:34 am
Ed Wagner (11/4/2015)
Hopefully, you're creating the procedure WITH EXECUTE AS OWNER instead of granting permission to the login.
I have not tried this yet. The login does need access to certain...
November 5, 2015 at 4:48 am
Erland Sommarskog (11/4/2015)
Logon failure: the user has not been granted the requested logon type at this computer.
But if this was a permission issue on the NAS, I...
November 5, 2015 at 4:45 am
Okay, so the problem is that I can't post the code for my stored procedure. Grrrrr.
See attached text file.
November 4, 2015 at 1:13 pm
EDIT: YAY! I can post now! Except when I try to post the additional info, it craps out on me... Let me try without the code bit and see if...
November 4, 2015 at 1:10 pm
Michael L John (11/4/2015)
Was it this link?http://www.sqlservercentral.com/Forums/Topic527155-359-1.aspx#bm1733766
Nope. It's this one: http://www.sqlservercentral.com/Forums/Topic1733767-1526-1.aspx
November 4, 2015 at 11:54 am
And apparently it's just that thread. How terribly annoying.
November 4, 2015 at 11:49 am
Viewing 15 posts - 2,221 through 2,235 (of 9,725 total)