Peter Gissel's Q&A profile

• SQL Server SQL 2005 scripting stored procedures

  I'm wondering if there is an automated way to script a large number of stored procedures to individual files, for later inclusion in a source safe project Preferrably they would have the same name as the sp in the database. In the sql 2005 studio, I can script them one by one, or a bunch of them to one file, but I can not see how to get them to individual files. Thanks for any suggestions. LT Hi, I do not test in SQL Server 2005 but SCPTXFR.EXE is a very good command line utility for it. It can be found in the C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade (SQL Server 2000) or x86\upgrade in SQL Server 2 ...Show All

• Visual Basic How I can know What is the user who start certain process?

  How I can know What is the user who start certain process I want to retrive the user name who started a certain process just like what appears in the windows task manager in the user name column how I can get this thank you all You need to use the wmi to get the processes and owners. There is an example on the vb-tips website . ...Show All

• SQL Server Can we download the DTS Designer?

  I am using SQL Server Express 2005 CPT April, and I would like to use the DTS Designer with it.  I have been looking for a download but have not found it yet.  Does anyone know where I can download it from or if DTS Designer is included in the tools that come with SQL Server Express   I haven't gotten those tools working yet. Thanks If you mean the Integration Services (we renamed for SQL Server 2005) then no it can not be downloaded for use with Express(this is the same story as MSDE in 2000). You should download the Developer, Std or Ent SKUs from June as the IS designer ...Show All

• Visual C# C# compiler...

  I am working through a C# Tutorial and it tells me to type: csc DrawingObject.cs Shapes.cs ect... however everytime I type csc it returns in cmd that csc is an invalid internal or external command. I have download and installed the .Net SDK, for I was under the understanding that this will allow a user to compile code in the command prompt. How can I get the SDK to compile or is there a free compiler out there that I can use for C# I would download C# Express by my work is sketchy about SP2 on ppls machines.  This is something I do hope to have come the new fiscal year, however in the meantime what can I do Hi, You need to ...Show All

• Visual C++ A problem about record voice with GSM format

  I developed a program to record voice with PCM format.It can work very well.Recently I need to record voice with GSM format.So far I know how to set the format because I refered the article from microsoft, these codes like below: pgsmwavefmt->wfx.wFormatTag = 49; pgsmwavefmt->wfx.nChannels = 1; pgsmwavefmt->wfx.nSamplesPerSec = 8000; pgsmwavefmt->wfx.nAvgBytesPerSec = 1625; pgsmwavefmt->wfx.nBlockAlign = 65; pgsmwavefmt->wfx.wBitsPerSample = 0; pgsmwavefmt->wfx.cbSize = 2; pgsmwavefmt->wSamplesPerBlock = 320; waveInOpen(&hwavein, (UINT)WAVE_MAPPER, (LPWAVEFORMATEX)&(pgsmwavefmt->wfx), (DWORD ...Show All

• Visual Studio 2008 (Pre-release) Can't uninstall WinFX beta 2 (specially WCF Components)

  Hello I have a problem uninstalling WinFX beta 2. During the uninstall i get a error EventType : wap10setup P1 : 13165 P2 : 3.0.03906.22_waprc0_x86_sfx P3 : mc P4 : inst P5 : f P6 : dd_ca_uninstallxwsregexe_x86.3643236f_fc70_11 P7 : 0 P8 : 1603 P9 : - P10 : windows communic I used the repair funtion(wich crashes also), but the uninstall problem stil exist When in look deeper in to the uninstall process i figured out that it is a problem in the Windows Communication Foundation Uninstaller. When in run "servicemodelreg /u" from the command prompt i get a message Are you sure (Y/N) y Uninsta ...Show All

• Visual Studio My package fails to load in VC++ Express 2005

  We have developped an editor package four our custom resource files that works perfectely in VS.Net 2003 and 2005. Unfortunately, despite I have changed my package registration so that it writes the keys under 'VCExpress' in the registry, my package fails to load in VCExpress. The error message is "Package load failure Package 'OxyEdt Pakage' has failed to load properly..." I have a valid PLK, and I checked that my package registers properly by using sysinternals' regmon. Is there some kind of restriction on 3rd paty packages under VC Express Thanks for your help -Reginald ...Show All

• SQL Server Cant locate SQL Server Express from client pc

  Hi, I have a 5 user network running SBS 2000. I have installed SQL Server Express on one of the client machines (not the SBS Server) I can connect locally without problem. However i cant connect from the other client machines. I have enabled TCP/IP, Remote Connections Etc I am attempting to test the connection using an .udl file. The server name is found but i still cant connect. Any help would be apreciated. Hi, the error message would be helpful for us. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Answer SQL Server 2000 DTS Tools Web Download

  Is the Web Download to install SQL Server 2000 DTS tools available yet If so where Thanks Darren Sometimes happen the same and even only appears the arrows. I had a lot of problems with this messing up my Sql2k Entreprise Manager. ...Show All

• SQL Server Restoring a Database from a .bak file

  From what I understand, you can restore a sql server database from a .bak file. I think you need to use the enterprise manager to restore this file and I am using the eval version of sql server 2005. Does anyone know if the enterprise manager is in this edition Or is there another way to restore the file without using the enterprise manager Thanks There is not Enterprise Manager on SQL Server 2005. The new application is Managment Studio which is the successor of SQL Server EM. You can also do it with this tool. If you want to do sit on your own (script) way, use TSQL for that. Look for the synta ...Show All

• Visual C++ Are there ANY advantages to using function pointers over regular function calls?

  Hello All, Can anyone please anyswer this question Are there ANY advantages to using function pointers over regular function calls This is for a friend of mine. I would really appreciate it. Thanks, Rosraj rosraj wrote: Hello All, Can anyone please anyswer this question Are there ANY advantages to using function pointers over regular function calls This is for a friend of mine. I would really appreciate it. Thanks, Rosraj Function pointers are not an alternative to directly calling a function. They are used for specific scenarios - for example as callbacks. So your friend's question is ...Show All

• Visual Studio Express Editions Random Numbers again!!!

  Hi there, i think i have gotten into a bit of a fix... here is the problem: i have used the random obj to generate random numbers between 1 to 90. some times when the application runs, it picks a number twice. for example an output would be 2,8,34,2,67.... is it possible to make sure all numbers picked are only selected once that is if i request for 10 ranadom numbers, each 10 digits would be unique... this is driving me nutts!! thanks 4 ur help Slow. Hi Slow, One way would be to keep a list of previously generated numbers, whenever a number is generated check the list, if th ...Show All

• Visual Studio 2008 (Pre-release) Concurrency/Throtting WCF Samples (Sept CTP WinFX )

  I'm seeing the following error when trying to run these samples. ObjectDisposedException: {"Cannot access a disposed object.\r\nObject name: 'System.ServiceModel.Channels.ServiceChannel'."} Hi Harini, The same error I am too getting when I try to access a WCF method in a client layer. Cannot access a disposed object. Object name: 'System.ServiceModel.Channels.ServiceChannel'. The above mentioned reply does not fix my problem. Please suggest. ...Show All

• Visual C# Parameters between UserControl[C#] and page

  Hello! I have a User Control embedded as object in a page. This User Control needs to write some data to back to the page, on a input control passed as a parameter when calling the method. Is there any way to do it The UserControl initiates a thread that gets some information and needs to post it back to the page (can’t return as a return of the calling method). Thanks for any help. As a general rule, Events would be the best way to handle this. In either case, you can't update a control from a thread other than the one it was created on - InvokeRequired is provided to help with this (and has a ...Show All

• Windows Forms .NET HTML WYSIWYG Control

  Hi All, I'm trying to find a decent HTML WYSIWYG control for .NET Windows Forms. I noticed that when you edit a HTML document within VS.NET it is displayed in a nice WYSIWYG editor. Does anyone know if that editor is a .NET control  If so, is it freely available for use Thanks, Kater ...Show All