MikeDelaney's Q&A profile

• SQL Server loading to SQL Server

  What is the fastest way I can load data into SQL SErver -- it seems to me it's with Bulk Copy and minimal logging. But that seems very slow when I look at Orace's Data Pump and DB2's LOADer. Does SSIS help here -- from what I can tell, you help me tons and tons on the ET part, but the L is what I'm wondering about... Never heard of this - is this a 3rd party tool What does it do and how does it do it ...Show All

• SQL Server SQLMobile replication to SQL Server 05 64bit

  I am looking at buying a new database server to run SQL Server 2005. I want to get 64 bit server, windows standard 64 and SQL Server 64. I already have an app I created that uses SQLMobile on a Windows Mobile 5.0 device. Will I be able to run this app if I move to the 64 bit or am I better off just staying 32 bit Assuming you are really asking if you can use merge replication between your SQL Mobile application ...Show All

• Visual Studio 2008 (Pre-release) Equivalent of WM_MOUSEACTIVATE?

  Hiya, Is there a WPF equivalent of WM_MOUSEACTIVATE If there is, I can't find it. I need to control whether a mouse click on an inactive Window: (a) activates the window and lets the click through, (b) just activates the window but eats the click, (c) doesn't activate the window but lets the click through, or (d) neither activates the window nor lets the click through. I cannot do the equivalent with OnPreviewMouseDown becau ...Show All

• Visual C# Why I can not get image from Northwind Database ?

  I can get image from my own database into picturebox but I can not do this with Northwind database. Please tell me how I can get image from this database. Thanks a lot [code language="c#"] //Original code ... //byteBLOBData = (byte[])(ds.Table[0].Rows[1][1]); //Should be 'Tables' not 'Table' and as the query //returned a single row, there is no Rows[1] ... byteBLOBData = (byte[])(ds.Tables[0].Rows[0][1]); //Original code ...Show All

• Visual Studio 2008 (Pre-release) ... like in Ruby

  Is it possible to extend int (simple types) to be able do something like in this code, written in Ruby 3.times { print "X " } For the moment, you have to write it like that: delegate void Procedure(); static class TestExtensions {   static public void Times(this Int32 subject, Procedure procedure)   {     for (int i = 1; i <= subject; i++)     ...Show All

• Visual Studio Team System Provider Endpoint on Application Use versus Server Proxy Endpoint on Application Use

  In the systems diagram, I have one System (CalculatorEnterprise) with two Sub Systems (CalculatorSystem and LoggerSystem). In CalculatorSystem, I have an endpoint named Web Service Provider on Application Use. In CalculatorEnterprise (the master System), I find that same endpoint is now a Server Proxy Endpoint on Application Use. Why is there this discrepancy in the naming Why isn't it named Server Proxy Endpoint in the CalculatorSyst ...Show All

• SQL Server Sql Server Management Studio and other client tools question

  Hi, I am familiar with sql server 2000 but new to sql server 2005. Couple days ago, I installed sql server 2005 on a server by choosing all possible options. However, after installation, I can only find programs-->microsoft sql server 2005-->configuration tools-->, and can't find any client tools I installed. I have to say that sql server 2005 is much different from sql server 2000, so I am totally confused. I even tried to use co ...Show All

• Visual Studio Tools for Office Custom Menu

  I created an Outlook AddIn which creates a toolbar and a custom menu. The Custom Menu (=CommandbarPopup) contains a few menuItems (=CommandbarControl). I setted the FaceId of each toolbarbutton and each menuItem. Each button on my toolbar has an icon, but the menuItems don't have icons, while I set the faceId's of the menuitems to the same faceIds of the toolbarbuttons. It's not that the faceId is an 'empty' icon. Does someone knows why ...Show All

• Visual Basic Where is the cd running?

  Hi I’m trying to find out how I can give a relative path. What I mean is, I want to put my application in a cd. The application has a button. When I pressed it, the program should open a file. Now I put a path where is the file like this: D:/myApplication/prog.exe The problem is that the cd drive can be different. What can I do   Does System.Windows.Forms.Application.StartupPath() help you T ...Show All

• Visual C# Help me to create a Order column! (.NET, SQL2000)

  Hi all, In Visual Foxpro i create a column Order that:      replace all myOrderColumn with recno() [myOrderColumn]                1                2                3        ...Show All

• SQL Server Exporting Stored Procedures to a file

  I have a need to export all of the stored procedures in a database to files on the server dirve. I know that this can be done through the management interface but I need a way to do it programatically. I need to have a script or stored proc that dumps all of the procedures to a defined location on disk. Does anyone know how this can be done Thanks! You can use SQL-DMO (in SQL Server 2000) or SMO (in SQL Server 2005) to do this. Plea ...Show All

• SQL Server what is the differecen between Reporting service and Notification service?

  What is the difference between the SQL server Reporting Service and Notification Service   Or is one contained (part of) the other thank you They are two different components. Reporting Services is an managed and ad hoc reporting product and includes a report designer, management tools, etc. Notification Services is a platform for building high scale notification applications. There is a some overlap in t ...Show All

• Visual Studio 2008 (Pre-release) Embed baseline alignment information into a custom control

  Hello, I have designed some custom controls for displaying math equations and now I want to be able to display math equations in Paragraphs. First I was thinking to embed the control in a Figure, but the problem is that I need to align the control with the surrounding text. The alignment should be at baseline if my custom control has one, or if the control doesn't have a baseline (for example a fraction) the alignment should be at center. How ...Show All

• Visual FoxPro newbie here...

  hi to all... i have a form named customers and i have txtboxes to input all information i needed. i have a grid that shows all the records in the table customer. works fine on loading. now, i have 2 buttons previous and next respectively. my codes are as follows: Previous Button: USE customer if not BOF() skip -1 thisform.refresh() if BOF() go top endif endif Next Button: USE customer if not EOF() skip thisform.refr ...Show All

• Visual C++ CDaoDatabase class

  Hi, I am using CDaoDatabase class in VS7.2 and its work perfectly. Now I want to compile this application in VS8.0 for Windows 64 Bit platform and get this error-  fatal error C1189: #error :  DAO Database classes are not supported for Win64 platforms What should i do for this Manoj Jangid you would create a DLL that has all functionality relating to DAO. Then you would export several functions (using __ ...Show All