mrMarkH's Q&A profile

• SQL Server Distributed App, Technology Question

  Hi Everyone. I am trying to get ideas for a possible technology we could use for a certain scenario. In a nutshell we want to run a distributed application at hundred of remote stores, anything that happens at the store must be propagated to a central sort of hub server. Now i have already thought about replication, but maintaining replcation across hundreds or even a thousand remote instances would be a nightmare.Also the App must work offline so if no link exists the app must still work and sort of reliably queue the transactions. So i been experimenting with service broker, to write transactions, that then queue on to service broker to the central hub, therefore enabling remote stores to continue to work even if no comms exi ...Show All

• Visual Studio Team System Build for setup project failing

  Guys, I followed the article: http://msdn2.microsoft.com/en-us/library/ms404859.aspx to build a setup project from Team Build. I have this in my team build .proj file: <Target Name="AfterCompile"> < Exec Command="'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv' '$(SolutionRoot)\Environment Management-082106\EnvMgmtSetup\EnvMgmtSetup.vdproj' /Build 'Debug|Mixed Platform'" /> < Copy SourceFiles="$(SolutionRoot)\Environment Management-082106\EnvMgmtSetup\Debug\EnvMgmtSetup.msi" DestinationFolder="$(OutDir)" /> < Copy SourceFiles="$(SolutionRoot)\Environment Management-082106\EnvMgmtSetup\Debug\setup.exe" DestinationFolder="$(Out ...Show All

• SQL Server Datetime format regardless regional settings

  Hi, in tsql there is a common format for datetime (regardless regional settings) I use : 'mm/dd/yyyy' to access cols in database, but someone says that the right one is: yyyy-mm-dd. Any suggestion about that Thank a lot I believe you want the ISO format -- 112; that is yymmdd. Can somebody double check this Dave ...Show All

• Visual Studio More than one startup project?

  Hi everyone out there! Why is the example in http://msdn2.microsoft.com/en-us/library/ms228782.aspx referring to a "collection of startup projects" Shouldn't a solution have one and only one startup project by design TIA, Alan Boris Jabes (Visual C++ Program Manager) writes that VS supports multiple startup projects in this blog post: http://blogs.msdn.com/borisj/archive/2005/10/11/446102.aspx Not clear if that applies to vs2003 or only to vs2005. ...Show All

• SQL Server Adding Report Model Aggregates

  Is there a way to add report model aggregate to a field. I have added a numeric field to the model and want to add the aggregates under that field. Any ideas R ...Show All

• SQL Server Delete files older than 3 days using SSIS tasks

  I want to delete all files in a given folder that are older than 3 days from today's date. I tried using a "Foreach Loop container" with a "File System" task inside it but found I couldn't access any file properties such as the file creation date. Am I using the wrong task for this job TIA, Barkingdog P.S. History of the problem: I used the sql 2005 Database maintenance program to setup our database backup jobs. One day I noticed that the free space on the drive where we keep the dumps had grown small. I found that we had at least 4 weeks of dumps in there, not the 3 days I wanted to keep! I looked but could not find the "delete file" option in the SSIS package generated by the Data ...Show All

• SQL Server What's New in SQL Server 2005 SP2 - Replication

  What's New in SQL Server 2005 SP2 - Replication In Enterprise Edition, you can now initialize subscriptions to snapshot and transactional publications by using a database snapshot. To do this, specify a value of database snapshot or database snapshot character for the sync_method publication property. Database snapshots provide the foundation for a robust snapshot processing mechanism that can reduce lock contention at the publication database during snapshot generation. For more information, see sp_addpublication . Merge replication now provides a stored procedure that regenerates the triggers, stored procedures, and views that are used to track data changes. For more information, see sp_vupgrade_mergeobjects . http://w ...Show All

• SQL Server MDX query count of customers who purchased in prior period and this period

  Hi there I'm looking for help with an mdx query that will tell me how many of my customers are returning to purchase each period and thus by default how many existing customers haven't purchased this period. So in English I want; Count of distinct customers who were active in this period and were also active in prior period. Or in T-SQL something like this select count (*) from ( Select distinct customer_id from fact_table where date = current period and exists ( select distinct customer_id from fact_table where date = prior period) ) I have a measure called distinct customer count and a dimension called DIm Customer which currently doesn't have customer_id as a level in any hierarchy, althoug ...Show All

• Visual Studio Team System How to modify query to display custom field?

  I have added some custom fields to my tasks. now i want to display them in the query result. how do i make it happen thanks advance. You can right click on query results and choose "Column Chooser". It gives a dialog to choose which columns to show in query results. The fields can be shown unless they are long text fields. ...Show All

• Visual Studio 2008 (Pre-release) Little WPF/XAML problem

  Hello I have this code in my Window: <Style.Triggers> <Trigger Property="IsMouseOver" Value="True"> <Setter Property="Background" Value="Red" /> ... This all works fine. The background turns red if the mouse is over the button. But if i use Vista Aero Style the background color is changed again with the animation Vista does. Is there any way to disable that behavior without disableing Aero completly Unfortunately there is no way to disable the background animation on Vista without providing a new template for Button. See http://msdn2.microsoft.com/en-us/library/ms75 ...Show All

• .NET Development regex match search or not to search

  Re: System.Text.RegularExpressions.Regex, C# lets call the string to be searched target string Desired Result: Efficiently Match a regular expression to target string. WHOLE target string should be consumed. Actual Result: The Match searches as documented until it finds a match WITHIN the target string. Can I indicate to method Match to consume whole target string or fail efficiently with options or lookback Perhaps the naming throws me. Boost library has two methods for their version of regex ...regex_match and regex_search Here is an excerpt from Boost site >>>>>>>>>>>>>>>> http://boost.org/libs/regex/doc/regex_match.html The algorithm regex _match determines whether a giv ...Show All

• .NET Development How To Use FTPWebRequest

  Hi, I apologise in advance for the triviality of this question, but I've got to learn; I only get C++ examples when I use my local MSDN help! I am trying to implement an FTP system into my application, which is a team utility to manage resources for our game development projects; as such each user needs to be updated with our server. I've worked out that I need to use the FTPWebRequest class or whatever it is, but I have no idea how to use it. I need to be able to implement: Asynchronous upload/download of files Creation and deletion of folders Lists of files in a specified directory Information i.e. filename of a file in a specified directory Use of SSL for encryption Obviously, I need to have a connection to th ...Show All

• Visual Studio 2008 (Pre-release) Retrieving Username and Password from OperationContext with wsHttpBinding

  Hi there, Does anyone know, if it is possible to retrieve username and password from the OperationContext in the service I have used the wsHttpBinding and in the OperationContext.Current instance, I cannot find the caller information again. There is a CallerIdentity in the OperationContext instance, but I need the password that is supplied by the client to the corresponding user. Any information/help will be greatly appreciated! Best Regards, L. Liu So I'm not completely sure why you need Adam's password once he's already been authenticated. Is there some other resource that the STS needs to access using Adam's credentials If so, then since the STS must have access to the correct password in order to authenticate h ...Show All

• SQL Server Execution of report times out

  I am having major problems with some of the reports that i run. Some of the larger reports are running for 20-30 mins and then timing out, allthough the actual sql stored procedure behind the report only takes 2-3mins to run. I sometimes get an rsexecutionnotfound error which looks like the chunk data has been removed by ssrs before it is sent to the screen i am getting to the end of my teather with this as i have gone through everything that i can find to try and stop this happeneing and after 2 months of investigation still nothing. There is one thing that seems to speed up the reports and that seems to be if i pump the data for the report into a new table and then ref that table in the report which only takes a couple of seconds i ...Show All

• Visual C# Language symbols problem

  hi, i have a problem with the language configuration of windows xp... i need my application to not change its configuration,,, for example my money is represented with $ ,,, and in eupre is the (euro symbol) and some stuff like that,,, its different depending the language configuration i ttried to change the language of the form to spanish(mexico) and when i change my language configuration on xp it changes on my program... is there any way to force my program to use a defnied configuration mig16 ...Show All