Viewing 15 posts - 451 through 465 (of 1,584 total)
Sounds like an issue with the number of parameters defined in the actual RDL file on the SSRS server, versus the number of parameters the procedure actually has (i.e....
February 25, 2014 at 7:22 am
Did you GRANT SELECT access to the table directly or did you add a datareader role globally to the user on the linked server?
February 25, 2014 at 7:18 am
Check to see if your account has been locked out in AD (I've had this happen before)
February 24, 2014 at 1:07 pm
In addition to all the sound advice that every one else has given you already, I'd like to add that before you go for the interview, you decide for certain...
February 24, 2014 at 12:39 pm
This may not be a route you want to take, but we experienced a similar problem while a server was being used for both DEV/PRODUCTION. I created a trigger...
February 24, 2014 at 11:11 am
david.alcock (2/24/2014)
February 24, 2014 at 10:59 am
richardmgreen1 (2/20/2014)
I basically need to move all the permissions up one level before I start restricting things...
February 21, 2014 at 7:23 am
In order to get around this you need to disable the existing alert. It will not allow you to have multiple alerts for the same Error Number (14161)
February 20, 2014 at 2:19 pm
AFAIK, yes it's manual.
The best practice is to set the most basic level of permissions on the "Home" folder, then start applying more specific permissions on folders at that level...
February 20, 2014 at 2:11 pm
Hope it helps! If it does, please mark the reply as helpful so others won't have to read all the comments when they come across your OP 🙂
February 20, 2014 at 10:18 am
You can automate the onclick event for the textbox to open up a new window/iframe/notepad/etc that can contain the XML text, but you won't be able to automate the actual...
February 20, 2014 at 9:44 am
Ok, thanks for this, and it confirms there is nothing specific set in your Agent job that is sending the email. So go back to the maintenance plan...
February 20, 2014 at 7:59 am
+1 Eugene, we need to know how to slice the dates in order to provide the sums...
Without having any idea whatsoever, this might get the OP started ;WITH CTE AS...
February 20, 2014 at 7:56 am
What constitutes a period of time? Day/Month/year/etc?
February 20, 2014 at 7:48 am
Viewing 15 posts - 451 through 465 (of 1,584 total)