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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

Any ideas about this?

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server
 
HI experts, am having some doubts regarding alerts in sql server 2008..
First of all  i will insert some records into sql server 2008, each time  a new record is inserted with
status 0.Now we should update this status to '2' in two hours.otherwise an alert should be raised that particular row 
has not been updated by 2 hours?and this should send a mail.

How can i do this?

can this be achievable in sql server or asp.net?if so how can I?



View Complete Post


More Related Resource Links

{ End Bracket }: Your Innovative Ideas

  

Having that next great innovative idea is only half the battle-getting it heard is the real challenge.

Eric N. Bush

MSDN Magazine February 2009


36 ideas over the weekend for improving Visual Studio

  

We released WoVS last friday around mid-day. Since then, that is, only two days later, its Community section has received 36 different ideas for new VS features and improvements to existing ones. THIS IS JUST AMAZING!

Some of the more popular submissions so far are VS RoamingStack Overflow integration, and a built-in Chat!.

Even

"System.ArgumentException: Font '?' cannot be found" during application start up. Any ideas?

  
We have couple of users that get this error when they run our application.  I have never seen this problem before. Client says fonts are installed and Microsoft Sans Serif font is there as well. Also he states that user has Read permissions to %SytemRoot%Fonts folder. Any suggestions or ideas how to fix this problem will be appreciated. Thank you.  Here is the stack:   Exception: System.ArgumentException: Font '?' cannot be found.   at System.Drawing.FontFamily.GetGdipGenericSansSerif()    at System.Drawing.FontFamily.get_GenericSansSerif()    at System.Drawing.SystemFonts.get_DefaultFont()    at System.Windows.Forms.Control.get_DefaultFont()    at System.Windows.Forms.Control.get_Font()    at System.Windows.Forms.Control.AssignParent(Control value)    at System.Windows.Forms.Control.ControlCollection.Add(Control value)    at Bloomberg.SmartClient.Hosting.ErrorControl.InitializeComponent() in C:\Projects\Source\Client\ApplicationHosting\ErrorControl.cs:line 218    at Bloomberg.SmartClient.Hosting.ErrorControl..ctor(String appTitle, Boolean inPanel, Exception exception) in C:\Projects\Source\Client\ApplicationHosting\ErrorControl.cs:line 119    at Bloomberg.SmartClient.Hosting.ApplicationHost.OnDisplayError(ApplicationDescription appDescription, Excepti

"System.ArgumentException: Font '?' cannot be found" during application start up. Any ideas?

  
We have couple of users that get this error when they run our application.  I have never seen this problem before. Client says fonts are installed and Microsoft Sans Serif font is there as well. Also he states that user has Read permissions to %SytemRoot%Fonts folder. Any suggestions or ideas how to fix this problem will be appreciated. Thank you.  Here is the stack: Exception: System.ArgumentException: Font '?' cannot be found.   at System.Drawing.FontFamily.GetGdipGenericSansSerif()    at System.Drawing.FontFamily.get_GenericSansSerif()    at System.Drawing.SystemFonts.get_DefaultFont()    at System.Windows.Forms.Control.get_DefaultFont()    at System.Windows.Forms.Control.get_Font()    at System.Windows.Forms.Control.AssignParent(Control value)    at System.Windows.Forms.Control.ControlCollection.Add(Control value)    at Bloomberg.SmartClient.Hosting.ErrorControl.InitializeComponent() in C:\Projects\Source\Client\ApplicationHosting\ErrorControl.cs:line 218    at Bloomberg.SmartClient.Hosting.ErrorControl..ctor(String appTitle, Boolean inPanel, Exception exception) in C:\Projects\Source\Client\ApplicationHosting\ErrorControl.cs:line 119    at Bloomberg.SmartClient.Hosting.ApplicationHost.OnDisplayError(ApplicationDescription appDescription, Exception err

Databind issue, any ideas

  
I have a stored procedure that returns 3 searches 1) ALL records2) Records staring with something3) Records containing something The stored Proc works fine here is the proc header:CREATE PROCEDURE [dbo].[procGetOHLCSymbolReferenceQuick](@SearchContains VARCHAR(20)='X1234',@SearchStartsWith VARCHAR(20)='X1234') THE ISSUEI have a gridview on a user control, with two texboxes. The gridview is supplied by a SQLDataSource. The textboxes provide that Users Filter demands. The TEXT BOXES <asp:TextBox ID="txtNameStartsWith" runat="server" Width="75px" TextMode="SingleLine"  BackColor="#FFF6CD" /><ajaxtoolkit:FilteredTextBoxExtender ID="FilteredTextBoxExtender1" runat="server" TargetControlID="txtNameStartsWith" FilterType="LowercaseLetters,UppercaseLetters,Numbers,Custom"  ValidChars=" @$.^!" /> <asp:TextBox ID="txtNameContains" runat="server" Width="75px" TextMode="SingleLine"  BackColor="#FFF6CD" /><ajaxtoolkit:FilteredTextBoxExtender ID="FilteredTextBoxExtender2" runat="server" TargetControlID="txtNameContains" FilterType="LowercaseLetters,UppercaseLetters,Numbers,Custom"  ValidChars=" @$.^!" /> THE SQLPARAMETERS &l

SQL ideas as a hobby

  
Hi This is not you normal question I guess. Basically my problem is that I only work with SQL part-time at work. Other times I'm answering the phone, helping someone or do a different programming Language ( called Mumps - I know I bet your asking yourselves... whats Mump? Its an old medical programming language but someone has to do it). Anyway, does anyone have any ideas what I can do so I don't forget my SQL - it feels like I learn it quite well, have to leave it for a while, come back to it and find that I'm not as good at it anymore. Anyone got any ideas or maybe hobby ideas I can do so I don't forget what I've learn't. Thank you Matthew.

Looking for suggestions or ideas how to setup to capture search criteria and present to user if they

  
Requirements call for the ability to save search values so that they can select them at later times to return the results without having to re-enter the values. They have the ability to search on 4 different types of data (Date, Time and Lat/Long), so they would like to capture what was entered and ONLY if they chose to save those values, it will be saved and next time they login, if they are searching, they can pick an old search and submit it again.   Im thinking that i add a checkbox next to each button, if they check it, it saves the data into a table with there values and username. Next time they login and go tothe search page, if there are any records for them in the table, i present them with a link that displays all the values stored and if they select one, it will run the search again and present them with the results.. does that sound like the right way to handle this request? 

Securing AJAX Calls from JQuery (Looking for ideas, suggestions, best practices).

  

Hello,

I am working on web application in which all of the data I am submitting back to the server is being done on the client side using JQuery AJAX calls to my .NET web services using JSON.  This works perfectly to enhance my user experience and greatly reduces post backs, etc.

What I am looking for suggestions on is securing the web services being exposed to the client side from being used by anything but my JQuery code on my site.  The security hole that I see here is that since the client-side JQuery can access the web services, so could anything.

Any ideas?  What is the best practice here?

Thanks


I need ideas on how to build a SOX site in our sharepoint intranet..can you help me?

  

I was asked to set up a sharepoint site for SOX after a 2 day sharepoint training (yup..that's right as if i have all the knowledge to do this right?) so ..I am in need for some ideas on how to start and what should i include...

 

Thank you everybody!!


any ideas?

  

HI experts, am having some doubts regarding alerts in sql server 2008..
First of all  i will insert some records into sql server 2008, each time  a new record is inserted with
status 0.Now we should update this status to '2' in two hours.otherwise an alert should be raised that particular row 
has not been updated by 2 hours?and this should send a mail.
How can i do this?

Looking for ideas to 'normalize' data in a poorly designed SharePoint list

  

Hi All,

The following is my scenario. I have been handed a list which has 180+ columns! The principal reason there are so many is the same set of 5 columns has been repeated nearly 30 times to capture multiple instances of the same type of data e.g. date1, detail1; date2, detail2 and so. Horrible. I would like to take the data in this list and push it into a new list which has 1 row for each of the instances of the dataset e.g. it just has a date, detail column etc and consequently about 140 less columns! Complicating matters is the fact that one of the columns contains data in a multi-select lookup from another list in the same site.

I am trying to achieve this using Office tools only...e.g. Access, Excel, perhaps SharePoint Designer...I don't have dev skills, although I could ask others.

It seems to me I can work with these lists connected to Access and write a query which would get the data into the correct format but the multi-select lookup column causes issues:

  1. I can't seem to write an SQL query with a UNION operator when a multi-value field is involved
  2. I can't write an INSERT INTO (new list) statement where a multi-value field is involved
  3. I might also run into problems with display value versus ID for the lookup even if I could do the insert?

Any suggestions on how I might go about thi

Suggestions and Ideas are needed for doing the below

  

 Hi all,

I have stored the html contents in Database Table column like page content now i want to display those saved contents on the page now suggest me may i use the Div with run at server or any other control iam talking about the performance Point of view ????

Which control should i use for displaying the html contents on the aspx page ???

 

Suggestions are welcomed

 

Best Regards


Secure transfer of files in a wcf Service.?help and ideas needed..!!!

  

hey wcf guys...!! hi all

hmmm.To start with I have developed a wcf application...where files are uploaded and th wcf service also supports resume functionality as well...That is done and now remains SECURITY!!.Fine i want the files to be uploaded in a secure manner..so that no one else on the channel can access it..I mean i requrire security,,obviously..for it(application) to go live..

 

Now ,i actually dont know how could i implement it??..should i attach a certificate??how do i do that?? Using BasicHttpBinding in the application .Have no idea as to how will i implement security..so could any kind person please give me a clear idea an d help me go through this..??

anyway..thanks in advance..waiting for some good ideas and responses...

Thanks

Mumtaz..


Mumtaz Surani

MSSCrawlURL table is filled ErrorID: 560 Error in the Site Data Web Service; Any ideas why?

  

I'm performing fullcrawl and I was examining results in table: MSSCrawlURL.  I found that table is filled ErrorID: 560 - Error in the Site Data Web Service. Does anyone have any ideas what maybe causing this issue?

Here is the SQL statement I ran:

SELECT  ErrorID
FROM [WSS_Search_CC-CLINTRA54].[dbo].[MSSCrawlURL] where ErrorID != 0 and DisplayURL like '%sharepoint.ccf.org%'
Group by ErrorID

Output:
Totals ErrorID
5        3
2        4
37753 560


POZERUGA

Schedule a package to run again... Any ideas how?

  

Hi

I am planning on using a File Watcher task to have an SSIS wait until a file is submitted. This seems to work ok. However I want the package to launch itself again once it completes, or schedule itself to launch again in a couple of minutes. That way I could relaunch the task after it has processed and moved the current set of files. That way it would process loads more or less as they are exported by the source systems. I'm not even sure how to approach this problem as its not something I've done with SSIS in the past. The current solution uses batch files and DTEXEC so I'm guessing its scheduling via the windows scheduler. I would lean towards SQL Server Agent personally but that's just because I'm looking for something that will expose what jobs are running to me more easily than investigating processes.

I also wanted to know if it was possible to see what other packages were already running. That way if a package inadvertently launched while another instance of itself was still processing it could just shut itself down. I may also have dependencies between packages. So if package A was running, package B should wait rather than processing any of its files, and vice versa. I could do this by logging the packages in and out of a cusotm locks table, but that feels unweildy and the package may crash out and not "unlock" cor

flv video handling and streaming capabilities of a sharepoint site, thoughts and ideas :)

  
Here is the thing.

We are re-designing an already working site but now we are using moss 2007.

In the new site we want an area where are users can see videos of the company. We will use the flv format for our videos. How does moss handle these kind of files? Is it easy to create lists with these kind of files and then using a gridview to lets say make a shocase of the data stored there? I mean the videos, perhaps a thumbnail and some metadata etc. When something is uploaded to a sharepoint list everything is stored in the data base, so if I use a grid view i will pull the data out of the data base?

I am walking blind here, this is more of a general discussion question. I have no idea on how to even start to implement this sort of thing, I am just trying to figure it out and see how I can go about this.

Thank you all in advance, hope my post is clear.

Panos

Search Services Application error. Can I restore to default? Or other ideas?

  

Hello,

I posted an question but I think I may have put it in the wrong forum. 

When trying to create a new Search Services Application (after deleting old one) I get the following error:

An unhandled exception occurred in the user interface.Exception Information: Some or all identity references could not be translated.

This is the only application that gives me an error.

Original post was here:  http://social.msdn.microsoft.com/Forums/en/sharepoint2010customization/thread/86fa1a52-5a57-4ffe-8153-f9646a1b87c6

Help is Greatly appreciated!!

Thank you,


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