MerleN's Q&A profile

• SQL Server Insert trigger for bulk insert

  In case of a bulk insert, the “FOR INSERT” trigger fires for each recod or only once Thanks, This option may have issues with performance if you enable during the bulk load operaton during the otherside of triggers, refer to the books online about Controlling trigger execution when bulk importing data. HTH ...Show All

• SQL Server Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

  I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx . I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1. Entering http://localhost/SQLMobile/sqlcesa30.dll diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics, SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0 Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler ...Show All

• Visual Studio Tools for Office inserting page breaks

  Hi all how can i insert page breaks programmatically. i have no clue for doing this. any help in this regard is highly appreciated. something like this document.Characters.Last.InsertBreak( ) or i am not sure. Thanks in advance We are talking about Word, I take it Look up the InsertBreak method in the object model Help files. An alternate possibility is set the PageBreakBefore property to True for the Paragraph object that should start on the next page. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA templates not showing up

  I can't get any of the XNA features to show up inside Visual C# Express. I read through the XNA FAQ and tried: Running Visual C# at least once before installing XNA Game Studio Uninstalling XNA Game Studio and making sure Visual C# isn't running when re-installing XNA Making sure my Visual C# Express is registered before installing XNA. None of it helps, I'm missing all of the Windows Game templates, and XBox 360 templates. Any ideas Are you using Vista That happens if you install XNA GSE incorrectly on vista. You may want to check out this link: http://letskilldave.com/archive/2007/02/08/Getting-XNA-Game-Studio-Express-to-run-in-Windows-Vista.aspx ...Show All

• Visual Studio 2008 (Pre-release) GetStarted on 2 machines

  Hi, all! Just tried GetStarted example ( IIS hosted ) on 2 machines . I changed only client.exe.config "localhost" to "computer.domain" in endpoint address, but seems that not enough because client fail with EndPointNotFoundException :" there was no endpoint listening..." . So what I need to change addditionally TIA Arkady Hi, Scott! Exactly , GetStarted work fine when client and service ( IIS hosted ) both on the same machine, but if I want to run client from other machine or try to open there in IE http://computer.domain/servicemodelsamples/service.svc both failed. I set code for tracing in web.config and opened service.svc in the IE on the same comp ...Show All

• SharePoint Products and Technologies Passing the Excel parameters to the backend

  I can define parameters in Excel Services, but I couldn't find any directions on how to pass those parameters to the back-end SQL Server relational database. Our users may see different set of data depending on their position. The Asia manager isn't allowed to see New York data for instance. I need to identify the user currently viewing the Excel sheet, and pass it's name as a parameter to the SQL server, so that SQL will filter out the data that the user isn't allowed to see. Is there an article out there that shows how to pass parameters to an SQL data source from Excel Services I ran the suggested command and got "Operation completed successfully", and restarted IIS. I now get an ...Show All

• Visual C++ where is my Modeless Dialog?

  hi, I just begin to learn MFC with VC6.0. today when I read the <programming visual C++ >5th and try to learn the Modeless Dialog ,I come across a problem, when I get the exe and double click it, i run ,but i can`t find my modeless dialog , is there any thing different between Modal Dialog and Modeless Dialog when they are created or displayed,for example , the create() ,OnInitdialog() any reply will be appreciated Modelless dialog is created using code, CMyDialog *pDlg=new CMyDialog;//created on heap pDlg->Create(IDD_MYDIALOG); pDlg->ShowWindo(SW_SHOW); Modal dialog is created on stack, CMyDialog Dlg;//created on stack pDlg.Domodal(); ...Show All

• Visual Studio Team System Merge by Work Items

  Hi I have 2 branches. 1 is production and the other one is development branch. After doing some development in the dev branch, i wanna merge it in the prod branch by work items. The option i get while merging is the changesets. I could have 10 work items and those 10 work items could further have 100 changesets in it. When i am selecting "what code" to merge, it would be very easy to go thru a list of 10 work items rather than goin thru a list of 100 changesets. Now, in TFS source control pane and on... Right click on some branch>>Merge>>on the Sorce Control Merge Wizard window; Is there a way i can customize the merge window to add an option of selecting Work Items during merging G ...Show All

• Windows Forms Urgent: NullReferenceException on the RenderControl method of the new Treeview web server control

  I get a NullReferenceException on the RenderControl method of the new Treeview web server control for ASP.NET version 2.0. The exception message is: "Object reference not set to an instance of an object." The stack trace is: "at System.Web.UI.WebControls.TreeView.GetImageUrl(Int32 index)\r\n at System.Web.UI.WebControls.TreeNode.Render(HtmlTextWriter writer, Int32 position, Boolean[] isLast, Boolean enabled)\r\n at System.Web.UI.WebControls.TreeView.RenderContents(HtmlTextWriter writer)\r\n at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)\r\n at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)\r\n at System.Web.UI.Control.RenderControl(HtmlTextWriter ...Show All

• Smart Device Development Screen Orientation

  Hello all, I recently went to a mobile development conference where I saw a demonstration where the developer could, in design mode, set the posititions of his controls on his Pocket PC app in VS2005, according to the screen orientation. I.e. He set the orientation to be landscape then arranged his controls, then changed the orientation to portrait then re-arranged the controls again. He then demonstrated how it remembered the positions of the controls based on the screen orientations of the Pocket PC. Has anyone got any information on this I need to do this on my app. Cheers Mark Macumber wrote: Hello all, I recently went to a mobile development conference where I saw a demonstration where the d ...Show All

• Microsoft ISV Community Center Forums How to connect two locations to better communication?

  How to connect two locations to better communication We have offices at two locations, and i m looking for VBA (outlook) to connect two locations for updates, (more than email). Pls let me know your ideas.. ...Show All

• Visual C++ cl.exe / option so that the name of the source file be not dumped ?

  Hello Is there some option of cl.exe so that the source file name be not printed out If doing : DOS> cl.exe /nologo myFile.cpp It dumps : myFile.cpp And I would like to not see this dump. Thanks Guy You can try " cl myFile.cpp > null ", but you will not see the error messages too. ...Show All

• Windows Forms Include the parent control when a child is cut / copied and pasted.

  Hi all, This is the final step in what became a rather involved process. The big picture is that I need to present a container control at design-time which does NOT clip its children. So yeah, I want for instance a child button control to be able to draw beyond its parent's bounds. I've gotten it to work by implementing an "envelope / hub" mechanism, where the hub is the above-mentioned container, and the envelope is its parent, another container which sizes itself to envelop the hub. When the user needs to "float" (ie. un-clip) the child button, it gets re-parented to the envelope and now has free reign to paint over the hub's bounds. All that to say, I have one final problem: when the hub is cut to clipboard, ...Show All

• Visual Studio 2008 (Pre-release) Reliable Sessions - The Image Transfer Demonstration

  Trying to download this sample application, but the zip file is corrupt. Has anyone managed to get a copy of this Can someone post it here Regards, Brett Hardman craig updated this sample for RC1,you can download this sample from here http://blogs.msdn.com/madhuponduru/archive/2006/06/19/637173.aspx ...Show All

• .NET Development relations, primary, missingschemaaction..... questions

  - - does missingschemaaction add missing stuff to DB or only inside the dataset - - when we fill dataset, don t tables in my dataset get filled automatically with primary keys, relations, foreign keys..and so on or do we have to recreate all those in the dataset again although they exist in the physical DB. Is missingschemaaction…supposed to fix the pb. - if we wanna define datarelation, primary key, foreign key…in the dataset, should we always have them first in the physical database or can we just add and define them in the dataset even if they re not in the physical tables in SQL server. How about primary key, can we define prmary key in dataset even if we don t have it in the real table in SQ ...Show All