Grayson Peddie's Q&A profile
SQL Server SQL2005 Performance problem with updating subscribers with identities
Since we've upgraded to 2005 we've had major performance problems with updating subscriber tables that contain identity PK columns set to manual or auto range management. If a table has identity range management set to 'None' (the "old" 2000 way), the peformance is fine. Below are sample tables: CREATE TABLE [dbo].[ID_RANGE_TEST]( [ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [DATA] [int] NULL CONSTRAINT [PK_ID_RANGE_TEST] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[ID_NONE_TEST]( [ID] [int] IDENTITY(1,1) NOT NULL, [DATA] [int] NULL CONSTRAINT [PK_ID_NONE_TEST] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KE ...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 I think he should just work on saving the file in the simplest manner at the moment Eragon. Giggig, In order for the code I posted to work you must pass the string to the function and then the function uses the identifier 'path' to work with it. In order for you to use it directly within your code you could do two things, 1) Create a variable of type string and assign the value of the filepath to it or... 2) simply change the word 'path' to the literal string of the filepath...here is an example of each... private void SaveAsToolStripMenuItem_Clic ...Show All
Visual Studio 2008 (Pre-release) are there any plans for a FoxPro provider
I have to support both SQL and FoxPro in my applications. Is there a plan to develop a provider for FoxPro Dinesh, in one of the videos with Anders, mention was made that there is a internal implementation of LINQ to Access. Will this be released at any point or is it simply an attempt to work through some of the provider model details Jim Wooley http://devauthority.com/blogs/jwooley/default.aspx ...Show All
Software Development for Windows Vista XAML Based WF Linked to Assembly
I am trying to set up an XAML based workflow where all of the activities are either common activites or defined in a custom assembly. I am loading the xoml file at runtime using an XMLReader to load the xoml file, then calling CreateWorkflow with the XMLReader. After working with this a bit I was finally able to get the workflow to load correctly. The workflow starts with a While Activity. The While activity calls a member of my custom SequentialWorkflowActivity class named 'ContinueLooping'. 'ContinueLooping' sets args.Result = true; This should result in a continuous loop, however, the workflow always completes right away. If I put a message box in the 'ContinueLooping', I never see the message box. If I change the name of the 'ContinueL ...Show All
Visual Basic Why does my app try to connect to the internet?
This was really strange. After finishing my application (first one in vb.net) I ran it and for some strange reason it tried to open a port (1147) and according to my firewall it was listening not sending. I found this very strange because my application doesn't contain any code what so ever that would be able connect to the internet. I even tried a simpler application with just a form and a button and that one also tried to open up a port. When i blocked the program from trying to listen, it crashed giving me this error report. EventType : clr20r3 P1 : cmiss.exe P2 : 1.0.0.0 P3 : 44e17833 P4 : system P5 : 2.0.0.0 P6 : 4333ae87 P7 : 2ba8 P8 : 40 P9 : system.net.sockets.socket Does anyone else have the same problem or is t ...Show All
Visual Studio 2008 (Pre-release) Problem with Metadata Exchange
Hi! We have a problem with metadata exchange during proxy class generation with svcutil. This problem is closely related with size of file, that contains ServiceContract definition (for example, there is no error if some FaultContracts are commented) Thanks, Alexey Error: Cannot obtain Metadata from http://localhost/VClassWebService/vcservice.svc/mex If this is a Windows (R) Communication Foundation service to which you have access, please check that you have enabled metadata publishing at the specified address. For help enabling metadata publishing, please refer to the MSDN documentation at http://go.microsoft.com/fwlink/ LinkId=65455. WS-Metadata Exchange Error URI: http://localhost/VClassWebService/vcservice.svc/mex ...Show All
Microsoft ISV Community Center Forums [OTP] VBA Using combobox in Excel
H i there, I'm working on an engineering spreadsheet (Excel) and need some help in manipulating comboboxes / dropdown list. Say i have 2 list, where list A has the list of countries and list B has the list of cities for the country chose. If all the data source (i.e. countries and cities) are to be extracted from the Excel spreadsheet, is it possible to make list B dependant on list A (that is to say when user selects a country in list A, list B will automatically gives the respective cities) WITHOUT creating a userform If so, please advise how. Hope you can understand what i'm trying to ask here. Fyi i have minimum VB knowledge so a "dummyproof" explaination would be really ...Show All
Visual Studio Team System Displaying Code coverage results with automated MSBuild
My assemblies.testrunconfig file includes code coverage setup. When I run my build direclty from VS, the code coverage results are displayed correctly. I am running an automated build and I run into couple of issues: a) The test results file does not contain the code coverage when I open the corresponding trx file on the buildserver b) The test results folder cannot be published on the drop location. I checked my security on both servers and I have full control. Anything I am missing Here is the excerpt from the build log: Target CoreTest: Creating directory "C:\Build Output\Alpha Releases\ConnectTest\BuildType\..\Sources\..\TestResults". __________________________________________________ Project "C:\Build Output\Al ...Show All
Software Development for Windows Vista Custom Sql Persistence
Hi, I need to store the state of the workflowInstance in sql db. Apart from that, I need to store UserId, taskID, etc., in the database. As per the sql schema that comes with WF [sql scripts] does not support. So, I need use my own custom sql persistence. Kindly let me know, if someone has solution for this, please share with me. Thanks in advance, chandru. Jon, could you please share more information about tracking steps you described I've found SQL scripts you wrote about (though they were in different directory ;-)) but i'm not sure what to do with them in order to make your ASP.NET Workflow Monitor Implementation work (It always gives me an "stored procedure not foun ...Show All
Windows Forms Form's owner is randomly changing
I have a problem I can't seem to figure out. I have an application with an MDI parent form which obviously creates MDI child forms. The child forms then create and display forms as modal dialogs. I am running into a problem with the owner of the dialog forms. My dialog boxes are created in the following way: protected void ShowManageCorporateMessageDialog( ListViewItem selectedItem) { ManageCorporateMessageDialog dialog = new ManageCorporateMessageDialog (selectedItem); dialog.ShowDialog( this ); } In the debugger, the this keyword references the expected MDI child form (in this case ManagmentStudio.CorporateMessages.CorporateMessageManagerDialog). However, if I run the following code MessageBox .Show( th ...Show All
Visual Studio 2008 (Pre-release) Question about concurrency and sessions
Hello. I've been trying to understand the interdependencies between: SessionMode, InstanceContextMode, ConcurrencyMode and the used binding. I’ve done a systematic test where I issue two concurrent asynchronous calls over the same channel, and observed the following: With SessionMode=NotAllowed the calls are processed concurrently, independently of the InstanceContextMode (PerCall or PerSession), of the ConcurrencyMode and of the binding (NetTcpBinding throws an exception). This is ok because every call is handled by a different instance. With SessionMode=Required and InstanceContextMode=PerSession and ConcurrencyMode=Single, the calls are processed sequentially. This is ok because the instance is always ...Show All
Visual Studio Express Editions Resizing any control heigth issue/question
Hi, I want to resize the heigth of a control like a button, or textbox but vb wont let me, it just defaults back to "20". I changed the maximum heigth and width to 50 but the heigth always defaults back to 20 pixels. The width can be resized just fine though, also when I set a control and select it, I only see the resize width markers and no heigth markers to drag and resize. Is there some setting some where to fix this Ok, thanks for the help, it seems that checkboxes and labels cant be resixed either unless the Autosize = false is selected but the textbox doesnt have an autosize option the closest thing is to select the multiline option. But the textbox will work fine instead, thanks ...Show All
Visual Studio Team System How to force different rule set in csprojects from one TS project?
I have a few projects (mainly UI) that should have different rule sets than the rest. Is it possible to enforce rules on a csproject basis I don't want developers override policy or have to suppress tons of warnings from designer enerated code. Howewer they should be constrained to fulfill all rules in other places. Marcin Hi Marcin, Unfortunately, you cannot enforce a policy per project basis. You can enforce it only on a team project level. If it makes sense to keep the few UI projects in a different team project, you can enforce a different policy for them. If that is not feasible, you can enforce the minimal set of rules in the policy and add the additional rules in the projects that need to ...Show All
Visual Studio Express Editions fatal error C1083: Cannot open include file: 'winsock.h': No such file or directory
Code #if defined(__WIN32__) || defined(WIN32) || defined(_WIN32) #pragma commment(lib, "wsock32.lib") #define WIN32_LEAN_AND_MEAN #include <winsock.h> #define bzero(p, l) memset(p, 0, l) #define bcopy(s, t, l) memmove(t, s, l) #else Error 1>------ Build started: Project: webmirror, Configuration: Debug Win32 ------ 1>Compiling... 1>webmirror.c 1>c:\documents and settings\mithund\my documents\visual studio 2005\projects\webmirror\webmirror.c(48) : warning C4068: unknown pragma 1>c:\documents and settings\mithund\my documents\visual studio 2005\projects\webmirror\webmirror.c(50) : fatal error C1083: Cannot open include file: 'winsock.h': No such file or directory 1>Build log was saved at "file://c: ...Show All
.NET Development 2.0 OracleClient + Oracle 8: oci exception (System.AccessViolationException: Attempted to read or write protected memory.)
hi, From time to time we get an execption when we try to create an Oracle connection. Could anyone give an indication what might be wrong or how we can examine this problem... The 2.0 application is a batch application executing on a win2003 server. The DB Client is an OracleClient 8.1.7 client and the DB server is Oracle 8. We use the .NET 2.0 System.Data.OracleClient. System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at System.Data.Common.UnsafeNativeMethods.OCIEnvCreate(IntPtr& envhpp, MODE mode, IntPtr ctxp, IntPtr malocfp, IntPtr ralocfp, IntPtr mfreefp, UInt32 xtramemsz, IntPtr usrmempp) at System.Data.OracleClient.TracedNativeM ...Show All