Viewing 15 posts - 181 through 195 (of 217 total)
Could you please advice how to make it work?? I'm not getting an email when executing the procedure usp_DiskFreeSpaceAlert
June 19, 2009 at 10:48 am
Did you check the DBMail queue? It might give a hint on why it's not sent?
Also, if not mistaken, when you execute your SP, besides the "4 rows effected" it...
June 18, 2009 at 3:43 pm
EXEC msdb.dbo.sp_send_dbmail
@recipients = 'email@email.com',
@query = 'master..xp_fixeddrives' ,
@subject = 'Alert: Available space on systemName',
@attach_query_result_as_file = 0 ;
This scripts just gives how much space we have. But My goal is to get...
June 18, 2009 at 1:48 pm
Thank you.
I went through the script and I changed it to use database mail as below;
EXEC msdb..sp_send_dbmail @recipients = 'Myname@abc.com',
@subject = @MailSubject,
@body = @AlertMessage,
@profile_name ='SQL1'
Now, when I execute the procedure,...
June 18, 2009 at 1:01 pm
I have scripts that monitor the log space but I run these every hour so you can see the log space grow and shrink throughout the day, you might find...
June 17, 2009 at 10:05 am
Hi Mani,
As you said you are maintaining share point databases in sql server 2005, I have couple of questions.
1.What is your system database’s and user database’s collation settings?
2.Currently we...
June 16, 2009 at 1:26 pm
SQL Server has encountered 446 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [d:\Program Files\Microsoft SQL Server\MSSQL\Data\ABC_QA.mdf] in database [ABC_QA] (7). The OS file...
June 15, 2009 at 11:02 am
Iam trying to setup performce counters from perfmon. When add the counters, it not showing the counters but some numbers.
I checked the event viewer and found below error. How can...
June 12, 2009 at 6:31 pm
download and patch your MS-SQL instance
what should I download and patch the SQL Instance? Could you please explain me...
We have SQL Server 2005 Developer Edition with SP3.
Thanks
June 12, 2009 at 6:10 pm
Yes, I configured sql agent to use profile as below:
sql server agent->properties->alert system->select enable mail profile.
I had configured the database mail as below:
1. I created an operator ABC
2. I...
June 11, 2009 at 12:59 am
If I click setup.exe from the installation files, the installation wizard is coming up but not the uninstallation wizard.
I have the sql software in 2 folder;
1)Servers ->this is the place...
June 11, 2009 at 12:25 am
Can we use the LogShipping wizard to configure LogShipping, if the Primary and Secondary are in different Domains?
June 9, 2009 at 1:33 pm
Hi,
Perfmonace Object:
Physical Disk
Counters:
Avg. Dik Sec/Read
Avg. Dik Sec/Write
Avg. Disk Sec/Transfer
Avg. Disk Queue Length
These values should be less than 20 MS for individual disk.
I had set up the following counters and Iam...
June 4, 2009 at 12:13 pm
We have all the drives including C drive on SAN.
If SAN being shared then it has to be figured out what is causing that these messages recorded in error log.
the...
June 3, 2009 at 9:52 pm
First time when I installed sql server,I had copied installatio files from the CD and then installed.
Now, I have the copied installation files on the local drive.
June 3, 2009 at 9:38 pm
Viewing 15 posts - 181 through 195 (of 217 total)