SqlServer-QA.net

Got an interesting question in SSP about the SQL Server security patches that are released by Microsoft: 1) How often does Microsoft come out with security related patches for the database ? 2) Is there a URL where we can sign up to get notified about these patches if and when they are released ? Here is the response, there is no specified ...

What to do when you get the error specified on the subject above? You might get this error message from a job which will send email to an operator when it is completed. First thing to check whether a valid email has been mentioned in the operator. Also there are few other steps involved that involves restarting SQL Server Agent service, here it ...

That explains the reason, you could try by using the process in Administration Tools, Service manager, have you tried starting the 'Messenger' service (make it automatic if currently manual). If it doesn't start the reason should be in the Event Viewer. If the messenger service is running on the server you whould be able to type ''NET SEND ...

The Notification Services tutorial teaches you how to build a simple Notification Services application. The tutorial uses a SQL Server Management Studio solution to make it easy to edit tutorial files and then build the solution using SQL Server Management Studio Object Explorer. Before you start the tutorial, you should be familiar with ...

Have you ever identified the reasons for why and how does a query execution timeout happens within your SQL Server environment. For the beginners I would like to explain that before executing a query, SQL Server estimates how much memory it needs to run and tries to reserve this amount of memory from the buffer pool. If the reservation ...

You could take help of profiler or server side trace to see why the SMTP or SQLmail isn't initiated on that SQL job execution.   Also better to check under SQLAgent log for more information.

One of the IT support team member asked me the question ''Is there a way to have SQL Server 2005 send some sort of email notification when it starts up?'' The solution is straight forward and yes you can have such alerts or notifications based upon the facilities deployed on that SQL instance such as SQLMail or alerts using NET SEND ...

Trigger a trigger event when a new trigger is created, for a moment I was muffled with number of times you need to mention to call the subject. So looking at the need you will have to ask whether it is possible or not. Coming to the subject, yes it is possible when you are using SQL Server version 2005, as you can take help of DDL triggers. From ...

One of my Dev. DBA asked me this question about whether we need to use NOINIT or INIT for a differential backup schedule. Think about availability option in this case, you can overwrite the existing differential backup using INIT clause but when it comes to restore the combination of Full, Differential or set of Transaction log backups are ...

Having a feature of Notification on the server happenings is add-on for every DBA, Notification Services for SQL server 2005 has got that advantage. Microsoft confirms that capitalizing on the Microsoft .NET Framework and SQL Server, Notification Services provides an easy-to-use programming model for generating and formatting notifications based ...