Brent Scott's Q&A profile

• SQL Server Max Concurrent Threads for SRS1.0 SP2

  How many concurrent threads will SRS 1.0 sp2 spin up to handle concurrent subscriptions Is the alogrythm documented anywhere It appears that changing the MaxQueueThreads from zero(Default Value) should have an impact on the number of threads. If so are there any MSFT best practices around changing this setting Thanks After a little research, it looks like the main inputs into MaxQueueSettings are # CPUs and amount of free RAM...Thinking more about this, I suppose you could just use perfmon and watch the number of threads reportserverservice.exe and/or w3wp.exe spins up during heavy subscription activit ...Show All

• SQL Server Unwanted datatype conversion with Named Queries on Oracle ds?

  I am working on SSAS05 with an Oracle ds., connected with Native OLE DB / MS OLE DB Provider for Oracle. The "normal" datatype of the table keys in the .dsv in the property window appears to be System.Int64. If I create a Named Query the datatype of the key of the Named Query table is automatically changed to System.Decimal. The effect of the change to Decimal is that now I cannot join the table with any other in the dsv because I get: "The my_source and the my_destination columns have different datatype" and the join is not made. A solution is to change ALL of the tables in my dsv in Named queries, which I d ...Show All

• SQL Server SQL Server 2005 express maximum database quantity and size?

  I whant to now how many database of 4GB is alow in 1 instance of SQL Server 2005 express. Is it 1 of 4GB, 2 of 2GB etc... The 4GB maximun is it for the instance of the server. Tanks ...Show All

• Visual Studio how to change obj folder to common folder

  i am changing my csproj to change output folder ton bin folder (shared by all other projects) even i defined BaseIntermidiateOutputpath < BaseIntermediateOutputPath > $(OutputPath)\obj\ </ BaseIntermediateOutputPath > still its generating some of the resource files under project folder. any idea Thanks, Sajjad the files its generating are gui resources Progject.csproj.GenerateResource.Cache ...Show All

• Visual Studio Express Editions VB6 to 2005 Control Arrays

  Can someone please tell me a little bit more about Control Arrays after upgrading VB6 to 2005 There are 7 images which use the same click sequence, and they are all named Card. The following is a sample of the code: VB6: Private Sub Card_Click(Index As Integer) If Card(Index).Picture = Image2.Picture Then Safenum = Safenum + 100 Card(Index).Picture = Pile(1).Picture Call Nextmove Call Enemymove Exit Sub End If End Sub VB 2005 after conversion: Private Sub Card_Click( ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles Card.Click If Card(Index).Image.equals(Image2.Image) ...Show All

• .NET Development Adding records

  Help!! I am trying to add records to a database i have a visual 2003 app that has a bunch of text boxes where i have it adding the information from the text boxes into the table and it works however I want to upgrade to visual 2005 and the same syntax doesnt work and i cannot find any examples or understan how to do this same function here is what I got can someone tell me what I am doing wrong i have a dataset, binding source and a data adapter this .Validate(); this .bsTraker.EndEdit(); this .daCust.Insert(txtFName.Text, txtLName.Text, txtAdd.Text, txtCity.Text, txtState.Text, txtZip.Text, "222-2222" , txtEAdd.Text ...Show All

• Visual Studio Express Editions Printing a form

  I am having a problem with printing - when I was usin VB6 about three years ago this proved to be a relatively simple process to print the information I wanted. Click on a button and using Printer.Print and Printer.Current x etc I could format the output. I have now been given VB2005 express and this method is not supported any longer, I've tried the help but can't get the examples to work - can anyone help with a simple straightforward explanation on how to do this now - if you can it will be very much appreciated. my thanks in advance adebarnecutt Hi adebarnecutt, You can start with these p ...Show All

• Visual Studio Visual Studio 2003 debugger stops after start now that 2005 is installed

  Hi all I am having a very tough problem. Since the RTM version of 2005 was installed side by side on my dev machine, I can no longer debug anything. The debugger sometimes comes up, may stop on a break, but quickly stops, and the asp.net web page continues running, but the IDE is returned from a debug state to an edit state. I did a MDM reset as per another thread,mdm.exe /regsvr to no avail. This is killing my productivity, does anyone have any idea how to restore the debug functionality for 2003 Thanks ! Well, I'll post this here to save someone some time, it only took me 3+ hours to solve! Yikes, ...Show All

• Visual C++ Can't override ToString().

  I have the following class: #pragma once using namespace System; namespace AutoTickets { ref class Model : System::Object { public : Model( void ) : M_model( "" ) {} Model(String^ model) : M_model(model) {} property String^ model { String^ get() { return M_model; } void set(String^ p_model) { M_model = p_model; } } virtual String^ ToString() override { return M_model; } private : String^ M_model; }; } For some reason ToString() is not being overriden. I have other classes that do the same thing and work fine. When I c ...Show All

• Windows Forms ListBox is really slow on adding about 64000 items

  so, this is a problem - adding about 64000 into ListBox takes about 2-3 seconds.. my code: David M. Kean - MSFT wrote: You might want to consider a different design that doesn't require a user to select from 64000 items. It's not usable. this list is some kind of dictionary index - filled with words.. with input box for quick searching - it is a common design as i think.. there are many programms with such design (different kinds of dictionaries) - and they are not so slow on startup :) may be they use some hacks to populate words' list .. ...Show All

• Visual Basic Copy file(s) to CD using new My Namespace

  I recently downloaded/installed VB Express version and really like it, however I was trying to do something which I thought would be very simple but have ran into a problem and cannot determine whether it is me or the product. I'm using the My namespace to have the user select a directory off of the maching using the FolderBrowserDialog and then using My.Computer.FileSystem.CopyFile to copy the files to the CD Drive. I get the following exception error: 'System.IO.DirectoryNotFoundException' occurred in mscorlib.dll I've searched the internet and Microsoft site and can find nothing regarding using the FileSystem to copy files to ...Show All

• Visual FoxPro Deleted records still getting fetched

  ok so I have deleted records in a VFP 6.0 table, and when I query anything the deleted rows still get pulled up, what am I doing wrong I should note that I need to be able to have them actually fully deleted via queries through .NET ...Show All

• Visual C++ VS2005 ColeDatetime::Format("%Y-%m-%d") generates error when date is prior to 1899-12-30

  ...though it is stated that ColeDatetime supports years from 100 to 9999. VS2003 has no such problem. The cause is in the CRT _expandtime function (strftime.c) which has following code. What shall I do to get rid of this error   static BOOL __cdecl _expandtime (_locale_t plocinfo, char specifier, const struct tm *timeptr, char **string,size_t *left, struct __lc_time_data *lc_time, unsigned alternate_form){ /* */ case ( 'Y' ): /* year w/ century */ { _VALIDATE_RETURN( ( timeptr->tm_year >=0 ), EINVAL, FALSE) temp = (((timeptr->tm_year/100)+19)*100) +(timeptr->tm_year%100); /* pass alternate_form as the no lead ...Show All

• SQL Server Data Encryption

  Hi, We need to set up a data export process from a SQL DB. The output (be it XML, Text Files or whatever) needs to be encrypted before it is FTPd somewhere. Is there support for encrption in SSIS How / where in the package designer would you achive this Thanks in advance. Martin There is no built in support for encryption of data. It would be an interesting custom task though if you fancy having a go. Otherwise, request this for a future enhancement at http://connect.microsoft.com -Jamie ...Show All

• Windows Forms associate ContextMenuStrip toToolStripMenuItem

  How can I associate ContextMenuStrip toToolStripMenuItem in VB2005 eg: To associate ContextMenuStrip to a textbox, we write this: me .textbox1.ContextMenuStrip = ContextMenuStrip1 Please help . Hi, Looking at existing applications I don't think you can have a context menu for a single menu item. For example in Microsoft Word, right clicking on File | New will not show any context menu. However, you can associate a context menu with the MenuStrip containing the menu items. For example, in Microsoft Word, right clicking on the whole File | Edit | View ... menu strip shows the context menu ...Show All