Viewing 15 posts - 451 through 465 (of 1,583 total)
Did you GRANT SELECT access to the table directly or did you add a datareader role globally to the user on the linked server?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 24, 2014 at 11:11 am
david.alcock (2/24/2014)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2014 at 2:11 pm
Very creative Luis, kudos!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2014 at 1:57 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 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2014 at 7:56 am
What constitutes a period of time? Day/Month/year/etc?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2014 at 7:48 am
While it may be a "bad practice" (and agree with all that others have said), any critically important queries that I need to run against production (say a hot fix/patch...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2014 at 7:34 am
Viewing 15 posts - 451 through 465 (of 1,583 total)