Viewing 15 posts - 1 through 15 (of 23 total)
Thanks for the great responses and information. I enjoy collecting queries like those as well. I am completely sold on Source Code Management and have been doing for...
April 10, 2012 at 6:46 am
The tip for Ola Hallengren's site was worth the posting itself. That's going to be some interestign reading. Thank you very much!!
September 2, 2011 at 1:11 pm
Sorry - I forgot to post the message. I sanatized the message replacing the DB name with MyDatabase and the Domain as MyDomain and the server as MyServer.
The database...
September 2, 2011 at 12:49 pm
That's exactly the advice I was looking for. This solved my problem and fed my brain. I appreciate the responses. 😀
May 26, 2011 at 1:39 pm
Thanks Guys,
I guess I was used to most of the programming languages I work in. I simply moved the function call into the stored procedure and pass the value...
April 25, 2011 at 5:43 pm
You nailed it! Very nice answer. I think I learned a bit more than how to write filters 😉
February 6, 2011 at 7:33 am
Now that's some good thinking! I never thought to reverse the logic and if I was maintaining code that did that I would think "what's this guy doing?"...
February 6, 2011 at 7:28 am
Thanks but as I mentioned in my post - this report is driven by a stored procedure that I have no ability to change. I am limited to using...
February 5, 2011 at 12:22 pm
Lowell (12/6/2010)
December 6, 2010 at 12:59 pm
Michael Valentine Jones (12/6/2010)
declare @retcode int
exec @retcode = msdb..sp_send_dbmail ...proc parameters...
if @retcode <> 0
begin
...code to handle error ...
end
That's what I was looking for. I have lots of programming experience...
December 6, 2010 at 12:57 pm
Thanks - I understand that the email may not have actually made it through all points. I'm trying to at least catch any of the "local" problems that are...
December 6, 2010 at 12:55 pm
Thanks for the reply. I'm well into developing the same thing - a database having all physical servers and vm, all instances, all databases, all applications. I have SSRS...
October 13, 2010 at 4:30 am
Thanks all - good ideas. I started with scripting and using a global var that is looked at by the Contstraints for >0 or ==0. The Select...
September 21, 2010 at 2:50 pm
Thanks guys - I will be turning off known services and setting the source DB to "Single_User" before I take the backup. I will make sure there are no...
June 1, 2010 at 1:57 pm
Thanks everybody. Nothing is ever as straight-forward as it seems. I thought this might be easier since I wasn't moving this DB to another server - just moving...
August 31, 2009 at 5:48 pm
Viewing 15 posts - 1 through 15 (of 23 total)