Dave Waterworth's Q&A profile

• SQL Server SQLWB.EXE max cpu

  SQL Server Management Studio 2005 Windows 2000 when I "Open Table" to view all the records in a table, the cpu goes to 100% and the records are drawn very slowly - about the same speed as you read ! I have re-installed all the software and also tried service pack 1. SQL 2000 worked fine. any ideas thanks John, UK Microsoft SQL Server Management Studio 9.00.2040.00 Microsoft Analysis Services Client Tools 2005.090.2040.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 built by: (_sqlbld) Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 6.0.2800.1106 Microsoft .NET Framework 2.0.50727.42 Operating System ...Show All

• Visual Studio 2008 (Pre-release) Exceptions and WCF

  Hey! I have read the msdn documentation on handling faults in WSF but can’t get it to work. I have the fallowing Interface fore the service: [ServiceContract(SessionMode = SessionMode.Required, CallbackContract = typeof(IChatChangeHandler))] public interface IChatChangePub { [OperationContract(IsOneWay = false, IsInitiating = true)] bool subscribe(string inNickName); [OperationContract(IsOneWay = false, IsInitiating = true)] void unsubscribe(); [OperationContract] [FaultContract(typeof(userListFault))] List<string> getUserList(string inNickName); [OperationContract(IsOneWay = true)] void publishChatMessage(chatMessage inMessage); } As you can see i am using a costum faultExcetion(userListFault) that lo ...Show All

• Visual Studio Team System Custom Actions in a Team Build

  I am trying to create a custom build action for a team build for one of our solutions. Our project is split into 2 main sections, an Architecture solution, and a GUI. The GUI uses Dll references to a common directory on a server where the latest release of the Architecture project resides. These references are resolved from an M: drive which for local development is either a mapped drive from the server or a subst to a local folder. When trying to create a Team Build for the GUI solution, initially it fails as it cannot resolve references, though the hint path is searching for M: drive. What I would like to do is perform a 'subst m: $(SolutionRoot)\Architecture\Binaries' before the compile starts and then 'subst m: /d' after the compile ha ...Show All

• .NET Development file upload to https server not working

  i am sending a file to a https server and i am not getting back the same results as iexplorer is, or the same page. my page has an error that its displays, which is "Error: Cannot find bean: "UploadBean" in any scope" i captured the stream from iexplorer and my app and its the same thing being sent. any ideas here is the file that i am sending using multipart-form content type StringBuilder^ sData = gcnew StringBuilder(); sData->Append("--" + sBoundary); sData->Append("\r\n"); sData->Append("Content-Disposition: form-data; name=\"firstTime\""); sData->Append("\r\n\r\n"); sData->Append("F"); sData->Append("\r\n"); sData->Append("--" + sBoundary); sData->Append("\r\n"); sData->Append("Content-D ...Show All

• Smart Device Development How to get Message body from smartphone outlook email message

  To get message Body I have used 2 APIs provided by microsoft (OpenProperty [if more then 4kb size] or GetProps) passing PR_BODY as a tag. But it returns empty message body. Then I tried with PR_CE_MIME_TEXT as a tag. It returns success ,But We are getting some Binary data .As per MSDN it shoud give some encoded data. as PR_CE_MIME_TEXT Contains the message's Multipurpose Internet Mail Extension (MIME) encoded text body. I didn't found any API which can decode that MessageBody in WM5. Then how can i get the message body Thanks for your reply. Yes you are right. My mime data is a multipart message. In my application i am trying to retrive all the fields . I am getting proper da ...Show All

• SQL Server Post SP2 : Instance cannot be configured for Sharepoint Integration?

  After upgrading to SP2 straight from from SP1, I get the message that my current reporting server instance cannot be configured for Sharepoint Integration when I click on the Sharepoint integration tab.  Also, I do not get the option of choosing Sharepoint integration if I try to create a new database in the Database Setup tab.  I've read that the new Reporting Services Configuration Manager is not compatible with an older instance of Reporting Services, and realize that might be the problem.  But I haven't found how to get around it!  Do I need to uninstall SSRS and start over   I'd really like to switch to Sharepoint integration, if at all possible. Another funny thing:  I thought I might try re-installi ...Show All

• Visual Studio 2008 (Pre-release) Timeout maximum value in config file

  What is the maximum value for timeouts, like receiveTimeout for netNamedPipeBinding I'm trying to set as large a value as possible: receiveTimeout="23:59:59" If I set the hours, minutes or seconds to larger, then my app crashes on start-up. I also tried putting receiveTimeout="10.23:59:59" (According to Timespan documentation, the number before the period should indicate the number of days). However, if I set the number of days to larger than 23, I still get a crash -- which makes me think that "10.23" in the above examples is being parsed as 10.23 hours, and then that is added to 59 minutes 59 seconds. So, what is the maximum value for all these timeouts Can tell it to *not* timeout, ever ...Show All

• Visual Studio Team System Command line get changeset

  HI How do I get the latest changesetnumber for a specific file and parse that number to a get command I know I can get the number with 'tf history...' but how do I parse that to the get command 'tf get /version:C[changesetnumber]...' Regards Kim Hi What I want is to build my solution, using scripts, until we convert it all to tfsbuild. I have a include file called version.rc that contains the versionnumber. Before the build starts I check out and edit this number, and do a checkin. To be sure no one do a checkin in the same second, I would like to get the latest changenumber on version.rc and then use that changeset number to get the rest, to be sure I have a correct and wellknown ...Show All

• Gadgets Want to start a beta/debug group?

  Hello, Would anyone be interested in starting a group to help each other with beta testing I have a bunch of users who help me with new versions, but I don't like to get too technical with them. I'd love to have access to other developers who can give me debug ouput and insight. Anyone interested Ty Hey, I'd be very interested in this, i have a few people on my contact list who help me out but they don't have much technical knowledge so it can be difficult working out why something doesn't work for them. If you add me on msn messenger: ljames28 [a t] hotmail .com i'd be happy to help out. Law ...Show All

• SQL Server Index was Outside the Bounds of the array.

  On the data tab in reporting services I have just named the stored procedure I wish to run. This Stored procedure expects a datetime parameter. When I select run in the data tab and enter the date (I have tried various different formats) the error "Index was outside the bounds of the array. (system data)". Does anyone know how this can be solved it seems a simple issue but is turning into a pain to sort out. Does the message box have a little "Show technical details" button. If so, could you post the error message details Does this happen with other stored procedures What about other parameter types -Albert ...Show All

• Software Development for Windows Vista when exactly the WorkflowPersistenceService.SaveWorkflowInstanceState method invoked?

  in msdn, it says it invoked after Unload Event. And if the UnloadOnIdle set to true, it did! but if the UnloadOnIdel set to false, the WorkflowPersistenceService.SaveWorkflowInstanceState still called sometime i'm not sure before WorkflowRuntime.Completed. But the WorkflowRuntime.WorkflowUnloaded Event DID NOT triggered that time. Why The PersistOnCloseAttribute should go on a custom activity that you create not on the workflow because it would cause the workflow to only persist when it closes which is to late normally. Any time an activity returns executing and no other activities are scheduled to be executed the workflow is considered idle. This is true for the handle external event activity when it is waiting for the even ...Show All

• Visual Basic Service dosen't want to copy from network/vpn

  Hello, I have a small problem with a windows service that I am trying to make. The program needs to copy I file from a network path to the local computer if the file changes. The code runs fine as a program but when I try to make a windows service then I get errors about FileSystemWatcher and a error that the path not could be found. I know that the problem is that windows services are running on a different account but but is there a way to have the service running as the authenticated user This is the source code: Imports System Imports System.Threading Imports System.IO Public Class PollingService ' Keep track of worker thread. Private m_oPollingThread As New Thread( _ New System.Th ...Show All

• Windows Forms Create Custom Form Borders

  Does anyone know of any tutorials that show how to build a form in VS.NET 2003 (C# 1.1) that includes custom borders I found a sample that does exactly what I want but it's for VS.NET 2005 (.NET 2.0). Here's the link to the 2005 version: http://www.geekswithblogs.net/kobush/articles/CustomBorderForms.aspx Thanks for any input. - Kevin The earlier versions included support for VS2003 Take a look at the 0.3 download. I wouldn't expect it to be too much work to get the later versions working in VS2003. ...Show All

• Visual Studio 2008 (Pre-release) BinarySecurityToken causes interop issue with BEA simple secured service node.

  Hi Community, I am doing an interop test against the secured BEA Aqualogic node. The BEA node is configured to receive an encrypted request. The way BEA works is, it asks client for a public key for encrypting the response back. The WCF client makes a successful call. At the BEA side since it excepects the public key for encripting the message it fails. The reason it fails the WCF client does not pass the public key or WS-Security node element "BinarySecurityToken". I used SVCTRACER to trace the secured message sent I found that the message has following lines. <o:BinarySecurityToken> <!-- Removed --> </o:BinarySecurityToken> The question is how do I pass the BinarySecurityToken or in other wo ...Show All

• SQL Server NEWSEQUENTIALID()

  I'm trying to modify my default value for GUIDs in DB, currently using newid() for default. In management studio, click on modify and in the table designer for the default value I entered newsequentialid() and got the following error. Error validating the default for column "xxxx". I would like to have my tables that are using guids, have newsequentialid as the default value. When read on this new function it says can only be used with default value, but can't get that to work. Any ideas thanks I can set the default value OK in management studio if it is a brand new table. I'm trying to upgrade my tables in my DB to have the default to be newsequentialId(). Is there a prob ...Show All