Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Browse by Tags

All Tags » notification   (RSS)
Error: An attempt was made to send an email when no email session has been established.
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 Read More...
Learn about Notification Services - a tutorial
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 Read More...
Alert when a specific SQL instance service has been started
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 Read More...
To be or not to be in using INIT or NOINIT in backups
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 Read More...
Notification Services - What for it is used?
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 Read More...