Koen Vermeire's Q&A profile

• SQL Server How to find which stored procs and UDFs reference a column

  How can I list the stored procedures and user-defined functions that reference a given column I could search ROUTINE_DEFINITION in INFORMATION_SCHEMA.ROUTINES for '%MyColumnName%' but MyColumnName is not always unique. Thanks. You can try the sql server specific system table "sysdepends". Look it up in Books Online. I am not aware of an INFORMATION SCHEMA view that will help you in determining such references. ...Show All

• Visual Studio 2008 (Pre-release) VS 2005 RC compatibility

  Does it work with the Release Candidate or only with Beta 2 Ok after downlaoding the kit and reading what was called a ReadMe, I figured it out. It is explicitly mentionned it will not work with RC0. Shame on me :) ...Show All

• Smart Device Development WIFI signal strength detection

  Good day, Is there any way in which I can see what the signal strength is by using my vb smart device application I have found examples for normal VB.NET application but nothing for smart devices. My problem is that when I try and synchronise my SQL Server CE database on my mobile device and my SQL Server 2000 on the server over WIFI and there is no convereage it takes for ever, about 25 seconds, before realising it can do nothing and in stead ...Show All

• SQL Server Force Encryption

  I want to configure SQL 2k5 Express so that all connections are encrypted. I've found the documentation that gives the How-To steps, but I don't see the SSL option in the Network Configuration. Is this possible with the Express edition Do I need to do something special with the installation Thanks, OldSam Yes. It's possible. Use SQL Server Configuration Manager, right click on "Protocols ...Show All

• .NET Development Integrating perl and .net

  (1)I wanted to know whether it is possible to integrate perl with .net(the specific reson for integrating perl is that perl makes file parsing and searching,regular expression pattern matching extremley easily with the minimum amount of code) (2)I would also like to know whether i can use the Test::Harness module provided by perl to test the functonality of .net applications or routines.If it is possible, can somebody provide me with some exampl ...Show All

• Visual C# How to retrieve the key value of a listitem in C#?

  While adding a listitem to any listview, we can pass-on "key" value, but how to retrieve this key value back I could not find this, plz. anyone help me out. First up... you are adding a ListItem to a ListView Is this for a WinForm app or an ASP.NET one I ask because ListView's are used in WinForm apps while ListItems are used with ListBox's in ASP.NET. If you did mean ListBox and not ListView... Which key value do you mea ...Show All

• SQL Server Use Replication to Identify Updated Data?

  I am new to SSIS (though have a decent amount of experience with SQL Server 2000), and am trying to design a data warehouse and eventually a comprehensive reporting solution. Here is our setup: - We have ~150 studios all operating software which we designed (ie. we have control over the system that will be the Data Warehouse source). - All studios use merge replication back to Head Office (we maintain a duplicate of each of their databases). Fr ...Show All

• Visual Studio Tools for Office Modify LoadBehaviuor registry value with RegEdit?

  Hi, this message has got a looong story behind... From this post, you can understand that I've moved the registries from CURRENT_USER to LOCAL_MACHINE, as was suggested for letting a VSTO plugin to be installed to All the Users on a Machine. From that moment on, NONE could see anymore the plugin in the ComAddIn list: none has confirmed that it's due to this change, but I'm quite sure. Now, the problem: how could someone enable a plugin who was s ...Show All

• Visual C++ Setup was unable to create a DCOM user....

  Hi. When I try to Install VS6.0 …. Setup Error Setup was unable to create a DCOM user account in order to register ” ..\Program Files\Microsoft Visual Studio\Common\Tools\VS-Ent98\Vanalyzr\valec.exe” I couldn't Install VS6.0, What should I do Thanks. Are you running as administrator I suspect that you need to be administrator in order to install the Visual Studio 6.0. You should also note that Visual Studio 6.0 ...Show All

• Windows Forms Is this possible?

  Is is possible to have a C# app update text boxes in a webpage that I don't own For example if there was a webpage that had a couple of textarea input fields would it be possible to write a C# app that could put text into those textarea's Thanks.   Indian Ocean wrote: Yes, its possible but you have to use some WIN32 apis for that. Its a inter-application communication in fact. If you want to do ...Show All

• SQL Server SQL server upgrade hardware.

  I hope this is the proper forum to post a hardware/best pratice question. We currently have 2000 SQL soon to be 2005 on a HP DL 585 that has its own MSA30 drive shelf. It has its own 4 channel SCSI PCIX card with I think 512MB of cache. The MSA30 is filled with 14 U320 HD. We have a second MSA 30 comming. The DB size is 334GB. We have a set of tables that contain the data that is to be compiled and a set of tables that contain post compiled. ...Show All

• Visual C++ Problem compiling

  1>Compiling... 1>cl : Command line warning D4002 : ignoring unknown option '/errorReport:prompt' 1>X6Console.c 1>c:\Program Files\Microsoft Visual Studio 8\VC\include\string.h(141) : warning C4616: #pragma warning : warning number '6059' out of range, must be between '4001' and '4999' 1>Linking... 1>LINK : fatal error LNK1181: cannot open input file 'yt/.obj' Simple win32 app with a WinMain returning 'TRUE' and I get these erro ...Show All

• Visual Studio Tools for Office VSTO Outlook Calendar

  Is it possible with VSTO 2005 to build an add-in for outlook that will read all the appointments for a given set of users in an AD group and display them on my calendar.  I am looking for a way for managers to be able to view all employees calendars regardless of if the employee designates the appointment to be viewable by other. What you are attempting to do is a common request. You can assign permissions ...Show All

• Visual Studio Variable data in header not printing

  Wanted to start a new thread on this in case it was getting missed. http://msdn2.microsoft.com/en-us/library/ms252093(VS.80).aspx I am trying to print a document number in the header of a report. I am using the technique of referencing a hidden text box in the body that contains the data I want to show. In the header I have this: =ReportItems!txtShippingOrderNo.Value And in the body I have a "txtShippingOrderNo" textbox: ...Show All

• Architecture workflow systems differentiation

  I am doing research on workflow managements systems. Recently, I browsed thorough a website http://www.workflow-research.de/Publications/PDF/MIZU.ROAL-EIP(2000).PDF which differentiates all the workflow systems in two parts.One are autonomous type(funtional withour any other additional application software) and other are embedded one (which use other applications softwares to work with). Please let me now that workflow mangements sof ...Show All