.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

SQL Server Shutdown Alert Notification

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
 
Is there a way to setup a notification within SQL Server when a shutdown or terminate is requested, in process, going to occur...anything? I see the events in sys.messages, and setup alerts for notification, but the alert isn't sent out, I am assuming because a shutdown or failover is in progress so alerting is stopped?? Just my thought, but I want to just send an email to a group saying "<SQL Server Shutdown In Progress>" or something, so we have a heads up. We currently have a cluster that fails over to another node (out of sequence) and we don't really find out unless we go look. We have no 3rd party tool for this atm.
John M. Couch


View Complete Post


More Related Resource Links

proactive caching, sql server notification problem

  
I'll explain the problem with this simple example. I have a dimension and a fact table: CREATE TABLE [dbo].[Lead_Dim](   [Id] [int] NOT NULL,   [LeadSource] [nvarchar](50) NULL,   CONSTRAINT [PK_Lead_Dim] PRIMARY KEY ([Id]) ) GO CREATE TABLE [dbo].[Lead_Fact](   [Id] [int] IDENTITY(1,1) NOT NULL,   [LeadAmount] [float] NULL,   [Lead_Id] [int] NULL,   CONSTRAINT [PK_Lead_Fact] PRIMARY KEY ([Id]),   CONSTRAINT [FK_Lead_Fact_Lead_Dim] FOREIGN KEY([Lead_Id]) REFERENCES [dbo].[Lead_Dim] ([Id]) ) GO In the cube, I've enabled proactive caching for dimension and measure group partition. I use SQL Server notification (tracking table is 'Lead_Dim' for dimension and 'Lead_Fact' for measure group partition). Other properties are set to default (silence interval 10s,...). When I insert a record in the dimension and a record in fact like this: DECLARE @LeadId INT SET @LeadId = 1 INSERT INTO [Testing].[dbo].[Lead_Dim] ([Id], [LeadSource]) VALUES (@LeadId, N'Agent') INSERT INTO [Testing].[dbo].[Lead_Fact] ([LeadAmount], [Lead_Id]) VALUES (1.2, @LeadId) GO proactive caching processes both dimension and partition and cube measure is refreshed. But, when I run this: DECLARE @LeadId INT SET @LeadId =2 INSERT INTO [Testing].[dbo].[Lead_Dim] ([Id], [LeadSource]) VALUES (@LeadId, N'Agent') WAITFOR DELAY '00:00:02' INSERT INTO [Testing].[

SharePoint Portal Server 2003 - email alert based on due date

  

Hello All,

Hoping someone can help us here.

Note:Workflow/3rd party solutions not an option-

We would like to send an email alert when a list items due date is eqaul to "today".

We are trying to manage some certificates of compliance by flagging the "due date of the particular certificate (list item)" and sending an alert email when that occurs.

Is this feasible in any manner without workflow?

Is it possible to send an alert based on a calculated field when that calculated data changes? .

Any direction would be appreciated.

Thank you

Mike Harvey
Software Solutions Architect

 


How to get notification if a new login is created in SQL Server??

  

Hi,

I have a requirement wherein to automate a process that when a new login is created in SQL Server 2005, I need to execute code to add the newly created username to another user table in my database.

I am aware of the system tables that can be queried to pull out the list of logins that exist in SQL Server database and identify any newly created logins.

However, I am looking at an alternate solution that allows me to get notified when a new login is created. It would be more like a trigger. Since I am dealing with system tables, I don't want to user triggers on system objects.

I have come across SQL Server Notification Service but I am not sure if it would be an appropriate feature to use for such a requirement.

If anyone knows of a better solution or if SQL notificaition services can be used for this, please share your thoughts.

Thanks!

www.mohansweb.com

 


email alert notification when task status column value is chaned

  

Hi All,

I am creating a document library in which there are few columns present (like Assigned To,Task Status,Reviewr etc.)

I want to send alert or email notification when the status value is changed. Alert should go to "Assigned To" selected value from the Reveiwers name.

I have tried this with "alert me" functionality provided by WSS 2007 but I think it will not sufficient for me?.

I am not able to proceed please help me?


Empty field on Alert Notification email sent to user when they add an 'Alert Me'

  

 

Hello,

I'm trying to figure out the empty field that should be populated in the email that a user receives when adding an alert. The missing field is the bit in single quotes that is blank. I have added a link to a screenshot below as well.

What is the source of this field? Any ideas why it is blank?

screenshot

thanks in advance.

 

Alert 'xxx' has successfully been added on '' .

You will receive alerts in e-mail. The timing and criteria for the alerts depend on the settings entered when the alert was added.

You can change this alert or any of your other alerts on the My Alerts on this Site page.

 

 


Change the format of List Alert subscription Notification

  

When we subscribe to any list item for alerts we get an email message for confirmation of successfull subscription.

 

the email  looks like below :

 

Subject : You have successfully created an alert for 'Team Discussion: Topic 1

 

Body ;

Alert 'Team Discussion: Topic 1' has successfully been added on 'Test Site'.

You will receive alerts in e-mail. The timing and criteria for the alerts depend on the settings entered when the alert was added.

You can change this alert or any of your other alerts on the My Alerts on this Site page.

 

I wish to change the format of this email. Any Inputs ??

 


Email alert is created but i didn`t received any notification when an item changes

  
I received an email alert when an alert is created.but i didn`t received any email notification when an item changes.??can any one please help me with this..?
sru

Failed to activate worker process manager - alert or notification is not sent, despite checking lis

  
04/05/2011 14:06:35.69 	SPUCHostService.exe (0x0368)      	0x0CA4	SharePoint Foundation     	Sandboxed Code Service    	ei0v	Verbose 	 - Failed to activate worker process manager for "ipc://6f87b90b-c7a9-411b-850c-a3919c35ca92:7000". Sleeping 1 second(s) before trying again.	 

The error occur when the workflow process use option "collect data from user".
The task is created and assigned correctly , but alert or notification is not sent, despite checking list option
"Send e-mail ownership is assigned "

Trouble Creating SQL Server Peformance Condition Alert

  

I was attempting to create a SQL Server alert that checked for the log file size of a database.  The issue is that my database is not listed under "instance".  Other databases are missing as well but I do not know how or why a database shows up under instance name.  Does anyone know how I can get my database to show up in the instance dropdown list?


Emial Alert Notification on Task Creation

  

Have a site that we think has some database corruption so we exported the site and then imported in into anotehr new site with a slightly different name.

When we run workflows on the new site tasks are created properly but the email notification is not sent.  Looking at the site names in the ALERT COLLECTION they appear to be the same, that is, the old site SITE1 has now been cloned to SITE1_2.  However the ALERT COLLECTION SPSite name for both sites says Site1.

Am wondering if this is why the email notifications are not being sent?

 

Thank you

Chuck


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend