Viewing 15 posts - 46 through 60 (of 62 total)
batgirl (9/11/2013)
wak_no1 (9/11/2013)
I have a script, which when ran inserts values from multiple tables into another table, then executes 'sp_send_dbmail'. I use the '@query' parameter in 'sp_send_dbmail' to select from...
September 11, 2013 at 11:45 am
This seems to have done the trick, thanks.
I was looking into HTML formatting, but that looks quite heavy in terms of getting it set-up.
September 11, 2013 at 11:44 am
Luis,
Thank you for the reply.
I have though worked it out! I used a JOIN in the IF statement, If the results of the Join were > 0, the script executed...
September 2, 2013 at 10:36 am
I don't think it's an official Microsoft SP?
If that is the case, I can't use it 🙁
Although it looks like exactly like what I need; just a snapshot of the...
August 28, 2013 at 8:10 am
Effectively, I need to be able to establish quickly which sessions are using a high amount of CPU.
I'd want for example, a job to run every 5 minutes, which pulls...
August 28, 2013 at 3:48 am
What would you suggest is the simplest and most easy to read method of establishing which active session is using the highest amount of CPU? I want to stay away...
August 28, 2013 at 1:47 am
Hey
You're right, I eventually sussed it.
For anyone wanting to know:
IF (SELECT cntr_value FROM sys.dm_os_performance_counters WHERE counter_name='User Connections')>200
EXECUTE msdb.dbo.sp_notify_operator @name=N'OperatorName',@subject=N'Subject', @body=N'Body blah blah'
August 23, 2013 at 7:05 am
Hi
Problem with that is that the alert will not trigger because the event does not get written to the logs, this is something I've tested.
Effectively, I just need an alert...
July 29, 2013 at 8:34 am
A full back is initiated 10 minutes past midnight every night, current retention is 3 days, where then the backup are copied off to to tape. We're looking at storing...
July 26, 2013 at 7:06 am
Found something for free; It's called SQL Developer, it pretty much does what I want it to.
July 10, 2013 at 3:34 pm
Thank you, this work pretty exactly how I wanted it work.
The only issue I'm having now is that when I open the output script (with the CREATE LOGIN statements), MSSQL...
June 28, 2013 at 4:44 am
Thanks you, I will test this and get back to you.
June 26, 2013 at 8:38 am
Thanks.
If I run the SP unaltered, it outputs a neat looking script, is there no way I can simply backup the output, without having to amend the SP and create...
June 26, 2013 at 7:39 am
Viewing 15 posts - 46 through 60 (of 62 total)