Steven Benjamin's Q&A profile

• Visual Studio MS ANtispyware blocks unit test tool

  Hi All, Have any of you experienced problems with the Unit Testing facilities of VS.NET 2005 beta 2 (on a C# project) being blocked by MS Antispyware It appears that the environment autogenerates a batch file each time the unit tests are to be executed. I am not sure how to stop MS Antispyware from objecting to this each time I run the scripts. Please let me know if you have a workaround (that doesn't compromise the security of my machine). Than ...Show All

• SQL Server FullText catalog path in SQL 2K5 connectionString

  Hi, Is it possible to put FullText catalog of a database in the App_Data folder of an ASP.NET application If yes, how to specify this relative path in the connectionString Currently I use " AttachDBFileName=|DataDirectory| foo .mdf " in my connectionString. How to specify that the FullText catalog is located in " |DataDirectory| " (read App_Data) so it can be attached on demand as the primary database file is Thanks in ...Show All

• Visual Basic Shortcut for Dropdownlists

  I really like these DDL’s above the code to quickly create event handlers. This is the thing making VB superior to the C# IDE. The only thing I find a little disturbing is the fact, that I have to remove my hands from the keyboard. Is it possible to assign a Shortcut to switch between the DDL’s and the code If not, then I make it a wish for the next version Ctrl+F2 will move focus to the LHS dropdown where you c ...Show All

• .NET Development Datareader to arraylist

  Hi How can I copy the content of a SqlDataReader to an ArrayList My problem is that I want to create a function that returns data selected by SELECT statement, and I just want to open the connection, read the data and then close it again. I want then the data to be returned as an ArrayList. Because I can't close the connection in the function since I will lose the SqlDataReader, I can't return the SqlDataReader from the function and play with ...Show All

• Windows Search Technologies WDS not indexing email

  WDS is not index my email. I'm using Outlook 2003. In WDS I went to custom folders then to outlook. When I looked at the outlook subfolders there is a warning sign next to the two mailboxes I have opened with a message that the outlook mailboxes I selected is populated by an add-in program. I disabled all outlook add-ins restarted the computer and outlook. Then reindexed and still no email indexed. I'm using the Symantec AV 8.1 corp version. Tha ...Show All

• SQL Server How to remove ALL as a dimension member

  Is there a way to remove the ALL member that Analysis Services adds to each dimension thanks. In Analysis Services 2000 you can change AllLevel property of the dimension from Yes to No. In AS2005 you to navigate to the highest level in the hierarchy in your dimension and for the corresponding attribute you change IsAggregatable property from True to False. Edward. -- This posting is provided "AS ...Show All

• SQL Server Role Nesting

  Hi, I am developing the security in a sql database, and i am doing so in a hierarchical way. In the white paper Row and cell security it says that we must add the child role as a menber of the parent role, but when you are in the role section you can not add roles as menbers of another role, so what i did was give the parent role ownership over the child role, it seemed logical. So i build a admin    &nbs ...Show All

• .NET Development JIT Compilation optimizations

  This is a bit of an overkill question I know but it was bugging me.... I just read that the JIT compiler runs a one-time-only optimization on installation based up various factors of the machine is on .. cpu type, memory, OS etc. If, for example, I install a program written in a .Net language and then add some more memory to the machine, would it be best practice to uninstall the program and re-install it so that the JIT compiler takes int ...Show All

• SQL Server SQL Server mobile installation

  What is the version number for the SQL Server mobile edition that is shipped with the RTM release of VS 2005 Where exactly can i find the installation for it (either within the VS 2005 installation folder or independently on any site) The VS 2005 RTM that i download only consist of "sqlmobile30devtoolsenu" in the following location : - dvd1\vs\wcu\SQLCE I could not find the installation for SQL Server mobile. However, the readme files say that ...Show All

• Windows Forms Windows Forms Book

  Hi I am looking to purchase a book on Windows GUI in C# as I start learning how to program in this new environment.  And I was wondering if any one has any suggestions   Neil FWIW, I am really loving all four books:  ...Show All

• Visual FoxPro similiar fields

  Hi I'm trying to cross reference records from two different databases by first and last name. I can pull most the records (about 1500 out of 1700) on straight forward comparison of (a.firstname = b.firstname) and (a.lastname=b.lastname) as for the rest, is there a way to check if one name is similiar to another (in case of a typo, or mis-spelling of the name) Thanks, Mike Not ...Show All

• .NET Development TableAdapter.Fill clears datatable

  Hello! I have a typed dataset with a datatable that is filled by a stored procedure. The stored procedure has an input parameter. I want to fill this datatable by calling the fill method two times with different input parameters. The first fill-call works fine, but after the second fill has finished, I just have to output of the second run in my datatable. The datarows from the first run has been deleted. The online help says, that records shou ...Show All

• Visual C++ Writing a Music Player that supports MIDI Instruments

  I want to write a Music Player that can play MusicXML files. These have information about them that can be used for conversion into MIDI, such as what instrument each part should use. However, in conversion to MIDI lots of information is lost, like crescendoes,diminuendoes, and emphases. I want to write a Music Player that can play these files, keeping this information in, but use the MIDI instruments. Is this possible, andd can anyone give me a ...Show All

• SQL Server SQL Server 2005 fails to install!

  I have repeatedly tried to install SQL Server 2005 Beta for some reason it keeps exiting with a datastore error. I will have to mention that i had previously installed the SQL Server 2005 successfully on the same machine except i had far too little space on C and had plenty on D so in order to move the installation to D i uninstalled and I am now trying to install it on D. Any help is much appreciated. The error I keep getting is datastore ...Show All

• Visual Basic VB 2005 Compiler Optimization Discussion

    There's been something percolating in the back of my mind. I come from a computing environment that preceeded windows and the Intel Architecture and instruction set. n comparison to the instruction set that i'm used to, the Intell instruction set looks like a house wreck which may or may not be important to the discussion at hand. Everyone knows that moderators agree on everything and that in moderator space we just stand in love ...Show All