Viewing 15 posts - 136 through 150 (of 1,583 total)
anoop.mig29 (1/15/2015)Hi MyDoggieJessie
I have basic question where to execute the code you provided on secondary server ???
does it requires witnesses server to be present ????
I am getting below...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 15, 2015 at 9:40 am
Peter2012 (1/15/2015)
Could you help to fix this problem?
Msg 245, Level 16, State 1, Line 127 Conversion failed when converting the nvarchar value 'DBCLUSTER' to data type bit.
Perhaps need to convert...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 15, 2015 at 9:36 am
"COUNT()" returns total number of rows, irrespective of the contents...unless a specific column is specified that contains a NULL value, then those will be omitted
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 14, 2015 at 8:14 am
Peter2012 (1/14/2015)
When I tried to run the same script on my other database, it's throwing below errors. The same exact script, no change at all.
Msg 245, Level 16, State 1,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 14, 2015 at 7:55 am
Peter2012 (1/14/2015)
Have some queries:
- How to add date and timestamp to the message?
- What does it mean when the status is showing GOOD or otherwise?
- Should the script be run...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 14, 2015 at 7:50 am
EDIT: The post removes the < br /> tag that I added...so you need to put that back into the code...
I believe it's a rendering issue; but easily fixed....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 13, 2015 at 9:04 pm
Curious, have you altered the original script? Are you getting the results as an attachment or as the embedded HTML?
EXECUTE msdb.dbo.sp_send_dbmail @recipients = @Recipients
,@subject = @Subject
,@body = @Body
,@body_format...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 13, 2015 at 8:15 am
+1 Alexander Suprun
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 6, 2015 at 1:25 pm
I temporarily resolved the issue by backing up the old stored procedure under a new name and then recreating it under the original name. The report now runs as normal...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 6, 2015 at 1:24 pm
I've seen this happen with a lot of temp tables (and for the life of me I can't recall the exact reason for its cause); but try replacing some of...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 6, 2015 at 1:09 pm
What does the result of this show for this exact report (you may need to tweak the query to tailor to your needs)? SELECT TOP 1000 STATUS,
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 6, 2015 at 11:59 am
Did you ever end up using this software solution? I know this is a very old thread but noticed you were online so thought I'd take a chance...
We're looking...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 9, 2014 at 8:35 am
Thanks guys, I wasn't aware of these trace flags. I read the article and do have some concerns that Trace flag 1117 will cause all files to grow equally...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2014 at 9:28 am
This is more for a case when there are multiple data files in TempDB and I don't wish to set autogrowth because I don't want to risk growing a single...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2014 at 8:10 am
It's a feature!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 3, 2014 at 7:56 am
Viewing 15 posts - 136 through 150 (of 1,583 total)