SmallCompanyProgrammer's Q&A profile

• SQL Server Getting rid of #temp tables without restarting SQL Service

  If you create a #temp table on stored procedure  #1 and then call another stored procedure #2  from #1; if stored procedure #2 has an error in it, the #temp table will not release even though stored procedure #1 has a drop table statement in it. Hi Steve, Can you elaborate on what you mean by "release" The temporary table should exist for the context of Procedure #1 until Procedure #1 is finished executing. The only time you might see the temp table is if you accidentally created it before executing procedure 1. You could include code in procedure #1 to drop the temporary table if it exists at the beginning of the procedure: IF OBJECT_ID('TEMPDB..#Test') IS NOT NULL BEGIN PRINT ' ...Show All

• Windows Forms Open close save

  Hi i realy need help i want to create a alternative to word but my save featcher dose not save the things in my text box how do i set it to save the text box please help me Giggig guy Could you show any sample code of your save feature, psuedo code even. Without it no-one here will know how to answer your question. Do you mean you has established a format which allows the user to put textboxes on the page but when the file is loaded the text is not within the object or do you simply mean saving the text the user types into the textbox to a file as plain text You could mean many things, however if you just wish to act out the latter then here is a minimal amount of code to help... // 'path' should contain the full path inclu ...Show All

• Windows Search Technologies Search result appears in "Indexed Locations" but not in "Everywhere" on Vista

  My custom protocol handler is finally working to the point where I can search for keywords indexed from a custom store and get the appropriate results back. BUT, this only works if I search specifically in "Indexed Locations". If I go into the search textbox in the start menu and just type in a search term, it searches by default in a location called, "Everywhere". This location should be a superset of "Indexed Locations", but search results for items indexed via my protocol handler do not appear here. They only appear if I actually NARROW the search to look only in indexed locations. Can someone explain why this would be the case, and how I can fix my code so that my results appear when a user searches ...Show All

• SQL Server INSERTING Data From Server to Server

  hi there! Well i have two Servers on this two Servers i have the Database with the same Tables. But the Database in the Server_2 consists no data, I want to fill the Tables in Server_2 from the Data in Server_1. What i want to do is to is liked this. -- I performing this on the second Server. SET IDENTITY_INSERT [Server_2].[Database].[user].[Table] ON INSERT INTO [Database].[user].[Table]({COLUMN_NAMES}) SELECT * FROM [Server_1].[Database].[user].[Table] WHERE id=25 SET IDENTITY_INSERT [Server_2].[Database].[user].[Table] OFF This did not work and i have the following Error Message its in German but the ERRORCODE is 7391. I already check out the help section in MSDN but it doesnt really helps... Any Ideas Thanks Die Oper ...Show All

• SharePoint Products and Technologies The event receiver context for Workflow is invalid

  Has anyone experienced the error:- The event receiver context for Workflow is invalid - appears in the error log after starting a statemachine WF - there's no error in MOSS and I can step through the onworkflow activated and create task events without error This WF is attached for review of a page and when viewing WF status it reports failed on start. Any help appreciated! I have taken the statemachinedemo (sharepoint wf sdk) initiation form (and customized it) to make use of the user authentication controls (dont know which control/activex control this is, anyone know ) to validate the user (windows authentication) - the error has gone away, so I assume the WF couldn't assign a task ...Show All

• Visual C++ Any interest in building an FAQ?

  I'd like to propose that we put together an FAQ to address some of the issues that pop up regularly here. It seems like we have an awful lot of questions like: - "How can I call my C#/VB/FORTRAN routines from C++ " - "How do I compile and run my project " - "I've included the correct header files, so why am I getting LNK2019 errors " - "How on earth am I supposed to use destructors/finalizers/IDisposable " And of course these are all valid questions! But since they are common questions which tend to be answered in the same way from one thread to the next, I think it would be very helpful to have all (or at least most) of the common answers in one single place. This would be helpful both to aske ...Show All

• Smart Device Development TAPI

  Does anyone know how to access TAPI for a smartphone or CF. I want to make a program to fax something from my Q. Use Process Invocation ("P/Invoke") techniques on native API. TAPI has been described at: http://msdn2.microsoft.com/en-us/library/ms835755.aspx so, you can go from there. Be careful with Marshalling. ...Show All

• Visual Basic ListBox & StreamWriter & StreamReader

  I have a "Form" with: 1- List Box 1- TextBox 3- Button 1- OpenFileDialog 1- SaveFileDialog I want that clicking the btn1 it shows the OpenFileDialog and read file that it has got this structure: SKI1 0 1 7 1 0 0 18 10 1 19 0 29 10 1 30 0 40 10 1 41 0 50 10 1 51 0 62 10 1 63 0 81 10 1 82 0 95 10 1 2 0 0 95 16 5 3 0 1072 0 1 4 2 1 93 15 I want that it reads all  Line of the File and it add an Item in ListBox for line. For example the first Item of the ListBox in this case is SKI1 And the 2th Item is in this case. 0 1 7 I want using the StreamReader classes. And i want that when i click an Item of the ListBox it shows the Text in the TextBox and I can edit the Line and that clicking antoher but ...Show All

• Smart Device Development Hands On Lab Code

  I have looked all over for the accompanying .msi installer for the the Microsoft HOL titled "Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005". Can anyone tellm me where I can download the file from so that I may do the lab Thanks! No, there is a mobile database script that it asks you to run during the step by step. I've been looking for the code too, but haven't been able to find it. ...Show All

• SQL Server SqlCacheDependency - Notification Services Not Working

  I have an app that uses the SqlCacheDependency with SQL Server 2005, but when I try to run the app, it gives the exception: An exception of type 'System.Web.Caching.DatabaseNotEnabledForNotificationException' occurred in System.Web.dll but was not handled in user code Additional information: The database 'My Db Name' is not enabled for SQL cache notification. To enable a database for SQL cache notification, please use the System.Web.Caching.SqlCacheDependencyAdmin.EnableNotifications method, or the command line tool aspnet_regsql. To use the tool, please run 'aspnet_regsql.exe - ' for more information. Now I'll reiterate that this is SQL Server 2005 the instructions given in the exception (using aspnet_regsql or SqlCacheDepende ...Show All

• .NET Development Using VB.NET UserControl from VB6

  Hi I have a VB.NET usercontrol that contains a toolstrip, on that toolstrip I load in runtime 9 toolstripbuttons by code: tsToolBar.Items.Add(tsButtons(i)) AddHandler tsButtons(i).Click, AddressOf tsButtons_Click I declare at start of the usercontrol : Public event ButtonClick() -this event I want to use in VB 6. How and where I have to raise this event (ButtonClick) that it have same behavior as click on a toolstripbutton Could anyone help me with that Thks Avy Try this: Private Sub tsButton_Click(ByVal sender As Object, ByVal e As EventArgs) RaiseEvent ButtonClick() End Sub ...Show All

• Visual Studio Team System windows not found iexplore.exe

  I'm trying to add a "Web Test..." to my test but appear: ..windows not found iexplore.exe. Check the source.... (Windows no puede encontrar el archivo: iexplore.exe. Asegurese que la ruta y el nombre del archivo esten bien escritos...) Yes, I have Iexplorer intalled in C:\Archivos de programa\Internet Explorer\IEXPLORE.EXE Maybe, I need change or configurate the root.... I don't know! Thanks! ...Show All

• .NET Development How to change the application priority

  Hello, i would like to change my app (main thread) priority. So i tried to: System.Threading. Thread .CurrentThread.Priority = System.Threading. ThreadPriority .AboveNormal; However if i run Task Manager, with priorities listed, no change is visible (priority remains normal). What am i doing wrong, please Thank you. I think this is what you are looking for.. System.Diagnostics. Process .GetCurrentProcess().PriorityClass = System.Diagnostics. ProcessPriorityClass .RealTime; Every process has a several threads. Cmo K.. ...Show All

• Visual Studio 2008 (Pre-release) Custom Transport question

  Hi, I am looking for some advice on writing a custom WCF Transport. I am using the June CTP UDP Transport sample as my starting point. I notic ed that each ChannelListener creates a new Socket and bind s to it. I would like to use the same IP and port for multiple Service Contracts on the server side like the following: ServiceHost service1 = new ServiceHost(typeof(InterfaceAImpl)); service1.AddServiceEndPoint(typeof(InterfaceA), whateverBinding, new Uri(“net.udp://localhost:8080/A”)); service1.Open(); ServiceHost service2 = new ServiceHost(typeof(InterfaceBImpl)); service2.AddServiceEndPoint(typeof(InterfaceB), whateverBinding, new Uri(“net.udp://localhost:8080/B”)); service2.Open(); First , the sampl ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Font troubles

  Im a new to XNA so please be patient with me. I'm feeling really frustrated trying to get my own fonts to draw on the screen.  Ive found classes that will take their example image and draw with those fonts.  But I dont want those fonts.  I want mine.  I know that I have to have an image with my letters of my font on it. And that image has to get parsed. Im trying to avoid having to create my own classes and tools to do this. So I downloaded the Bitmap font generater from Angle code. The classes I've found, both here in these forums and at angle code,  that suppose to work with this Angel code tool do not correctly parse the .fnt. At first I was getting exceptions. So I debugged through it and got passed that. But i ...Show All