Brendan Green's Q&A profile

• Visual Basic Using multiple ORs in an if statement

  Why doesn't using multiple ORs in an if statement work properly e.g whats wrong with this If results(1) = (cantbe(1) Or cantbe(2) Or cantbe(3) Or cantbe(4)) Then random1() End If It only checks cantbe(1) and cantbe(2) is there a way of getting around this I think you will find that evaluating a logical expression does indeed work otherwise Microsoft would have quite alot of bug r ...Show All

• Visual Studio Team System TFS Analysys Services service stops all the time

  The Event log is logging this error; The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexp ...Show All

• Visual Studio Team System automate build with beta 3

  this is what i wrote and it complaint team foundation can't start the build when i try to run it. localhost.BuildContoller bc = new localhost.BuildContoller(); bc.URL = @ http://localhost:8080/Build/v1.0/BuildController.asmx ; bc.Credentials = System.Net.CredentialCache.DefaultCredentials; localhost.BuildParameters bp = new localhost.BuildParameters(); bp.TeamFoundationServer = "VSTSBETA3"; bp.TeamProject = "myteamprojectname"; bp.BuildType = "m ...Show All

• SQL Server SqlServer SMO StoredProcedureParameter Bug?

  I'm creating a Windows Forms application which auto-generates my stored procedures for me. Based upon a column's DataType property I'm creating instances of StoredProcedureParameter as below: if (column.InPrimaryKey) { StringBuilder parameterBuilder = new StringBuilder ( "@" ); parameterBuilder.Append(column.Name); sp.Parameters.Add( new StoredProcedureParameter (sp, parameterBuilder.ToString(), column.DataType)); ...Show All

• Visual C# New code being ignored

  Hi there, I am newish to C# and am having an issue, I am making a code change in one project of a large solution in VS2005. When I attempt to debug the code, a dialog box comes up with the message that 'The source file was different from when the module was built'. I click yes to continue anyway, but the debugger appears to still see the older code. I turned off 'Require source files to exactly match the original' under Tools - Options - D ...Show All

• Visual C++ Avoiding compiler complains about redefine variables???

  Hi all: When I am writing C++ program, I need some global variables and structs to be visible from many files. But the compiler always complains that variable is already defined somewhere else. The problem seems to be caused by not #include file properly, but is there a good solution to avoid this irritating problem happen please Here is an example error message: Topology error LNK2005: "int COLUMN" ( COLUMN@@3HA ) already d ...Show All

• Visual C# parent - generic why not?

  How can use parentes with generic links I talk about this constructions: struct abc<tfrom>: tfrom {...} or class abc<tfrom>: tfrom {...} how to use this conversions and why tjis is not work class aaa<tc> { public aaa()  {   int a = 0;   tc b = (tc)a; // this not work   tc c; // this not work   // not exists any constructors like   // tc b = n ...Show All

• SQL Server Will lost update occur if transaction isolation level set to SNAPSHOT?

  Let's say if there're two transactions updating a column of the same row concurrently, will one of the update be overwritten by the latest one No an, error will occur: Msg 3960 , Level 16 , State 4 , Line 1 Snapshot isolation transaction aborted due to update conflict . You cannot use snapshot isolation to access table 'dbo.Test' directly or indirectly in database 'Adventure ...Show All

• SQL Server Read/Write Performance

  Hello, We currently run sql 2005 server and also sql express in our dev environments. We use sql express as an offline store (smart client). We have a similar/exact schema on the sql 2005 server and also the express. We use the auto attach feature to connect to the express version of the database. Both the developer machines and the one that is running the sql 2005 server have exactly the same hardware configuration. The only difference ma ...Show All

• SQL Server SQL Performance

  We have a huge database (over 30 GB on local env), and most of our tables hold over millions of records. We use dynamic SQL in one of our Search Stored Procedure but want to change it to normal SQL Procedure. The only problem is with Non-Sarogate syntax: SELECT ColumnX ..... FROM TableX INNER JOIN tabley ON TableX.C = TableY.c WHERE (surname = @surname OR @Surname is null) AND (firstname = @firstname OR @firstname is null) and 1 ...Show All

• SQL Server Dimensions with complex hierarchies ????

  Please advise... I have a dimension hierarchy that each member could have multiple parents and therefore the out-of-box ParentKey support in dimension would not be sufficient. Based on Mr. Kimball recommendation ( http://www.dbmsmag.com/9809d05.html ) I tried to use a linked helper dimension that has only ParentKey and ChildKey. However I am having difficulty utilizing it in the cube browser. The similary user experience we have with t ...Show All

• .NET Development Some of the files required for Web references are not installed.

  When I click "Add Web Reference", following error inoked. Some of the files required for Web references are not installed. VS Configuration! Microsoft Visual Studio 2005 Version 8.0.50727.26 (RTM.050727-2600) Microsoft .NET Framework Version 2.0.50727 Hi thats a great post.After that regsvr32 it worked for me. Thanks. ...Show All

• Visual C++ MSXML DOM memory usage

  One of the applications I'm developing requires the use of some kind of phone/address book. The address book requires to be persistent. The first idea was to use the registry, but it appears that in the typical scenarios in which this will be used, the address book can have as many as 65,000 - 70,000 entries and that would mean too much data in the registry. I'm evaluating the suitability of XML for this purpose and plan to use DOM to allow for ...Show All

• SQL Server calculate weekendings for a date range

  All, I have stored procedure that accepts 2 parameters (StartDate and EndDate). I need a way to find out which weekending dates fall between the two parameters . For example : StartDate: 02-jan-2006 EndDate: 19-jan-2006 Therefore the weekending dates would be 8-Jan 2006 and 15-jan-2006 Can anyone help Cheers Hi, look here: http://www.aspfaq.com/show.asp id=2519 HTH, Jens Suessmeyer. ...Show All

• Visual Studio Problems installing sdk for 2005 april

  I have VS2003 and VS2005 on my PC. I also have sdk march 2006 installed .Now I want to install sdk april 2006 but it fails because I don't have mshelp 2.0 . I can't even remove me prev version of sdk from the same reason. Don't know what it is and why I need it. Thanks Avi No solution here The error code is 1603 Avi ...Show All