Xie Zheng's Q&A profile
SQL Server Table Partition Automation and Project REAL: Data Lifecycle - Partitioning
Could some one please help I as junior Programmer have been given the task to implement table partitioning, with a modified sliding window scenario. Now I've read countless articles on how it works, including the White Paper by Kimberly Tripp. What I'm currently battling with is the examples given in the " Project REAL: Data Lifecycle - Partitioning" paper. The problem starts with the "Code Samples" heading. Where the first stored procedure is written. *********************************************************************** DECLARE CurrentSchemePartitions CURSOR FOR SELECT FileGroupName, Boundary FROM dbo.fn_Get_FileGroupsByPartitionBoundary(@psOld_Scheme_Name) ORDER BY Boundary ASC OPEN CurrentSchemePartitions SET @ps ...Show All
Visual Studio Express Editions Tackling an issue
Hi all, I'll try to describe this as best I can. If it gets a little confusing, let me know and I'll try to rephrase everything I've said! For the past few weeks I've been trying to get my head around VB2005EE. After reading a few books and tutorials I feel that I'm almost ready to go ahead and build my first "real" program to distribute. The program I have in mind should be nothing complicated, but I'm a little confused on how to build the key feature. Without giving too much away, my idea is to build a large database on every ride, roller coaster and theme park in the world. Each entry will feature statistical information on the particular attraction, along with media (video/pictures), location etc. - this will mean I'll have ...Show All
Commerce Server Search Wildcard Characters
It seems that quite a few characters are interpreted as an OR unless enclosed in quotes. Specifically the - (dash) character. Is there a way (and where) this can be customized. All of my clients parts numbers have a dash in them so the Search is somewhat confusing for the end-user. I looked through the documentation but could not seem to find it. Please Advise. This is the standard behavior of the Sql fulltext search wordbreaker. It is splitting the RG5-1392 into two search words RG5 and 1392. ...Show All
SQL Server Getting started with DMX
Hello, I'm studying some articles about DMX and i have a question. DMX statements is only for prediction Can i create a model and run a classification/clustering/decision tree algorithm through DMX instead of prediction Because all the examples i found are talking about prediction. Are there any other sources i can study, so i can have a better understanding of what DMX does Thank you in advance! DMX is both a data definition and data manipulation language, so yes, you can create and train models with DMX using the CREATE and INSERT statements. In SQL Server 2005, the DDL part of it is a subset of the full DDL available via XMLA. Take a look at the DMX reference here for more information: http ...Show All
Software Development for Windows Vista how do i burn cd images?
I cant seem to find anything integrated with windows, nor can I find any programs for burning that can work under windows vista. Any suggestions Hi Nickname, As you noticed, there is nothing integrated into Windows Vista. This is unfortunately due to resource constraints (lots of localization, testing, etc. required on every change). We realize this (and ISO image mounting in virtual drives) is a major missing feature set, and are considering our options to meet this need. Unfortunately, I can't really say more than that right now. The functionality of writing ISO images is fully supported by the IMAPIv2 interfaces! If you write code, it's trivial to implement a method to write an ISO image. The basic steps: (1) Create ...Show All
Visual C# Commandline arguments question
I am starting a process after setting some command line arguments. Is there any way that I can see what actually executed on the command line along with all the arguments that were passed Is this information stored somewhere after the process is started The reason I'm asking is that I am using a companies command line FTP program and I keep getting told that I am using bad command line arguments. The arguments I'm passing are valid, but I want to check to make sure that is actually what is getting executed. Thanks in advance! Sure... //Commandline FTP Process FtpProcess = new Process(); FtpProcess.StartInfo.UseShellExecute = false ; FtpProcess.StartInfo.RedirectStandardOutput ...Show All
Visual Studio Team System Use 2 TF-servers at same client.
We have TFS running on a test server and a production server. I want to be able to switch between the two without having to disconnect and reconnect, so I just started VS twice and connected to the test server in the first IDE and to the production server in the second IDE. However this does seem to cause some problems, when working with work items, because the test server and production server have different work items and workflows. Is this configuration supported It sometimes happen that I'm unable to save a work item because the TFS server reports "There may be a problem with the workitem type definition" or "Not supported field or not enough permissions" (these are not the exact m ...Show All
Visual Studio Tools for Office VS 2005 Pro, VSTO and Office 2003 Professional Enterprise Edition
anyone, i'm sorry if you've answered this question a hundred times. i looked through all your FAQ's and comments and the web in general on the compatibility of these programs and tools. On my work computer supplied by Intel, I'm running Office 2003 Professional Enterprise (has Infopath), VS 2005 Pro and VSTO (trying to run). i'm aware from your requirements from the MS Product Info page that you need the standalone versions of Excel, Word and Project or whatever since i'm running the Enterprise version of Office 2003. i don't understand why you need a less powerful version of Office 2003 with the integrated versions of those apps for this to work. is there a config, a fix or patch to downgrade my Office 2003 Pro EE (remove InfoPat ...Show All
Visual Studio Team System Data Generation pre and post scripts?
Is there a way to have a pre and post script run for a data generation plan I have the situation where I'd like to disable specific triggers before the data generation plan, and then re-enable them after the data is generated and inserted. If this is possible, I can't find it. Here is a way to do this using the DatabaseSetup.cs and SMO to disable the triggers in the target database prior to data generation. First, include these namespaces: using System.Data.SqlClient; using System.Diagnostics; using Microsoft.SqlServer.Management.Smo; using Microsoft.SqlServer.Management.Common; In my sample (this is just to get the idea across) I modified the InitializeAssembly to exhaustively disable all In ...Show All
.NET Development i dont have idea what is wrong in my project - plz help
hello please look at my 'project'...i dont have any idea what is wrong, Im just starting in programing... here he is ttp://rapidshare.com/files/13127386/baza_pracownikow4.rar If DB isn't a module or project level variable, then that's the problem. To fix it, you could declare it locally, for instance at the Top of the subroutine right after the definition. this would scope it for the rest of the function. However it depends on what the logic is supposed to do, if it needs to be reused then it should be a property. ...Show All
Visual C++ Getting the address of a reference.
Since a reference is a special kind of objects which holds the address of another object and often is not ever allocated, we cannot get the address of a reference using "&" operator. I think there is a situation when we really need the address of the location which is used as a reference. For example, let us try to implement an old-fashioned function having a variable number of arguments, like this: void MyPrintf(const std::string & format, ...) The implementation of such function will use the well-known va_start macro: void MyPrintf(const std::string & format, ...) { va_list argptr; va_start(argptr, format); // incorrect initialization of argptr ...Show All
Visual Studio Tools for Office VS2005 errors after upgrade from VSTO v3 CTP to VSTO 2005 SE
Hi, On a Windows Server 2003 I had VS2005 Team Edition and VSTO v3 June CTP installed. I uninstalled the CTP and installed the VSTO 2005 SE release package. I have Office 2003 (without Outlook 200) + Office 2007 B2TR installed I tried to create a new 2007 Add-In (checked Word and Outlook). Both gave me this error open project creation: "The type initializer for 'Microsoft.VisualStudio.Tools.Applications.Hosting.VCG' threw an exception." I deinstalled VSTO2005SE, did a repair of VS2005. Checked that the old VSTO project types are back, reinstalled VSTO2005SE and I am back at the above error. Any ideas -- SvenC please read the installation instructions, especially step #1. http://www.microsoft ...Show All
Visual Studio Express Editions Printing in Visual Basic 2005
As powerful as the printing functions are in .Net they are still hard to use for casual users like me. I thought it might be useful to share 2 approaches to printing which I have found very useful. The first is using native VB code with a technique based on Rod Stephen's Visual Basic 2005 Programmer's Reference (Programmer to Programmer). I modified this code so that with one line I can set text as follows: FontSize As Integer Text As String FontName As String FontStyle As Integer AdvancePrint As Boolean - advance vertically down the page to end of block of text, to allow multiple blocks/columns of text at same place horizontally LeftMargin As Integer TextWidth As Integer '0=full width, width of rectangle containing text , height dep ...Show All
Commerce Server Application Logic... How to do ?
HI there ! I have the following problem... I need to create a SIte (I hope with CS2007) where I manage a number of Supplier each one with its Catalog. Pratically I need to BUY something from someone... I DO NOT NEED to SELL something... I want to manage my Supplier with their Catalogs and then make an order to them for buying their products. The question is: May I use "something ready" in CS2007 or I have to develop everything by myself If I understand correctly, you're looking for a way to coalesce several suppliers into a single web site. Commerce Server does offer some functionality for this, but it requires that you coordinate heavily with your suppliers. You'd start out with a pretty basic site (t ...Show All
Game Technologies: DirectX, XNA, XACT, etc. XNA Source Control
It appears there's no way to plug in source control in XNA Game Studio Express. Is there a fix for this coming up And supposing that there is no fix, is there a way to use XNA with a different IDE Thanks. The express edition of XNA will not plug into any of the retail versions of Visual Studio. However, theorectially you could manually use the XNA assemblies with the retail versions. But you will loose all support for the content pipeline tools that will be included in the release version of XNA. This has actually been one of the most asked questions on this board. If this feature is important to you, I would suggest takeing a look at this post on David Weller's blog and follow the directions: Subm ...Show All