Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
hdjk11
Shivakumaran
dfefde5
hoangnganvy1993

### MSchart Xaxis Minimum and maximum

Hi,

I'm doing chart running in application using C# VS2010 to make my Chart Xaxis move. when i place my code and run it, it show nothing. so i created another program using vb.net using the same code as C# yet my vb.net code allow me to make my Chart Xaxis moving. moving mean from 1pm to 1.10pm and so on.. which mean my minimum of the chart and maximum will keep moving.

--------C#---------Below code is in timer1

`System.Data.DataSet temp_sec = null;if (count != i)                    {                        //chart1                        dt = Convert.ToDateTime(temp_sec.Tables[0].Rows[i].ItemArray[0]);                        deg = Convert.ToDouble(temp_sec.Tables[0].Rows[i].ItemArray[1]);                        /                        chart1.Series[0].Points.AddXY(dt.TimeOfDay.ToString(), deg);                                                                      if (Tick == 0)                        {                            double min, max;                            min = dt.ToOADate();                            chart1.ChartAreas[0].AxisX.Minimum = min;                            max = dt.AddMinutes(Tock).ToOADate();                            chart1.ChartAreas[0].AxisX.Maximum = max;                   `

### Given a Numeric range for a regex, how to get the minimum and maximum range values?

If I create a random regex that is restricted to numeric ranges (leading zeros included), how can I determine the minimum and maximum values of the range from the regular expression itself?

For example, if the range is 011 - 453 and I had this regex: ^0*(1[1-9]|[2-9][0-9]|[1-3][0-9]{2}|4[0-4][0-9]|45[0-3])\$

How can I reverse engineer out of the regex the min value - 011 and the max value = 453.

I want this in order to create an error message dialog that would say, "The value must be between MIN and MAX".

### Maximum memory for string ? . System.MemoryOutOfException Occurs when reading the Content of the fil

Hi,

I have a C++ code which reads a file [vtk file - its similar to text file only]. and try to store it in string.

here's the code:

String^ ParallelProjectionRenderer::GetVolumeDataAsString(String^ FileName)

{
vtkSmartPointer<vtkDataSetWriter> sWriter = vtkSmartPointer<vtkDataSetWriter>::New();

String^ FileName = "D:\\Users\\...";

char * sptName = static_cast<char *>(Marshal::StringToHGlobalAnsi(FileName).ToPointer());

sWriter->SetFileName(sptName);

sWriter->Register(nullptr);

sWriter->SetInput(this->dataSource);

sWriter->SetFileTypeToASCII();

sWriter->Write();

sWriter->Delete();

String^ result= File::ReadAllText(FileName);   [it breaks here with system.memoryoutofexception when the file size is huge]

return result;

}

this code executes fine when the file size is less than 8mb.

I wanted to know whats the maximum memory allocated to the string.

As a workaround i skipped reading out in C++ code. and i tried to read the file contents in asp.net C# code and stor

### The statement terminated. The maximum recursion 100 has been exhausted before statement completion.

Hi All

I have the below sql scripts that give me the error:
"The statement terminated. The maximum recursion 100 has been exhausted before statement completion."

Ive tried using OPTION ( MAXRECURSION 0 ) or 1000 but it still  give me the same error.

```WITH cte as (SELECT     ticketid, setstatus, setdate, row_number() OVER (partition BY (ticketid)
ORDER BY setdate ASC) AS rn
FROM         [OneForm].[dbo].[TFAM_SLA_Times]
UNION
SELECT     TicketID, 'Submitted', SubmittedON, 0
FROM         [OneForm].[dbo].vw_TFAM_ALL)```
```    SELECT     a.ticketid, SUM(OneForm.dbo.[CalcMinutesSLA_TFAM](a.setdate, b.setdate)) AS SLA_in_Min
FROM         vw_TFAM_SLA_Combined AS a LEFT JOIN
vw_TFAM_SLA_Combined AS b ON a.ticketid = b.ticketid AND a.rn = b.rn - 1
WHERE     (a.SetStatus = 'Submitted' OR
a.SetStatus = 'Acknowledged' OR
a.SetStatus = 'Pending')

GROUP BY a.TicketID```

If i remove the call to the function [CalcMinutesSLA_TFAM] or the b.rn - 1 it works fine.

Here is the code for the function:

`CREATE FUNCTION [dbo].[CalcMinutesSLA2`

### The file reached the maximum download limit. Check that the full text of the document can be meaning

Hi,

I'm facing an issue with the indexing.

I have 1 WFE+Index server+DB server.

Index server is not installed with MS FIlter pack 1.0

When crawling, the there will be document with warning in crawl log:
The file reached the maximum download limit. Check that the full text of the document can be meaningfully crawled.

Documents that with warning are such as doc, ppt, xls, docs, ppts and many others.
However, I view into the successful crawled document, there are doucments with ext doc and ppt.

For large file index, there are MaxGrowthFactor + MaxDownLoadSize required to be added into the index server.

As my understanding is, MS Filter Pack should installed into index server(already did, correct me if i'm wrong).

I looked into the Office SharePoint Seach(CA>Services in farm), if the server is appointed to "Use this server as indexing server", then MS Filter Pack is suppose to be installed into that particular server as well.

At the bottom, there also has another option is "Use all web front end for crawling".

The question here is, IF the option "Use all web front end for crawling" is selected.
Does the WED FRONT END Server required to installed the Ms Filte

### RequiredFieldValidator minimum 6 number

Hi,This my code:<asp:RequiredFieldValidator ID="RequiredFieldValidator2" ValidationExpression="^[a-zA-Z0-9]{6,}\$" runat="server" ControlToValidate="CreditCardNumber"  ErrorMessage="Stevilka kreditne kartice, ki ste jo vnesli, ni veljavna!"                 ValidationGroup="ErrormessageValidationGroup">!!!!!!</asp:RequiredFieldValidator>ValidationExpression not works! The condition must be at least 6 numbers before it is implemented.thanks

### Windows UDP Socket Buffer (Maximum)

I am receiving on a socket (C#) and setting the UDP buffer size to br 10 Mb - and creating 16 such sockets. But I see missed UDP packets (they have  a unique seq number in them). When I read back "ReceiveBufferSize" it return the size I set it to - 10Mb.   My question is - what is the maximum internal socket buffer size allowed by Windows (Win Server 2008) ?   Wierdly when I also start Netmon in the background on the receiving machine - I do not see any missed packets.   Does Netmon modify internal windows socket buffers (increase them) - how can I go about doing this with my app ?   Thanks

### problem on Page_PreRender with RangeValidator control and programmatically setting Maximum and Minim

I am new to the ASP.NET /C# dev. I run into a weird bug when using the RangeValidator Control inside a Formview. I have my DateTime field with validator and it work fine until I submit the page, it actually insert the row into the database but then when the page reload I get the following exception.Server Error in '/Budget' Application. The value '' of the MaximumValue property of 'RV_AjoutUtilisateurDate' cannot be converted to type 'Date'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: The value '' of the MaximumValue property of 'RV_AjoutUtilisateurDate' cannot be converted to type 'Date'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [HttpException (0x80004005): The value '' of the MaximumValue property of 'RV_AjoutUtilisateurDate' cannot be converted to type 'Date'.] System.Web.UI.WebControls.RangeValidator.ValidateValues() +1077011 System.Web.UI.WebControls.RangeValidator.ControlPropertiesValid() +12

### Temp DB occupies maximum space

I am having issues with temp db space, which grows very large every week, I heard shrinking temp db is not a good idea to do, which I am doing it now temporarily to shrink the space, can someone help me how to troubleshoot not to increase the temp db space, I am using #temp tables, cursors, unions and indexes on some of the temp tables in sp's, does it make any difference if i drop the temp tables and indexes after the proc ran successfully?.

### How to get in which shift the maximum of time the employee falls?

DECLARE @CheckInTime AS TABLE(EmpID INT, InTime DATETIME, OutTime DATETIME) INSERT INTO @CheckInTime SELECT 1, '1900-01-01 00:50:00.000', '1900-01-01 08:50:00.000' UNION ALL SELECT 2, '1900-01-01 09:45:00.000', '1900-01-01 14:45:00.000' UNION ALL SELECT 3, '1900-01-01 14:20:00.000', '1900-01-01 22:45:00.000' UNION ALL SELECT 4, '1900-01-01 08:30:00.000', '1900-01-01 06:45:00.000' --SELECT * FROM @CheckInTime DECLARE @ShiftMaster AS TABLE([ShiftID] [int], [Name] [varchar](50) NOT NULL, [StartTime] [datetime] NOT NULL, [EndTime] [datetime] NOT NULL) INSERT INTO @ShiftMaster SELECT 1, 'G', '1900-01-01 09:30:00.000', '1900-01-01 22:00:00.000' UNION ALL SELECT 7, 'F', '1900-01-01 00:00:00.000', '1900-01-01 08:00:00.000' UNION ALL SELECT 8, 'S', '1900-01-01 08:00:00.000', '1900-01-01 16:00:00.000' UNION ALL SELECT 9, 'T', '1900-01-01 16:00:00.000', '1900-01-01 23:59:00.000' There is no relationship between @ShiftMaster and @CheckInTime. Here emp 1 should comes in F shift. He also falls in S shift. But he works more than F shift when compared to S shift Here emp 2 should comes in G shift Here emp 3 should comes in T shift (because he works more time in T shift) Here emp 4 should comes in S shift I wants to get (ShiftID) in which shift he works for more time. Thanks, Babu Kumarasamy.

### How to set minimum length of chars ina text box

I have a textbox1, want to set a minimum length of atleast 8 chars, how to do the min length validation. Thank you for thhe helpful info.

### Maximum Number of Processor Cores in CLR

Is the maximum number of processors (cores) supported by different versions of the CLR documented somewhere?  I'm working on an application hang problem and I can see in dumps that a thread is waiting in mscorwks!ThreadpoolMgr::RecycleMemory for a flag whose address was calculated by using the processor number as an index.  I can't see the index in the dump, but the machine has 48 processors and it looks as though the array containing the flags can accomodate only 32 processors, so the thread might be waiting on something beyond the array. Another clue is that there are only 32 GC threads, so I'm suspicious that this CLR will only scale to 32 cores. The CLR in use is the 32-bit version of 2.0 running on 64-bit Windows 2008 SP2.  I'd like to see whether there is a restriction on the number of processors in that version and, if so, whether there is another version that would support more.

### The maximum string content length quota (8192) has been exceeded while reading XML data.

Hi, I have been working on implementing a WCF service and have run into this problem with the maxStringContentLength.ÃÂ  I have read a bunch of posts here on how to correct it and none of them have worked.ÃÂ  I have updated my web.config in my local IIS5 published service to be maxStringContentLength="2147483647" and have updated my application's app.config to be maxStringContentLength="2147483647".ÃÂ  I delete all DLL's, rebuild, restart IIS, make sure all VS 2008 virtual webs are stopped, republish multiple times...even reboot my machine and I continually receive the following error message:The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/qlStatement. The InnerException message was 'There was an error deserializing the object of type System.String. The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuotas object used when creating the XML reader. Line 171, position 35.'.ÃÂ  Please see InnerException for more details.I am running the service on my local machine: Win XP SP2, IIS5, .Net 3.5, VS 2008Here is my WCF service's servicemodel section of the web.config: ÃÂ ÃÂ  <system.serviceModel>ÃÂ ÃÂ ÃÂ  <bindings>ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <wsHt

### Minimum Permissions Needed To See Cdc tables In System Tables Folder

What are the minimum permissions needed for a user to see the cdc tables in the System Tables folder in SQL Management Studio?DJ Baby Anne's Biggest Fan................

### Cannot create a row of size 8068 which is greater than the allowable maximum of 8060

SQL2K5, SP3, both DB's in 2005 compatability mode. I have the same table in two DB's, that are on the same server. The table in both DB's appears identicle. However, on one of them we get the above error when attempting to do an Insert into the table, and one of them works fine. In 2000, the answer was to "use TEXT", but per BOL 2005, that data type is going away. All ideas are appreciated. CREATE   TABLE [dbo].[Complaint]( [ComplaintId] [int] IDENTITY(1,1) NOT NULL, [SourceId] [smallint] NULL, [MethodId] [smallint] NULL, [Location] [nvarchar] (50) NULL, [CurrentStatusId] [smallint] NOT NULL, [CreateDate] [datetime] NOT NULL, [CreateOpid] [char] (8) NOT NULL, [LastUpdateDate] [datetime] NOT NULL, [LastUpdateOpid] [char] (8) NOT NULL, [DESSiteCodeId] [smallint] NULL, [DESAdminId] [smallint] NULL, [Narrative] [nvarchar] (max) NULL,   CONSTRAINT [PK_Complaint] PRIMARY KEY CLUSTERED ( [ComplaintId] ASC )   WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] )   ON [PRIMARY] GO insert   into [dbo].[Complaint] (   Narrative,CurrentStatusId,CreateDate, CreateOpid ,LastUpdateDate,LastUpdateOpid) values   ('abc' ,1,current_timestamp,'dennis',current_timestamp,'dennis' ) TIA, ChrisRDBA

### Database Mail configuring the maximum mail size (not attachment 'MaxFileSize')

Hi can anyone tell me if it's possible to configure the maximum size of an email when using database mail?  I know it's possible to use sysmail_configure_sp to set 'MaxFileSize', I want to prevent an email being sent the size of the body of the email is very large. In my case the body is based on a query result set inserted as html. Thanks