Alex112's Q&A profile

• SQL Server Standby Restore

  I'm setting up log shipping and am running into an issue with applying the transactions logs. This is my 5th server that I'm setting up and I take a backup of the source database, restore it with replace on the standby server. Then I take a log backup, copy it over and try and restore on the standby server, but the LSN#'s are off. It tells me it's too late for the log and try an earlier.. The timestamp on my backup is 11:43 and my translog was at noon... I ran a checkpoint on the source database, but that didn't seem to do anything. What am I missing Thanks Susan I know this wi ...Show All

• .NET Development Miltiply applications memory use

  Hello. I have a few vb.net windows applications that are running on screen. My problem is that when the exe file is only about 25k the memory it uses(+framework) is about 10mb-12mb for each of the applications. Can frame work be shared so even if I have few on screen apps , it will load the framework only once For now I have only 3 apps (that is about 30mb of memory use) and I need to do about 10 apps running .. Please help. Everything is run seperately (if one crash the others survive). .NET use a gargadge collector so it will only clear memory when it needs to. I had a simple app and the memory went to 300mb but when an ot ...Show All

• Visual Basic SQL 2005 and VB.net 2005

  I have a question dealing with SQL and VB. I have been looking for a way to "Browse" my SQL for different Databases for useage in my programs. Is there something I'm missing dealing with a way to browse the SQL My app under Access had a dialog to select which MDB you wanted to use. I know SQL is Different, Need to get list of Servers. Now I want to be able to have the client select which server to use, and which database. I don't use the dataconnections within VB, as the database's could be on different machines ETC. Thanks Larry Gatlin Look around the Miscrosoft site for: SQL Server ...Show All

• .NET Development How to get a client certificate in code

  Hello, I created an X509 client certificate using Microsoft Certificate Services and installed it in my browser (under Personal). Now I want to call a webservice in code using a raw HttpWebRequest. This works fine, but I want to add the certificate and I don't want to import it from a file but directly from the registry or wherever windows stores it. How can I acheeve this I found some code at http://support.microsoft.com/ kbid=895971 But it didn't find me any certificates and besides it uses unmanaged code which I don't like. Thanks. this may help if you are using .net 2.0: http://msdn2.microsoft.com/en- ...Show All

• SQL Server ASP.NET ReportViewer / Non-String parameters

  I am displaying a local report in a ReportViewer control on an asp.net web page. My report contains non-string parameters. How can i set a non-string parameter value on a local report That would result in a string being passed to the report. I want to pass a float or a datetime to the report. The only way i've been able to get this to work is to create a typed dataset with the "parameters" i want sent and then use aggregation functions (first,sum, etc...) to get to the data into the report. That is a big workaround in order to get a few simple floats and times into my report. Has anyone been able t ...Show All

• SQL Server SQL2005 Peer-to-Peer Transactional Repl. Table Constraints

  I am researching the possible use of Peer-to-Peer Transactional Replication with SQL 2005 to improve the availability and scalability of the SQL-farm. The "Peer-to-Peer Transactional Replication" MSDN-document states: "Conflict detection and resolution are not provided. Updates for a given row should be made only at one database until it has synchronized with its peers. This can be accomplished, for example, by the application directing updates for a set of rows to a particular node." My Question: What happens to constrains Example: A table has a unique constraint. The same article (which is in conflict with the constraint) in inserted ...Show All

• SQL Server Tx replication works in 2000 but not in 2005?

  Hello, I've got a simple transactional replication set up. I have a separate publisher, distributor, and subscriber with 76 articles (tables only) being pushed from the distributor. I have this exact setup with the same tables and data working in the SQL 2000 environment. I am testing replication on our SQL 2005 test servers before moving to production, however when the distributor attempts to push out the initial snapshot I keep getting this error. Error messages: Incorrect syntax near ')'. (Source: MSSQLServer, Error number: 102) Get help: http://help/102 Incorrect syntax near ')'. (Source: MSSQLServer, Error number: 10 ...Show All

• Visual C++ Unable to locate component

  Visual Studio 2005 professional while using Debug-Win32 Mode to compile a project. Compliation was successful,but the program can't be run. It appears the following error This application has failed to start because MSVCP80D.dll was not found .Re-installing the application may fix this problem. No matter how many times I try to Re-install, It can't be solved. But using Release-Win32 Mode ,there is no mistake. Should I use Release-Win32 Mode for ever thanks. I have VS2005 pro installed and I find the MSVCP80D.dll in this folder C:\Program Files\Microsoft Visual Studio 8\VC\redist\Debug_NonRedist\x86\Microsoft.VC80.DebugCRT I d ...Show All

• Software Development for Windows Vista DelayActivity dynamic update

  Hello, I would like to ask you if it is possible to update DelayActivity.TimeDuration value when DelayActivity is executing I want to achieve scenario like this: workflow is configured to simulate delay specified in the DelayActivity. After DelayActivity starts waiting, user wants to change delay value for the running instance (increase or decrease the delay value). Applying WorkflowChanges to the running workflow instance with different DelayActivity.TimeDuration value set does not work (no errors, old delay value is respected). I was also trying to remove DelayActivity from the running workflow instance and recreate it ...Show All

• Visual Basic Question about moving an app from vb.net 2003 to vs 2005

  I'll be getting my copy of vs 2005 this week and had a question about EnableVisualStyles and how that will work. I just recently learned about enablevisualstyles and have started to apply this to my app. However, vs 2005 has this turned on by defualt and draws the controls to correctly include this be default. Does anyone know what happens to visual styles when bringing an app from vb.net 2003 into vs 2005 I'm hoping that it will apply the correct visual style settings automatically, however I'm a bit optimistic about this. I have a copy of my app that does not have any of the visual style stuff turned on so maybe this one would work bett ...Show All

• Visual Studio Cumulative Values for Shared variables

  Hi, I am using two sub report and each contains a shared report. Both the values are added and printed on below after the sub reports. I am using a shared variable to pass the value from sub report to main repot. When the reports shows the first set of sub reports, the values comming correct. While it prints the second set, then my shared variable in the main report shows the values of sum of first set value as well second set value. But actually what i need is , the shared variable in the main report should show the sum for that a set of sup report and not a cumulative. How to resolve this. Can any one help me Thanks in advance R.V ...Show All

• Visual C++ Creating UNICODE file

  How can I create a UNICODE file The following sequence do not creat a UNICODE file but an ANSI file: // UNICODE.cpp : Defines the entry point for the console application. // #include "stdafx.h" int _tmain( int argc, _TCHAR* argv[]) { wchar_t * expandedTreeFileName = _T( "C:\\TEMP\\UNICODE_file.txt" ); FILE * _pExpandedTreeFile = 0; _pExpandedTreeFile = _wfopen(expandedTreeFileName, _T( "w+, ccs=UNICODE" )); fwprintf(_pExpandedTreeFile, _T( "%s" ), _T( "***Unicode test***" )); fclose(_pExpandedTreeFile); return 0; } You need to ope ...Show All

• Visual Studio VS 2005 and SourceSafe 6.0c

  I've been using VS 6.0 for years and this all worked so seamlessly, so I'm really disappointed that I'm having such a hard time with this. In VS 2005 (from my workstation), I create a new website on my development IIS server.  I want to add the entire site into SourceSafe, but when I do, it says:   Microsoft Visual Studio cannot add FrontPage Web Sites to source control. Use Visual Studio to save all Web Site files. Then from the web server, use the Windows Control Panel, Administrative Tools, and the Internet Services Manager to add the files to source control. When I go where this message tells me, there is no option t ...Show All

• Visual Studio To Microsoft: Sporadic COM exceptions adding/removing commandbars and buttons from Visual Studio add-ins

  Hi Microsoft people, My add-in adds buttons to built-in commandbars of Visual Studio and also it creates several commandbars with lots of buttons. It is my painful experience (from user bug reports) that the Commandbars of Visual Studio .NET 2002/2003 and VS 2005 are very fragile and cause sporadic COM exceptions in non-reproducible circumstances. When a user reports this, my first question is: "Is it reproducible " and the answer is always "No, the add-in loaded/unloaded fine the next time". So, I am certain that my add-in is not buggy. I have done a lot of effort to identify some reproducible cases and I have repo ...Show All

• Visual Studio Team System Help with the Custom Checkin Policy Example from the Extensibility Kit

  Hey! I'm running TFS Beta3 Refresh,and using the latest version of the extensibility kit. I am not able to see my custom policy, when I try and add it to the Check in Policy page.  I see the three that are installed with it, but I do not see mine.  My assembly is called MyExtensibilityClass.dll, and is located at c:\policies.  In the registry, I have added a string to the Checkin Polices key.  The string name is MyExtensibilityClass and the data for the string is c:\policies\MyExtensibilityClass.dll.  But my policy is still not showing up where i can add it.  can anyone give me some words of wisdo ...Show All