Viewing 15 posts - 121 through 135 (of 1,583 total)
Thanks for clarifying Luis, as always appreciate your insight! I'll take a look and see where I can make improvements to the process and take that back to the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 27, 2015 at 1:10 pm
Not sure what you mean there Luis. There could be 300 different columns in the ReportColumns table and I wasn't sure how best to link them all together
I didn't...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 27, 2015 at 11:42 am
Sorry that's only if you were using the GUI...
What is the spid currently doing?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 27, 2015 at 10:50 am
If you didn't check the box to generate the snapshot immediately then it should be relatively quick, it you generated the snapshot, it would depend on the amount of data...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 27, 2015 at 10:24 am
Anywhere before the send email portions of the script
Here:IF(@time_since_last_backup>15)
BEGIN
<< The code I asked you to run goes here >>
EXEC msdb.dbo.sp_send_dbmail
The code has multiple places where the sp_send_dbmail is executed...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 24, 2015 at 12:32 am
You need to do something debugging. Is there any one else at your shop that can assist you with this?
The fact that all those variables are blank is strange,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 23, 2015 at 7:32 am
Right before you send the email, add:
SELECT
@database_name, @server, @SubjectHTML, @tablecopyHTML, @tablerestoreHTML
EXEC msdb.dbo.sp_send_dbmail...
Etc.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2015 at 10:10 pm
If the email is empty, check the variables used in the email portion of the script - chances are of of the variables used in the @body is NULL, causing...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2015 at 7:32 am
I was referring to your error after running the Satnam's script
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2015 at 7:08 am
Also, if you had it error out, you will need to run the d-r-o-p table #logshipping_status_manual statement to remove the reference to the temp table
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2015 at 5:30 am
Wahoo got lucky today! (kidding) - Thanks for the question 😀
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2015 at 5:27 am
However, I've stated earlier, I've another secondary db from different system, it's totally another separate system
Is the MSSQL version different or the same as the secondary that works?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 20, 2015 at 5:36 pm
Peter, your post on 1/13/2015 9:30 PM showed that you were receiving the email (which means the code did work at that time) - can you try running the original...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 20, 2015 at 8:00 am
Try running it on the primary, or changing the data type for that parameter to nvarchar(10) instead of a bit
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 20, 2015 at 5:26 am
I no longer use log shipping (which is kind of why I can't remember the details (sorry )) ; but yes you will need to have a linked server in...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 19, 2015 at 8:44 pm
Viewing 15 posts - 121 through 135 (of 1,583 total)