rwerner's Q&A profile

• .NET Development Performance Counters for 32 bit Worker Process on x64 OS???

  I would like to be able view the performance counters for ASP.NET v2.0... on my server running Windows 2003 Server Std x64. I am running the worker processes in 32-bit mode and the performance counters that I see are for the 64-bit ASP.NET v.2.0... When local to the server I can run this command to see the actual values "mmc.exe /32 perfmon.msc" but how do I achieve the same thing from my workstation using perfmon Thanks for your help! That probably would've worked but due to an incompatability with our application we installed a x86 version of windows and this is no longer an issue for me. Thanks everyone. ...Show All

• SQL Server Date from a Datetime field

  Hi, a colleague need to get the date from a datetime field with a select query. Is there an easy way to get this date I need an excample. Thanks Thomas   select CONVERT ( CHAR ( 10 ), GETDATE (), 110 ) select CONVERT ( CHAR ( 10 ), mydatetimefield , 110 )  from mytable ...Show All

• Visual Studio Team System Error running unit tests from wizard

  Hi, I'm running Visual Studio 2005, and I'm having trouble with the unit tests generated by the Unit Test Wizard. Here's what I'm doing: 1) create a new project (I've tried Windows Application and Class Library) 2) add a single method that returns the number 3 3) Add a unit test using the Unit Test Wizard; modify the resulting test to check that my method returns 3. 4) Compile everything and run the test I get an error saying: "UTA052: DummyTest.Class1Test is not a test class". Any suggestions as to what's going on --Matt Hi Matt, I'm really sorry to hear that you're going through this problem. Unfortunately it is really difficult to know what's happening if we don't h ...Show All

• SQL Server Job Hang

  Hi, I am running the following TSQL command and it hangs. These commands are running from SQL 2000 server and it is querying information for SQL20005 database. Running simple EXEC command work fine but running using Insert hangs. Set @Cmd = @ServerName + '.' + @dbname + '.dbo.sp_helpntgroup' Print @Cmd Insert into dbo.DBSecurity ( NTGroupName, NTGroupID, SID, HasDbAccess) Exec (@Cmd) Any idea, Is the SQL Server 2005 server configured as a linked server or remote server If the SQL Server 2005 server is configured as a remote server and SET REMOTE_PROC_TRANSACTIONS is ON/the option is set then the insert...exec will start a distributed transaction automatically. So depending on your network configuration a ...Show All

• SQL Server Linked server

  Hi All, I'm using Sql Server 2005 express, what i want is in my requirement the LAN may disconnected for sometime for some reason what ever it may during that time i want to store the details in MS Access database which is present in the local machine....once the LAN Connection established i want to transfer the data from MS Access to Sql Server... IS it possible.. or otherwise i want to Sync the data between MS Access and Sql Server 2005 Express is it possible. I'm using C# .net Desktop Application for development. I taught of creating a linked server, Is it correct or some other things to perform to do this operation. plz help me... -Amjath I don't think that the concept of a 'Linked Server' will so ...Show All

• Visual Studio 2008 (Pre-release) Displaying DataTable in run-time

  Hi, I've got the following issue: My application is intended to show any table from the database. It means that the structure of the table is only known in run-time. I looked through the samples, but all the examples contain DataTemplate definition in XAML file that is not my case. I browsed the documentation but did not manage to fing the way how to create DataTemplate programmatically. Are there any ideas how can I display a table when its structure is only known during runtime. TIA Thank you. But ListView.ItemsSource is supposed to implement IEnumerable interface, but neither DataSet nor DataTable do this :-( ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Attempt to allocate VRAM before start of an application?

  Gateway is being dumb. Yes, it actually does relate to topic :P I have a Gateway MX6629 laptop that comes with an Intel GSM 915 on board video processing chip that is by design suppose to be able to dynamically allocate up to 128mb of video memory; however, after trying multiple OS with multiple drivers versions, it became evident that Gateway effed up the BIOS configurations and limited the chip to operate only up to 64mb of video memory. It took a lot of time for me to convince their support to escalate the issue to their higher ups -- a whole seven months for that matter -- and they gave me a stupid semi-canned response about how the dynamic video memory allocation technology works... as if I haven't read that before contacting them. An ...Show All

• Windows Live Developer Forums Document's body height and pushpins....

  I have a frustrating problem. The map and the document's body height works great when used without pushpins... However, the document's height gets enlarged when you add a pushpin. This is creating a scrollbar that strangely goes away when you mouseover the pushpin. There is some code below that illustrates the problem. Does anyone know a hack around this Mayber there is a way to force a mouseover with a given pushpin ID Thanks, -Steve <HTML> <HEAD> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <script src=" http://dev.virtualearth.net/mapcontrol/v3/mapcontrol.js"></script > </HEAD> <script> var map = n ...Show All

• SQL Server Subquery Error

  Dear Friends, Could you tell me where is the problem ALTER PROCEDURE [dbo].[GD_SP_FACTURA_SOFTWARE_GERAL2] @Direccao nvarchar(10) AS DECLARE @NrLinha int BEGIN SET @NrLinha = SELECT COUNT(*) FROM (SELECT dbo.Aplicacao.Aplicacao, COUNT(dbo.ADCN_AplicID.CN) AS QtAplic FROM dbo.ADCN_AplicID INNER JOIN dbo.Aplicacao ON dbo.ADCN_AplicID.AplicID = dbo.Aplicacao.AplicID INNER JOIN dbo.SERVICO ON dbo.ADCN_AplicID.Servico = dbo.SERVICO.S_GrupoServico INNER JOIN dbo.HARDWARE ON dbo.ADCN_AplicID.CN = dbo.HARDWARE.New_Computername WHERE (dbo.SERVICO.S_NomeDir = @Direccao) GROUP BY dbo.Aplicacao.Aplicacao, dbo.Aplicacao.Custo ) END ERROR: Msg 156, Level 15, State 1, Procedure GD_SP_FACTURA ...Show All

• SQL Server concatinating string values from multiple rows

  I currently have some SQL code that is used to build a string that is a concatination of string values across multiple rows.  The subqueries in the script sometimes return NULL values so I use the following statement to change the default behavior of the concatination operator which prevents my query from returning NULL: SET CONCAT_NULL_YIELDS_NULL ON Here's the code snippet: select DISTINCT ( SELECT CASE WHEN (t1.MaskValue & HDR.TranTypeID)=1 THEN ' ' + t1.description ELSE '' END FROM transactiontypes t1 WHERE (t1.MaskValue & HDR.TranTypeID)=1) + ( SELECT CASE WHEN (t2.MaskValue & HDR.TranTypeID)=2 THEN ' ' + t2.description ELSE '' END FROM transactiontypes t2 WHERE (t2.MaskValue &am ...Show All

• Visual C++ Problems with VS2005

  Following a mini-rant regarding the quality of VS2005 on the DirectX Dev list, it was suggested that discussion was continued on these forums, so I'll try and quantify my earlier rants/complaints with real problems I've encountered over the last six months. It should be noted that all these problems I've encountered are with the Professional version of Visual Studio 2005, building native C++ projects targeting x86, x64 and Xbox 360. My PC is a dual core 2Ghz AMD with 2GB of RAM and an X800 ATI video card. IDE Aside from the performance issues, which I'll get to in a minute, these are the main problems I have with the IDE in VS2005: Configuration Manager is broken. Really broken. Changing platform or solution configuration l ...Show All

• Visual Studio 2008 (Pre-release) System.ServiceModel.dll Not Shown in VS2005 , Vista RC2

  I have recently installed Vista RC2 with Visual Studio 2005 Team Edition for Developers. When creating a Console app ( I am wanting to do some WCF work) Clicking on Adding a reference does not list the System.ServiceModel.dll file however it is present in %windir%\microsoft.net\framework\v3.0\windows communication foundation folder Is this by design, must something be done to register the baked in V3 framework files within Vista Thanks Jason ...Show All

• Smart Device Development unresolved external symbol _imp_exit

  I get eight unresolved external symbols when i link my program. Seven are from the conio.h file (_imp_exit, _imp_getch, _imp_putch, etc.) and one is from bool setcursorposition(x,y). I don't know how i got this far since i never tried to program a pocket pc before. I am using (C++ win32) to build a console program. i got the program to compile and when i link it i get unresolved external symbol errors. i tried changing the functions "exit, getch, and the rest", then i could not build the cpp file. i believe i'm missing a library call. I scanned all the .lib files and did not find a fix. i just got my copy of mvs2005 seven days ago. it's new to me but works real good. is there a .lib that includes these functions thanks. ...Show All

• SQL Server Need to Subtract the result of two stored procedures

  I am trying to take the results from two stored procedure and subtract them to get credit from two columns. The stored procedures look like create PROCEDURE mw AS select * FROM pla p where p.st in ('ds', 'sd') and (iPlayerID = '5345') compute sum(p.amount) RETURN both procedure have the same syntax. I am not able to use AS in to insert the values into a variable. Is there a wizard to use That worked for a bit then I noticed that I need to apply the value to create credit. DECLARE @credit money SELECT @credit = sum ( amount )+( moneySpent - @moneyWon ) From Table Where status in ( 'var' , 'var' , 'var' , 'var' ) and id = '5455' select ...Show All

• Visual Studio Team System Regarding MSBuild

  Is there a way in build script to run unit tests only in debug mode Are you referring to Team Build with TFS or just MsBuild, anyway I recommendo you to check this on the Team Build forum, if this is related to Team Build, or to Visual Studio 2005 forums if it is just refered to MsBuild. ...Show All