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


Post New Web Links

Node Change Notification

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server
 

Hello Friends/Colleagues,

 

I have 2 nodes active/active with 3 virtual instances.

2 instances on node 1 and 3d instance on node 2.

 

Sometimes they automatically change from node 1 to node 2.

Is there any way that I get some notification regarding the instance that have changed from one node to another?

 

I found following may be probable solution:

EXEC master..xp_cmdshell 'cluster resource "SQL Server (Instance Name)"'

Result: Instance Name, Node Name

Put results into table..........Again run the command.....compare.......too much stuff.....

If someone knows the easy path to this.......

 

How could I get the information that has been changed?

 

Your help would be really great!

 

Thanks




View Complete Post


More Related Resource Links

clustered node change notification

  

Hello Friends,

 

I need a sql server script for my notification for the following.

I have node 1 and node 2 in my clustered environment.

 

Instances 1 and 2 usually runs on node 1. Instance 2 usually on node 2.

 

Sometimes they switch without notification. I need to know when they switch. Because I copy files from instances.

 

Need to know only what instance changed from which node and vice versa.

 

Any ideas and answers would be greatly appreciated.

 

Thanks


Treeview - how to change node icon depending on node contents

  
I have a treeview in an MVVM application: <TreeView ItemsSource="{Binding RootNodes}"> <TreeView.ItemContainerStyle> <Style TargetType="{x:Type TreeViewItem}"> <Setter Property="IsExpanded" Value="{Binding IsExpanded, Mode=TwoWay}" /> <Setter Property="IsSelected" Value="{Binding IsSelected, Mode=TwoWay}" /> <Setter Property="FontWeight" Value="Normal" /> <Style.Triggers> <Trigger Property="IsSelected" Value="True"> <Setter Property="FontWeight" Value="Bold" /> </Trigger> </Style.Triggers> </Style> </TreeView.ItemContainerStyle> <TreeView.ItemTemplate> <HierarchicalDataTemplate ItemsSource="{Binding Children}"> <TextBlock Text="{Binding NodeName}" /> </HierarchicalDataTemplate> </TreeView.ItemTemplate> </TreeView> The treeview is bound to an ObservableCollection called RootNodes. Elements in the RootNodes collection expose a member "NodeName" which is the text for the nodes in the treeview at runtime. They also expose a member called "NodeType", effectively an enumeration that indicates what type of icon should be displa

ASP.Net - App Pool restarts because of file change notification

  
Hi All,IIS restarts everytime i delete a file. I came across this code which was supposed to fic the problem but the line f.GetValue(..) in last but one line returns null. Can anyone tell me why this is happening -//FIX disable AppDomain restart when deleting subdirectory//This code will turn off monitoring from the root website directory.//Monitoring of Bin, App_Themes and other folders will still be operational, so updated DLLs will still auto deploy.System.Reflection.PropertyInfo p = typeof(System.Web.HttpRuntime).GetProperty("FileChangesMonitor", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Static);object o = p.GetValue(null, null);System.Reflection.FieldInfo f = o.GetType().GetField("_dirMonSubdirs", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.IgnoreCase);object monitor = f.GetValue(o);System.Reflection.MethodInfo m = monitor.GetType().GetMethod("StopMonitoring", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic); m.Invoke(monitor, new object[] { });

XML binding and notification on change

  
Dear all, I have a customer project when I need to display data into a WPF application. Data are deliver by my customer as flat XML file struture. For exemple: Information relative to a GOOD will be store in a GOOD.XML file Information relative to a CONTACT will be store in a CONTACT.XML file and exmaple of this structure is as follow : <GOODS> <GOOD> <CATEGORIE>APPARTEMENT</CATEGORIE> <NB_PIECES>3</NB_PIECES> <NB_CHAMBRES>2</NB_CHAMBRES> <SURF_HAB>60</SURF_HAB> <SURF_CARREZ>60,6</SURF_CARREZ> <SURF_SEJOUR>21</SURF_SEJOUR> <SURF_TERRAIN>0</SURF_TERRAIN> <ETAGE>0</ETAGE> <CODE_ETAGE>RJ</CODE_ETAGE> <NB_ETAGES>4</NB_ETAGES> <ANNEE_CONS>1996</ANNEE_CONS> <CUISINE>AMERICAINE</CUISINE> </GOOD> </GOODs> So the file avove will be sen from my customer app on a network drive. then I will read that file and bind my applicaction against. If my customer provide a file update, he will drop the new file at same network location and my application should read new data . The number of file extracted will be around 40 . Each file represent a separate object My questions are : 1- At first I was planning to build a local database as SQL express based on those file and work on the db but now I wonder if I should go to that

Cluster Node Change

  

Hello Friends/Colleagues,

 

I have 2 nodes active/active with 3 virtual instances.

2 instances on node 1 and 3d instance on node 2.

 

Sometimes they automatically change from node 1 to node 2.

Is there any way that I get some notification regarding the instance that have changed from one node to another?

 

I found following may be probable solution:

EXEC master..xp_cmdshell 'cluster resource "SQL Server (Instance Name)"'

Result: Instance Name, Node Name

Put results into table..........Again run the command.....compare.......too much stuff.....

If someone knows the easy path to this.......

 

How could I get the information that has been changed?

 

Your help would be really great!

 

Thanks


treeview selected node font style does not change

  

Hi All,

I have a treeview and I am giving the node style in code behind.

Treeview design is as below:

<asp:TreeView ID="tvIARHierarchies" runat="server" NodeIndent="15" ShowExpandCollapse="true"
                                        ShowLines="True" Width="98%" OnSelectedNodeChanged="tvIARHierarchies_SelectedNodeChanged">
                                        <ParentNodeStyle Font-Bold="False" />
                                        <HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" />
                      &n

Change Xml Node Attribute

  

Hello all...

I am trying to change the attributes of a xml node in a smart device application (pda).

The first problem I have is that xmlDoc.SelectSingleNode("xpath"); does not work.

I found another way to select each time the node i need (xmlDoc.DocumentElement.ChildNodes.Item(currentPosition))

and now I need to change the values of the node's attributes.

I have done this for a web application before but does not work here and cannot figure out what to do...

this is the code I have...

                XmlElement newElement = xmlList.CreateElement("SUB");
                XmlAttribute nameAttribute = xmlList.CreateAttribute("Name");
                nameAttribute.Value = tbProductName.Text;
                newElement.SetAttributeNode(nameAttribute);
                XmlAttribute priceAttribute = xmlList.CreateAttribute("Price");
                priceAttribute.Value = tbProductPrice.Text;
                newElement.SetAttributeNode(priceAttribute);
                XmlAttribute offerAttribute = xmlList.CreateAttribute("Offer");
                offerAttribute.Value = tbProductOffer.Text;
                newElement.SetAttributeNode(offerAttribute);
                XmlAttribute offerPriceAttribute = xmlList.CreateAttribute("OfferPrice");
        

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 ??

 


How to Localize Windows Forms and Change the Language at Runtime

  
Localization is the process of customizing your application to a particular language, culture or locale. Visual Studio provides support for localizing Windows Forms with much ease. In this article, we will see how to localize windows forms and give the user the ability to change to his preferred language at runtime.
When you run a localized application, the appearance is determined by two culture values. The UICulture property is used to specify which resource files will be loaded for the form. The Culture property, on the other hand, determines how strings such as dates, numerals, and currency amounts are formatted.
Let us see the steps required to create a localized form. You can then expand this example and adopt the same approach for the rest of the forms in your project

Selected to change the background color of the page

  

Hi,

As this site, http://www.borfin.com.tr/genel/Default.aspx, How can I change the background color selected pages.


Bug: Does not change column type from nvarchar to ntext

  

Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.

Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.


How to change the default page base class?

  

I've tried setting the <pages pageBaseType="DynamicWebPage" /> value in web.config, but when I response.write out the page type, I'm still getting Microsoft.WebPages.WebPage.

I'm simply trying to sub-class WebPage and add some additional functionality such as a dynamic PageData dictionary similar to Phil Haack's dynamic ViewData dictionary.

Thanks,

Adam


SqlDataSource how to change the stored procedures at run time

  

Hi

Is it possible to change the select, insert and update stored procedure of an SqlDataSource at run time. I don't mean to change the definition of the stored procedure, but I mean to change the assignment, i.e. To change the select stored procedure from "selectSP1" to "selectSP2" at run time. Is it possible?

Regards

Dimitris


Change Button Text in Multi Language Website

  

Hi i developing multi language website

using Master pages

everything fine

Page_Load i set the Text property of Button Control from Resource file

like this

Button1.Text = GetLocalResourceObject("Button1")

then in the button click event i cnage the text of the Button control

Button1.Text = GetLocalResourceObject("Button1_new")

but the text doesn't change and no error messgae

what is the problem how to solve this

 


How to change text in columns in SSRS?

  

I need to create a complex report and export it to Excel. 

In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. Any ideas please. I am new to SSRS and tried out many ways but didn't get it.


dynamically change column names in Crystal reports

  

I need to develop 3 pages.

On the first page user defines atmost 7 column names to be displayed on the report. I'm saving these names in a Sql DB table 'Columns' with Column_Nm and Column_ID as Table columns.

On the second page I'm retrieving column_Nm from the table and displaying them on the page so that the user enters the data. This data is saved in another table 'Summary' with the Columns column1 through column7.

on the 3rd page I need to show a report of 'Summary' table.

How do I dynamically replace column1 through column7 names with that of 'Column_Nm' on the report?

Any help/suggestions would be appreciated.

 


email notification error 5.1.1

  

 I am getting an error when sending email via asp.net.  The error is "Mailbox unavailable. The server response was: 5.1.1...User unknown."

However, the email is getting sent.  Why is asp.net returning this error?

I'm using VS 2008, vb.net,  running 2.0 framework.  This happens regardless of whether I'm testing my application from my local machine or running production version.  Also, I can send a batch of emails and get the error for some but not all.

I would like to be able to count of the error messages really being accurate, so this situation is unhelpful to our users, because they will start to just ignore all error messages.

Thanks,

 

 


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