Thanks very much for your response.Its much appreciated.I didnt have TFS ,I am just running Sql 2008 and wated to know the content of a particular Stored procedure at one time back before modification. Please advice.

Hi all, Could You please let me know how to trace a Stored Procedure modifications history within a certain period of time? Including the conetnet of a Stored Procedures at a particular period of time. Many thanks for your help.

Hi all , I am trying to lable my datapoints in Y axis to a currency. This will format my Y axis to currency ---- Chart1.ChartAreas(0).AxisY.LabelStyle.Format="C" How can i format my datapoints for Y Axis to have the same format as Currency? I thought this will work but there is no property like 'ItemlableStyle' --- : Chart1.ChartAreas(0).AxisY.ItemlableStyle="C"????? Can any one Suggeet any ideas? Thanks

Hi I have a chart control and have my y axis format like this: Chart1.ChartAreas(0).AxisY.LabelStyle.Format == "C" Which will show me (£ 100,£200 etc..). I have set the .Series("Revenue").IsValueShownAsLabel = True when i See the graph the numbers is formated for the the £ sign. However the point values for the y axis has not been formated with £ sign. How can i add a £ sign to each numbers of the Y values.? Please advice.

Thanks for your comment. DataTable dt = new DataTable(); { 006 dt.Columns.Add(new DataColumn("Hours", System.Type.GetType("System.String"))); 007 dt.Columns.Add(new DataColumn("TotalCall", System.Type.GetType("System.String"))); 008 dt.Columns.Add(new DataColumn("Minutes", System.Type.GetType("System.String"))); 009 dt.Columns.Add(new DataColumn("Revenue", System.Type.GetType("System.String"))); 010 011 dt.PrimaryKey = new DataColumn[] { dt.Columns("Hour") }; 012 013 } 014 015 using (SqlConnection con = new SqlConnection(Session("BMEAS_ConnectionString").ToString)) { 016 using (SqlCommand com = new SqlCommand(strCommand, con)) { 017 con.Open(); 018 int i = 0; 019 using (SqlDataReader reader = com.ExecuteReader) { 020 while (reader.Read()) { 021 string sSeries = reader.GetName(i); 022 DataRow dr = null; 023 string sData = ConvertToString(reader(0)); 024 025 if (sData == "Total") { 026 027 } else { 028 dr = dt.NewRow(); 029 try { 030 dr["Hours"] = Convert.ToString(reader(0)); 031 dr["TotalCall"] = Convert.ToString(reader(1)); 032 dr["Minutes"] = Convert.ToString(reader(2)); 033 dr["Revenue"] = Convert.ToDecimal(reader(3)); 034 } catch (Exception ex) { 035 } 036 037 dt.Rows.Add(dr); 038 039 } 040 041 } 042 int Count = dt.Rows.Count; 043 if (Count == 0) { 044 return; 045 } 046 047 { 048 Chart1.Series("Default").Color = Color.MediumSeaGreen; 049 Chart1.Series("Default").BackSecondaryColor = Color.Green; 050 Chart1.Series("Default").BackGradientStyle = GradientStyle.DiagonalLeft; 051 052 Chart1.Series("Default").BorderColor = Color.Black; 053 Chart1.Series("Default").BorderWidth = 2; 054 Chart1.Series("Default").BorderDashStyle = ChartDashStyle.Solid; 055 056 Chart1.Series("Default").ShadowOffset = 2; 057 058 Chart1.Titles.Add("Revenue Generated by Hour and Channel "); 059 Chart1.Series.Clear(); 060 Chart1.Series.Add("Revenue"); 061

Hi all, Could you please let me know which property of the chart object will allow me to format values in Currency? I want to have my Y axis to show Currency Amonut Like ($100,$200,%300 etc...) Here is my code.. How can i format the chart control so that the revenue apprears in £ sign? At the moment its jUst showing Numbers not having a $ sign. Here is Code: With dt .Columns.Add(New DataColumn("Hours", System.Type.GetType("System.String"))) .Columns.Add(New DataColumn("Revenue", System.Type.GetType("System.String"))) .PrimaryKey = New DataColumn() {dt.Columns("Hour")} End With Using con As SqlConnection = New SqlConnection(Session("ConnectionString").ToString) Using com As SqlCommand = New SqlCommand(strCommand, con) con.Open() Dim i As Integer = 0 Using reader As SqlDataReader = com.ExecuteReader While reader.Read() ' Dim sSeries As String = reader(0).ToString.Trim. Dim sSeries As String = reader.GetName(i) Dim dr As DataRow Dim sData As String = ConvertToString(reader(0)) If sData = "Total" Then Else ' For f As Integer = 1 To reader. dr = dt.NewRow() 'dr("Hour") = reader.GetName(i) Try dr("Hours") = Convert.ToString(reader(0)) dr("Revenue") = Convert.ToDecimal(reader(1)) Catch ex As Exception End Try dt.Rows.Add(dr) dt.AcceptChanges() End If End While Dim Count As Integer = dt.Rows.Count If Count = 0 Then Exit Sub End If With Chart1 .Titles.Add("Revenue Generated by Hour and Channel ") .Series.Clear() .Series.Add("Revenue") .ChartAreas.Clear() .ChartAreas.Add("ChartArea1") .ChartAreas("ChartArea1").AxisX.Title = "HOUR"

Thanks So much for your help.Its Much appreciated.Sorry to mention another Problem i have is to Put a $ sign in fromt of the Y axis. .Series("Revenue").IsValueShownAsLabel = True I have to show numbers that are in $ Sign? How could i do that? When i do the formatting on the Numbers i get a problem with the layout of the Graph. Could you please advice? Thanks

Thanks for your reply.All i wanted was how to name my X axis as for instance 'Product' and my Y axis 'Sales'. The link you have sent doesnt explain include this topic. Please advice. Thanks

Hi All, I am using a Chart control in VS 2010 .Can any one help me which property of this control allow me to Name my X and Y axis. The Values are defined by for instance Series("Test").XValueMember. I would like to name my X axis as 'Hour' and Y axis as 'Revenue' Can you advice please? Many thanks

Hi All, I have five web sites on my IIS 6.0 server. All but one of them (the one I am trying to change) is set to use ASP.NET 2.0. I changed one of my sites to use ASP.NET 4.0.30319.0. Now when I run this site I get get "Server Application Unavailable" and I get an application error (in my system event log) that says, It is not possible to run two different versions of ASP.NET in the same IIS process. Please use the IIS Administration Tool to reconfigure your server to run the application in a separate process. How do I fix this? Thanks for any help. Please advice Thanks

modified on Wednesday, June 30, 2010 11:54 AM

Thanks for your Help.

Thanks for the Reply. I have checked the login on Sql Server 2008 using Services.msc and changed the login to the login i use for windows. Its is still the same. Is there any advice you can suggest? Thanks.

modified on Monday, June 28, 2010 9:34 AM

Sorry Its Just by Mistake.

Thanks for your reply.Its Much appreciated.I have already checked and changed the user who loggs in as An is An administartor. Is there any thing i have to do to force the Login name to remain as the one who had access to that particualr folder. Many thanks for your Info.

Hi All, I am Stuck with xp_cmdshell to execute a Vb Script file? Can Any one tell me about the folder permission i have to do on the folder when excuting through commandshell? Thanks

Hi All, I have a very strange problem with xp_cmdshell. Here is a Stored Procedure that is meant to execute a VB script file.When i run the VB Script independently it works fine. But when i execute the stored procedure that is pointing to this VB script file it runs with No error But Doesnt do the work. Stored Procedure USE [Database] GO /****** Object: StoredProcedure [dbo].[sp_SendSMS] Script Date: 06/27/2010 10:14:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[sp_SendSMS] -- Add the parameters for the stored procedure here AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @Numbers NVARCHAR(200) DECLARE @Body NVARCHAR(160) DECLARE @Command NVARCHAR(500) -- Insert statements for procedure here SET @Numbers = '00442345672' SET @Body = CAST(GETDATE() AS NVARCHAR(20)) + ' Test Message' -- TODO: Get Revenue Statistics and append them to @Command SET @Command = 'd:\test\SendSMS.vbs /Numbers:' + @Numbers + ' /Body: "' + @Body + '"' EXEC xp_cmdshell @Command END The VB script file is under test folder on D drive which has Read write permission set on the folder. Set WshShell = WScript.CreateObject("WScript.Shell") sNumbers= WScript.Arguments.Named.Item("numbers") sBody= WScript.Arguments.Named.Item("body") URL = "http://sampleweb.com/samplepage.aspx?IFVERSION=210000&MESSAGETYPE=10&OADC=00447956053317&MESSAGEID=3333&RECEIVETIME=20070320151916&BODY=This is my 4th message on the LIVE TV&MCLASS=2&HEADER=0048001&DESTADDRESS=1234&CONNECTION=MIG01l1&DCS=240&RETRYCOUNT=3&PID=0&AVSTATUS=1&GUID=9BBA5E93-390C-450C-94C3-1122E5D4858B" WshShell.Run(URL) Set WshShell = Nothing When i run the VBS file Independently it works fine.However when running the stored procedure above which contains the file i dont see the file being excuted. Could You please advice what is going Worng? Thanks for your time.

modified on Sunday, June 27, 2010 6:43 AM

Thanks.I have already sorted it out. Cheers

Thanks For your reply and sorry to bother you.Can i do that from a Sql level? It would be great if you can give me an example. Many thanks.

That is Fantastic.Is there any way I can put Hour and Minute in One Column. Like : Time 10:00 10:30 11:00 11:30 etcc.. Thanks so much for your time.

Thanks so Much for your reply.Its much appreciated.Sorry i am Having trouble to understand it.How do i modify : (datepart(hour,CR_callstart)) As Hours Many thanks.