Viewing 15 posts - 466 through 480 (of 1,583 total)
I find the easiest way to set up permissions in SSRS is to write it down on a blank sheet of paper first...it's so much easier to visually map it...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2014 at 7:29 am
This isn't what I meant. This is the maintenance plan's "auto-generated" code.
Try opening SSMS, on the server this all runs on expand the (+) for the SQL Server Agent,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2014 at 7:28 am
Permissions in SSRS are tedious, but can be easily set. The things to remember is the security structure in inherited....so what is set at the "top" level is granted...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2014 at 7:22 am
Is selecting the text, copying it into notepad, then saving it as an RDL file not an option or is your sole purpose to "automate" it?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2014 at 7:33 pm
Script out the jobs you are having issues with and post them here. There has to be some TSQL script sending the email...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2014 at 7:30 pm
So under the Agent "Notifications" tab, do you have "Email" checked, the appropriate "Operator" selected, and "When the job fails" selected? or are you doing everything via TSQL?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2014 at 2:26 pm
But you've never mentioned sending a report or a file via email, only that people were receiving emails in both cases when the result was good/bad.
So, it sounds like you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2014 at 10:32 am
+1 , anyone live in the Nashville, TN area???
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2014 at 8:47 am
No worries, we are all here to learn 🙂
If this is the case, can you confirm that in the Precedence Constraint Editor, that you have the Evaluation Operation set to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2014 at 8:10 am
+1 to bench-marking, hard to tell what is what without knowing your basic daily load. I would recommend using PerMon or a similar tool to perhaps tally up some...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2014 at 7:42 am
What we can ALL AGREE upon is whichever route you take, please DO NOT SKIP STEP #10
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 18, 2014 at 3:03 pm
You should set up transaction log backups to run "frequently". How frequently would depend on the type of system you have running and what level of point-in-time recovery option you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 18, 2014 at 1:45 pm
Quick update. Use varchar(max), not nvarchar(max).
This will detect any change within each string
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 18, 2014 at 11:54 am
You could tweak the script [Click Here][/url] to script out and store your indexes to a centralized table, then use a simple check to compare them (this is what I...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 18, 2014 at 11:35 am
OK, is it safe for me to assume that you are using the Maintenance Plan Wizards and you have a connection from the actual Maintenance task ---> the Notify Operator...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 18, 2014 at 11:23 am
Viewing 15 posts - 466 through 480 (of 1,583 total)