KeithGWilliams's Q&A profile

• SQL Server server can t find SP sp_MSforeachDB

  Hi if I do exec sp_MSforeachDB '......etc' and i get SP sp_MSforeachDB not found how do i reference it in order for the server to find it. Because when we check in master we find the SP there but when we run the exec sp_MSforeachDB ... we get SP not found any help pls Please don't use the undocumented system stored procedures. Those are unsupported. We will and can make any changes to the behavior and/or drop these stored procedures in any service pack, hotfix or major release. You should instead write your own SP using sp_executesql. This way you will not depend on undocumented techniques and do not have to worry about any break in the functionality. ...Show All

• Visual C# What makes C# better than VB

  hey friends, I am a Visual basic developer. I hear that every C# programmer says C# is better - stronger than VB . But when I ask the reason I can never have a strong answer :) . Is there some body can tell me the benefits of using C# rather than VB. What makes is stronger than VB I want to learn C# but I want to be convinced before I start .. Thanks a lot Ayhan I was a VB developer for 4 years. When C# arrived i switch immediatly. I see VB as a Windows XP but the first version. On top of it a service pack 1, and on top of it Service pack 2. So you have a XP with sp2. It is the same as clean XP with SP2 included. So what is the difference There is no difference, but we feel that they are not the same. What i have saw ...Show All

• Visual Studio Express Editions Unable to register product with Limited User Account

  I have my 'travel' laptop set up with a limited account that I use to do all my work. having downloaded VS C# (and Web Dev and J#), I am unable to register them as my limited user. It reports that the key is invalid (though the same keys work once I switched to the "administrator" user. The product was installed by the "administrator" user, but only shows as registered for that user. I am unable to register for the limited user. I can change permissions on various registry keys, but I'd need to know what to change. You can not use the same key for different users on the same computer. You will need to register each installation per user that need to use it. You can register using the ...Show All

• Visual Studio Team System External DB Synonyms Cause Compilation Errors

  Hello! I have a solution with two database projects in it. In both we use synonyms for any cross-database references, e.g.: USE [AdventureWorks] GO /****** Object: Synonym [dbo].[synNorthwindEmployees] Script Date: 11/23/2006 15:18:35 ******/ CREATE SYNONYM [dbo].[synNorthwindEmployees] FOR [Northwind].[dbo].[Employees] GO USE [Northwind] GO /****** Object: Synonym [dbo].[synAdvWorksEmployees] Script Date: 11/23/2006 15:25:26 ******/ CREATE SYNONYM [dbo].[synAdvWorksEmployees] FOR [AdventureWorks].[HumanResources].[Employee] The problem we're experiencing is that any view that uses a synonym for an item from the other database causes a compilation error when we build the solution. So if we have the following view in the Ad ...Show All

• Smart Device Development .NET Compact Framework v2 SP1 Patch for VS 2005 is now available.

  Q. What is that exactly A. This is a patch (as in difference between old version and new one) for NETCF V2 RTM which updates existing NETCF V2 installation to SP1. It is intended for VS 2005 users only. Q: I've copied this patch to my device, but it won't install. Is that because I'm low on storage memory A: No, that's because this patch is for desktop , not for device. Please install it on desktop, do not copy it to device. Patch would update original NETCF MSI (which is also for your desktop) to SP1 and VS would deploy changed NETCF CAB automatically. Q. Is there a difference between updating existing installation with this patch or uninstalling it and installing NETCF V2 SP1 MSI A. Technically no, final result ...Show All

• Visual Basic Accessing VB component property methods from C# application

  Hello Can someone help me for the below proble, I am working on a task of converting one vb6 application in .Net. Current vb6 application is using one vb dll provided by third party. I have written a code in C# and added the third party dll (developed in vb6) in the reference. The strange problem I am facing is that I am able to access all the properties of vb6 dll but not the methods of the property.One thing I do not know is whether the property datatype is collection or any other datatype. For example : TestClient.Client objClient = new TestClient.Client(); I am able access the "GenericBO' property of the objClient but not the "Item" method of the "GenericBO' property. In current VB6 the sam ...Show All

• Smart Device Development sending message

  hi, i want to create device application,that client(device) send a data(msg) to the server and invoke the webservice.The server get the data via clientwebservice.Any sample code related to this send me for me and the rest to understand, you wish to invoke a webservice method from client - is this correct If so, just add a web reference to the webservice in your project, then simply create an instance of it and invoke the methods you like, once invoked, the webservice will then take care of the processing for you, just as if you were writing and executing a normal C# class file. is this what you are after if not - can you explain a bit more in depth ...Show All

• .NET Development Problem with dropdownlist... and select query appending

    I have the datavbase which contains examid and exam name. I am appending in the select query as select exam_id +'  '+ exam_name these both and is showing in a dropdown list.. Let me tel.. i have exam id=70-A and name = web application... I need to show in the drpdwmlist as 70-A  webapplication Then i have another query which shd retrieve the exam id alone...frm the drpdwnlist(ie values based on the exam id (70-A)) How can i do that... May b its very simple.. Can any one plz help me.. its very urgent   Thanks. Hi, that is not the problem.. I thk my question is not clear... Let me tel.. i have exam id=70-A and name = web application... ...Show All

• Internet Explorer Development XP Pro/IE7 Updates break script encoder output!

  I have a web site which contains pages with encoded client-side javscript code, and other pages which contain encoded server-side vbscript code. (The encoding was performed with screnc.exe, the script encoding utility.) Since updating my desktop machine this month with the latest XP Pro updates and IE7, server-side VBScript encoded scripts won't run. (The server environment is 2K3Server Standard, with all the latest updates.) The javascript code still runs correctly on the client side (tested w/ IE6 and IE7), but server-side VBScripts result in a http 500 error. I suspected that this was a side effect of recent updates to the desktop machine upon which I run the encoder. To test this hypothesis, I boooted in to a Win2K Pro partition ...Show All

• Windows Forms Glass effects with .net

  Well, this is really a comment and a question: I posted a sample on .net (windows forms) and glass using the Dwm functions to do frame extend, sheet of glass, full client blur, arbitrary client blur - on my blog ( http://philiprieck.com/blog/archive/2006/07/21/GlassForm.aspx ) Just one problem: Anyone know of a fix for the "must paint black over glass" limitation that doesn't resort to using a WS_LAYERED (aka transparency key) window Painting black isn't really a problem - it's putting winforms controls on top of it - the background and foreground gets all messed up. Any help would be appreciated. Thanks, Philip That certainly seems to be true - hopefully GDI+ is better - but it l ...Show All

• .NET Development How can i kill the processes which are not on the task manager

  Hi to all... I want to kill a proccess.Normally i do this by; Dim prs As System.Diagnostics.Process() = System.Diagnostics.Process.GetProcesses Dim i As Integer = 0 While i < prs.Length prs(i).Kill() System.Math.Min(System.Threading.Interlocked.Increment(i), i - 1) End While and this works fine... But some procceses that i can not see by TASKMANAGER but by procexp.exe (which show system internals) programm shows some other processes which are running.. I want to kill some processes which are listed in this list... The method above only look for the processes which are listen in the Task Manager. How can we do this as a conclusion;I want to kill any proccess or thr ...Show All

• Windows Live Developer Forums Order update issue

  Hello adCenter team, Here is the problem we just encountered today: We want to update the names of some orders, but it doesn't seem to be as easy as calling the updateOrders method. First of all, it seems that adCenter does not support partial updates (at least not for orders!). We have to fill up almost all the fields in the AdCenterOrder even if we wanted to modify only the name of the order. In particular, we have to provide a new starting date for the order. But, if we do this and the order belongs to an active campaign, we get error -100837 ("Can not update the alive Order" - "The start date or budget type of an order cannot be changed once it has gone live."). Pausing the order and t ...Show All

• SQL Server Subscription without snapshot doesn't work

  Hi all, I'm very very frustrated with this problem, I used to give maintenance to my database replication, disabling distribution and establishing the publications and subscriptions again from zero. This way metadata were clean up, and I was sure of that. When I migrated to MS SQL2005 I can't do this anymore, because drop rowguidcol at subscribers and publisher. The DB average size is 15 GB. And now this weekend I found the problem where the subscription try to apply the whole snapshot (15 GB! ). I don't know what to do PD Sorry for my english. Sure, With MS SQL 2000 sp3: I'm using merge replication, and to make a clean up, I disabled the distribution for asure that the distrib ...Show All

• Visual C++ SAFEARRAY* & COM Interop

  I’ve got a C# library that I’ve built into a COM component that will be used from a VC++ 6 or 7.1 application and while the creation of the COM object side of things seem to be working fine, using the object fully is another matter. On the C# side of things I’ve got an object defined like so:       [ClassInterface(ClassInterfaceType.None)]       public class PID : IPID       {             private string type;             private int number;             private PID[] pids;               public string Type         ...Show All

• Windows Forms Autocomplete ComboBox

  Is there a way to set the size of the autocomplete dropdown You know when you type in a text in the combobox it will suggest come values in a dropdownlist. Can the size of the thing be set Thanks, AndrewVos wrote: You can't change the width of the actual comboBox rather It's a bit small for an autocomplete combobox IMO... the thing is that .. its only numbers .. between 0 and 59. So it won't make much sense .. to make it bigger as it can only hold a length of 2 ...Show All