Dee_dotnet_79's Q&A profile

• SQL Server Incremental Update

  Good afternoon, I was wondering if someone could help. I'm busy researching into SSAS's capabilities, specifically Incremental Updates, however this would be the first time I'm working on SSAS, so I don't know where to begin. I've read through the BOL July 2006, and it explains that you have to enable this option; however to me it's not very clear. I followed the steps outlined in the Book; however when I go and update the source table, the partition does not update automatically. Could anyone please let me know if there is a website detailing how Incremental Updates work, and also how to set it up correctly Thanks Colin. Hi Thomas, I managed to get my Fact Partitions to automatically update ...Show All

• Software Development for Windows Vista Long running workflow exposed as web service

  Hello all: I am trying to write a workflow for a requests system. We want this WF exposed as a webservice. A user would go to a CreateRequest.aspx page, fill out the form and hit submit. Submit calls a CreateRequest function on the webservice. The WF then populates a business object, validates it (ensure date needed > today and a Title is given) then saves the business object into our database. At that point we need to workflow to just sit around and wait for something to happen to the request (assign it, change its status to "In_Progress", "Testing" etc). There are various steps for this process (DirectorApproval, Work_In_Progress, Testing, Read_For_Installation, etc). So, how do we do this with web services A ...Show All

• Visual Studio 2008 (Pre-release) "remote side security requirement was not fulfilled..."

  I am new to WCF and want to learn about setting up security between server and client. I have read Keith Brown's article in the August MSDN magazine, which explains things clearly but I need more sample code, showing particularly how to configure endpoints, bindings and behaviors to set up message-based and transport-based security via the app.config file. I have come across a couple of blog entries with sample code, but they are from earlier times and the APIs have changed sufficiently that they don't build any more.   I am now using RC1, the latest. (Trying to figure this out from just reading the docs is HARD!) I don't think the error has to do with protection level, if you didn't change the ...Show All

• Visual Studio Team System Suggestion: Refactor across a whole project

  The schema that I am currently working with has over 1000 tables in it. It was created using scripts that have been adapted from oracle scripts. Obviously the person that did the conversion didn't bother about things like best practice and just did a find and replace on the Oracle script until it got to a syntax that SQL Server would accept. Hence we have the following problems now inherent: Every field that should be an integer is a numeric(8,0) We have VARCHAR(1) fields. This is bad practice - they should be CHAR(1) These VARCHAR(1) fields contain the value "Y" or "N". This would be better represented as a bit field. Loads of others... I am not going to go through 1000 tables to search for all ...Show All

• Visual Studio Team System Can you profile the System assemblies as part of an app

  I am profiling an application that references only the system assemblies and while I see the calls into the .Net Framework I do not get to see any calls deeper in the call stack for the .Net Framework. This makes sense to me because I am not instrumenting the .Net Framework assemblies. When I try to add the .Net Framework assemblies to be instrumented I get an error message that says: C:\WINDOWS\Microsoft.NET\Framework\v3.0\Windows Communication Foundation\System.ServiceModel.dll has been signed. Instrumenting will break verification. Either turn off verification for this assembly or re-sign it in the post-instrumentation step. Press OK to attempt to profile anyway. I understand the post-instrumentation event is used to re-sign, b ...Show All

• Architecture where to put the generic code to check for browser language?

  We are building a website in three languages English, Spanish and German. On every web page that is being accessed by the user we need to check the language of the browser to retrieve the correct data. Our question is what would be the best location for the generic code to check for language. Should we put the code in the Page_Load of the master page since every page is build using the master page Or should we have a CommonPage.cs which all other pages inherit from Or do you have any other/better ideas What is the best practice Thanks, Newbie! I agree but he didn't say he had a framework (though he did ask for ideas so maybe he'll build one based on you ...Show All

• Visual C# confused with runtime error and compiletime error

  class B { int32 x; } class D:B { int32 y; } B b = new System.Object(); //This statement will cause a compile time error. D d = (D)b; //This statement will cause a runtime error. I am really confused, I can't find out the differences between the two statements above, I think they are the same.Who knows why Any help will be appreciated. You're example is malformed. In the latter case you use an explicit cast that bypass compiler type checking. Try this instead. B b = ( B ) new Object (); D d = ( D ) new B ();    Both compile and both raise an InvalidCastException at runtime, as expected. ...Show All

• Visual Studio Team System external ips and fw

  setting up a nat server thats shares my internet conenctions is easy but, is there a way in windows i can use an external ip range and block ports i domt whannt people too you from inside my lan. Can windows 2003 do this ore to i need exstra programs. I know this can be done in linux whit iptables and stuff but i relly prefure windows. This forum is dedicated to the setup and installation of Team Foundation Server. For Windows questions, please try the Microsoft Newsgroups . In particular, I think the Networking newgroup will likely have folks able to help you out. Best of luck- Cheers, Adam ...Show All

• Visual C++ Abstract class object

  i hav read in all books dat we cant create object of abstract classes.. . and reasons like they are too abstract to create an object.. .. i want to know more of these reasons why we cant create objects...... . . . . manish hello AFAIK, Abstract class is incomplete, which means it has at least one pure virtual function. When we create an instance of an object, a certain memory space will be allocated to contain this object, abstract class does not have enough information to achieve this allocation. so it can not create an abstract object. Supplement is welcome :) Bite ...Show All

• Visual C# windows application

  hai all whether the windows application can be used in web application If so explain me in detail. with regards shankar sofist india hey_imsankar@yahoo.co.in no it can't really, you have to make the application into a web application, unless you create some embedded control or something which shows the WinForms app within the WebApplication, but the viewer has to have .NET Framework installed for this to work I believe and is pretty tricky embedding a winform app into a WebApp ...Show All

• SQL Server Use an equivalent of ROW_NUMBER() in SSIS package

  Hi, I would like to use an equivalent of ROW_NUMBER() T-SQL function in a SSIS package. I could create a temporary table and use a SQL request with ROW_NUMBER() function but I would like to avoid that and generate this column in the dataflow. Is there an easy way to do that Thanks, Arnaud Gervais. Thanks Darren But I have a lot of deployment constraints and I can't use an adding component in my project. I would like to have an easy way to do that with transformation or script tasks in my package. Do you have another solution Arnaud. ...Show All

• Microsoft ISV Community Center Forums Problems installing Business Scorecard Manager

  I am trying to install Business Scorecard Manager on a windows 2003 server, with the standard edition of SQL server 2005 installed. I have followed the instructions in the readme, and I have read all the advice in another thread in this forum: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=104790&SiteID=1 The failing dependency I have is: Microsoft SQL Server 2000 Notification Services 2.0 SP1 with Engine Components and SQL XML 3.0 (SP3) I have not installed the notification services service pack for SQL server 2000 as one person mentioned he had done (in conjunction with msde I think) because I don't have server 2000, and it won't let me installed the database components of it anyway. I have SQL server 2005 ...Show All

• Visual Studio Express Editions ADO to ADO.NET

  Hi, i migrate a VB6 Programm to VB2005 Express and i dont understand some parts of ADO.NET! In ADO i often used the following code : SQL = "Select * from tbCustomer where Key = " + CStr(strKey) Set rs = New ADODB.Recordset rs.Open SQL, glbDBConn, adOpenDynamic, adLockOptimistic If rs.EOF Then rs.AddNew rs("SomeFieldsForAddNew") = .... ..... Else rs("SomeFieldsForUpdate") = .... ..... End If rs.Update rs.Close Set rs = Nothing Has onyone a codesample how i can do this in ADO.NET Thanks for your help. Markus Hi Gudel, i know... sorry!! But the good thing in the old ADO way was that i can check directly if a Record exists or not. If not i can make a AddNew ...Show All

• Software Development for Windows Vista Problem with register filters

  Hi all, I have a problem when doing the following line: CoCreateInstance(CLSID_FileSource, NULL, CLSCTX_INPROC_SERVER, IID_IBaseFilter, (void**)&pSource); I get an error REGDB_E_CLASSNOTREG, which means - "A specified class is not registered in the registration database". How can I register it Thanks, Yaniv Looking thru the docs, I don't see any reference to CLSID_FileSource. Perhaps this filter doesn't exist anymore You might try one of these instead: http://msdn.microsoft.com/library/default.asp url=/library/en-us/directshow/htm/directshowfilters.asp ...Show All

• SQL Server The underlying connection was closed: Could not establish trust relationship with remote server.

  Hi, I am installing reporting services sp1 in loadbalanced servers. I keep on getting this error upon installation and upon configuration of target url in the config files. The underlying connection was closed: Could not establish trust relationship with remote server. Its not with the ssl since the ssl uses the full dns and is valid. So i was wondering what else needs to be done to fix this error. Thanks! karen This article describe the reason behind the problem: http://support.microsoft.com/default.aspx scid=kb;en-us;823177 -Lukasz ...Show All