Viewing 15 posts - 1,171 through 1,185 (of 1,584 total)
Not sure why you'd want to use this (as the results from the sp_help_log_shipping_monitor will be in a horrible format using this method) but this will work:
exec msdb..sp_send_dbmail
@recipients='chintu@www.com'
, @subject ='Log...
February 29, 2012 at 4:26 am
Greg Charles (2/28/2012)
February 28, 2012 at 10:52 pm
You beat me to it Nicholas! I'm always a day late and a dollar short! hehe:
February 28, 2012 at 11:02 am
Growing the data files will cost you disk resources (no matter when you do it) - and with DB's that constantly grow there is no way around this but to...
February 28, 2012 at 10:44 am
Have you tried outputting the error to a text file? i.e. /ee:logfile.txt
Try something like this:
bcp "exec %SERVER%.dbo.Pull_Voucher_Data" queryout C:\Vouchers.txt /ee:logfile.txt
-t\t -c -S%Server1% -b2000 -T
February 28, 2012 at 10:30 am
The money datatype can only be accurate to the ten-thousandth and does it's own rounding, which if you're using it as a data type for financial calcs you may wish...
February 28, 2012 at 10:22 am
No problem! Remember, the creation of the files on the local folder is very temporary (milliseconds to seconds) while they are MOVED to the proper location...suggest using "c:\temp". 🙂
February 27, 2012 at 12:37 pm
But fact that the execution plans for the procs are often cached and more likely to be reused isn't though. This isn't an option when running ad hoc select...
February 27, 2012 at 12:34 pm
Distribution clean up: distribution
This job has been running on SPID 72 for 5520 minutes.
February 27, 2012 at 10:10 am
Sounds to me like your "team mate" has either learned to do it one way and is afraid to learn how to do it the proper way or just refuses...
February 27, 2012 at 10:00 am
Yes. It's definitely a limitation with rendering a large report across the network using the rs.exe application (you'd think there'd be some documentation on that somewhere on BOL -...
February 27, 2012 at 9:41 am
I'm pretty certain there's no historical information like that pertaining to DMV's (however the experts around here may know of one). I can tell you that this information wouldn't...
February 27, 2012 at 9:25 am
This is by far the most whacked out code I've ever written and would never actually use it for anything other than the fun of "trying it", but I believe...
February 23, 2012 at 11:35 am
This is a good example but would this be restricted to the number of d.lid's (in this case hard-coded to only 3 line items?)
February 22, 2012 at 5:45 pm
Viewing 15 posts - 1,171 through 1,185 (of 1,584 total)