e.d's Q&A profile

• SQL Server Principal 64Bit- Member on 32Bit

  Hi all, I've got two VLDBs on 64bit hardware platform + 64Bit-W2003K Std R2 + 64Bit SQL2005 Std Edition. If I set this guy up as the Principal, can I have the standby/member on 32Bit HW + 32Bit W2003 Std + 32Bit SQL2005 Will this actually work Regards, Uday Shivamurthy Theoritically I don't see any difference or issue in setting up this way, http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1015569&SiteID=1 fyi. ...Show All

• Community Chat Comicster

  Since I use every opportunity to promote my little freeware app, it'd be remiss of me not to post something in this new forum (thanks Joe). Comicster is an application to catalog your comic-book collection. I made it in Visual C# Express, with some help from Visual Web Developer Express for the web services. I started work on it back in one of the early CTPs of .NET 2.0, and still working on new features etc today. It has a whole bunch of interesting features, like a 'skin' system that uses plain text files with HTML and custom tags (like <#details>) that get replaced using a regex pattern to be displayed in a WebBrowser control. Internally it uses an ADO.NET typed DataSet to store its data, and it persists this by writi ...Show All

• Visual Studio 2008 (Pre-release) anonymous methods type inferring at assign time

  While assigning anonymous types like this: 118 Action < Rectangle , Color > DrawRectangle = delegate ( Rectangle r, Color c) 119 { ... it would be a really great to be able to rewrite it like this: 118 var DrawRectangle = delegate ( Rectangle r, Color c) 119 { Currently this will result in an error: error CS1811: Cannot infer local variable type from delegate or lambda expression The Action<A, B> delegate could reside within System namespace. Or is this already suggested and this just wont make it into the Orcas cheers, i guess this can be an answer for ur concern Yes, there is a difference between a lambda and a local of a delegate type. ...Show All

• SQL Server How to pass multi-value parameters to DDS (data driven subscription)?

  Using RS2005, how should multivalue parameters be stored in a database field so that a data driven subscription can properly read and use them I have so far had no luck using syntax of: 1) parm1, parm2 2) parm1,parm2 Do single qutoes need to explicitly wrap the values Can you please provide an example and a SQL INSERT statement using parm1 and parm2 to demonstrate what to store in the database field Thanks!! Is there an example of how to do this somewhere We use the report manager to create our data driven subscriptions today ... and I havent tried one of our reports with multi-value ...Show All

• SQL Server Dates

  Hi, I have date columns in my tables defined as smalldatetime. How do I perform a Select that will retrieve records with dates equal to the date selected in a calendar control as follows: < asp : SqlDataSource ID ="SqlDataSource3" runat ="server" ConnectionString =" <%$ ConnectionStrings:ReservationsConnectionString %> " SelectCommand ="SELECT [TIM_Time], [TIM_ID], [TIM_Valid_From] FROM [Times] WHERE ([TIM_Time] = @TIM_Time)"> < SelectParameters > < asp : ControlParameter ControlID ="Calendar1" Name ="TIM_Time" PropertyName ="SelectedDate" Type ="DateTime" /> </ SelectParameters > I ...Show All

• SQL Server Replacing Oracle sequencers

  I have migrated a lot of tables from Oracle to Sql server with Inspires SqlWays. In this process I created identity columns on my tables, instead of the sequencers used in Oracle. Now I need to go through all the code and remove alle the places where sequencers is used in inserts statements, but is there a simpler way All queries are like this: Insert into Tablename(myidentitycolumn, column2) Value(MySequencer.nextval, "Column2 data") - I can't just search and replace, because I don't have anything to replace with. There is no Sql server function that just tells it to use the next identity (like a getNextIdentityValue() ). And if I replace with blank, it still has the identity column in the insert statement which cause ...Show All

• Visual Studio Express Editions NEW to prgramming/VBE

  OK I'm having a hard time trying to get a program together, I thought I was clever enough to cut and paste here and there and to get the thing done. Well, I'm clever enough to see that I can do it, all the books and articles I've found aren't of much help, because I'm starting from scratch, don't care about the web and I have loads of string manipulations to do, basically I'm trying to build a custom log_files interpreter. So here is the questions: Were can I find decent documentation/books that I can source, document myself and get going THX to all that can answer or provide guidance PAOLO     Yeah but Carsten..... that's called Fortran IV :( Actually, I ...Show All

• SQL Server Divide by zero error only with top

  In the following expression, the query executes with no errors (there are sometimes 0's and nulls in IRON and ENERGY): SELECT * FROM gff2vg WHERE ( gff2vg . ENERGY > 0 and gff2vg . IRON > 0 ) order by IRON / ENERGY desc but when TOP is added there is a divide by zero error. Is there a way to avoid this SELECT TOP(64) * FROM gff2vg WHERE ( gff2vg . ENERGY > 0 and gff2vg . IRON > 0 ) order by IRON / ENERGY desc Thanks. The expression in the ORDER BY clause has nothing to do with the predicates. It just ensures that you don't get overflow error in case of 0. NULL values of energy or iron will get filtered because of your WH ...Show All

• Visual Studio Tools for Office VSTO2005- cannot save xls

  I've just created a very simple VSTO2005 Excel project. I am editing the xls in the designer, and I am not able to save the changes. I just get a warning message saying: "Cannot access whatever.xls" What's wrong with it Hi, It sounds like the file system is unable to write to the file for some reason. I'd try going out to www.sysinternals.com (recently aquired by Microsoft) and downloading the free FileMon utility. If you run FileMon, you will be able to see every attempt that is made to access the your workbook (and the result). Probably you will be able to deduce the problem from the log. Since FileMon logs all files, you'll want to stop logging immediately after trying the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. MaximizeBox -> ToggleFullScreen problem

  Hello, I want to give the user the option to play a game in window mode or fullscreen. The game should switch to fullscreen, when the window's MaximizeBox is clicked. In fullscreen mode three custom buttons appear to go back to window mode, minimize the game or exit the game. (during my tests they are also active in window mode) This is what happens: 1. The game is started in fullscreen mode or one of the custom buttons is used to go fullscreen: All the buttons work fine. 2. The game was in window mode and the MaximizeBox is clicked to switch to fullscreen: The exit button still works fine, the minimize button shows no reactions, the window mode button lets the game disappear. Its not even in the background. To see the game again ...Show All

• SQL Server Row yielded no match during lookup

  In SSIS. I am having trouble exporting records that don't match from a lookup transformation. I get the following error: Row yielded no match during lookup. I would really like to have a list of all records that did not match so that I could send an email of those missing rows Please give me solution with example Thanks I use a lookup often for different purposes. For example currently i'm using it to pull "Open House" information for Properties. Only a few of those have open house schedules - so what i do is i have two outs from Lookup - and they both go to Union All transform. ...Show All

• Windows Forms C++/CLI Windows Form Designer bug in causing an event handler to disappear

  I am not sure whether the following scenario is a bug in the Windows Form Designer as it relates to C++/CLI or some failing in my own implementation, but I hope someone can look at this before I submit it as a bug. The scenario is: I create a CLR class library project. I add a component class, let's call it CmpA. I add two virtual events to the component class, both of type System::EventHandler ^, let's call them EventA and EventI. I create backing variables for both events, let's call them bEventA and bEventI respectively, and use the long form of specifying the events. I also override the Equals and GetHashCode virtual functions. In the same assembly I add a UserControl. The user control, let's call it UserU, has a property, let's call ...Show All

• Visual C# Properties Question

  I have a C# Class but I am not sure how to do something, I am also working with ClassDiagram's so if it can be done there instead of code let me know how. this relates to shipping orders Class: ShipBoxes Properties: //First Package: PieceNum PackageWeight PackageCOD PackageDVal //second package PieceNum2 PackageWeight2 PackageCOD2 PackageDVal2 Is there a way to only have one set of properties then just add a second set of the same Properties Instead of adding a "2" or "3" etc Soi can have unlimited number of packages if needed I hope this makes sence. Tdar I got it thanks all, public class AddPackage { private Package _Box; public Packa ...Show All

• SQL Server MSDE 2000 Replication to SQL Server 2000

  i went through the documentation but i was not clear on following, here is the scenario :- a Central server is having SQL Server 2000 3 Remote Locations :- Each having 4-5 no of computers, connected on a Lan, and on one of the machines MSDE 2000 will be running. My Questions are :- 1. Can remote locations, update data locally and send changes (say in every one hour) to central server. If yes, then how 2. Same way they can receive updates from Central Server on whatever was updated on Centra Server or on the 3 remote locations. If yes, then How any help will be highly appreciable. Thanks for your answer. Kindly note that if in this same scenario, can we do the same thing, if followin ...Show All

• Visual C# OnUpdate equivalent?

  I come from the MFC world into c# and .net. In MFC I used OnUpdate commands (ON_UPDATE_COMMAND_UI) to handle enabling/disabling of menuitems, toolbarbuttons and other controls. From what I have seen there is no equivalent functionality in .net/c# So, I have two questions: 1 - Does Microsoft have a plan to implement this in upcoming versions of the framework 2 - Until then, what method is "best practise" for solving this in the world of .NET regards Andreas Dear Andreas, You should be reading this http://www.codeproject.com/cs/miscctrl/actionlist.asp Taking the example of a menuitem, lets say you have programatically added a menuitem to a MainMenu mMenu : mMenu.MenuItems.Add(new ...Show All