lmp8874's Q&A profile

• SQL Server Transforming Old Data to a new database with different relationships

  Long Story Short: Older 15 year old non-relational database (Progress) which started flat tabled and evolved slowly, incorporating artificial relationships. Data is dirty (abandoned tables, fields, rows, hats, etc). We're constructing a new SQLServer2005 version and we need to transform the data over. We've created About 20 tables (of about 60...) and made them relational. We've researched datatypes, how to make faster queries and a sma ...Show All

• Visual Studio 2008 (Pre-release) WinFx self hosted service running over http.

  I have a winfx self hosted service running over http. [OperationContract(Name = "Test")] bool Test(); 1.) With asmx webservices requests I can read the http header values about where the request is coming from. ip address, mac address, etc, using Context.Request.ServerVariables LOGON_USER REMOTE_HOST REMOTE_ADDR LOCAL_ADDR HTTP_REFERER HTTPS 2.) I also could tell if a client request was abandoned or timedout before the server res ...Show All

• Smart Device Development Pocket Access

  Hello guys, i need to create new Access tables on PPC2003SE then read from and write to them, of course programmaticaly. Does anyine has an idea on how this is possible thanks a lot in advance To be more clear, i have an Access file on my desktop that contains tables that has the .mdb extension, when i transfer it to my PPC 2003 SE emulator with ActiveSync, it gets the .cdb extension. Once on my PPC 2003 SE i need to ...Show All

• SQL Server Connecting to hosted / remote database

  Hello, I would like to know whether is it possible to administer a database on a hosted site - i.e inserting some lines, executing a query. I normally access the files via ftp connection. And so far the only way I figured I can mess around with the database is to download it and change it on my desktop PC. Thank You. Toma Pajonk they would need to open a port (which is not advisable) port 1433 by default. the best solution i ...Show All

• Smart Device Development How to change current UI culture at runtime?

  HI. I have a form and I want to change its UI culture at runtime. The method System.Threading.Thread.CurrentThread.CurrentUICulture = ... does not working in .Net CF. I am using VS .Net 2005Beta2, C#. Thanks. System.Threading. Thread .CurrentThread.CurrentCulture = new System.Globalization. CultureInfo ( "en-US" ); ...Show All

• .NET Development Parameterized queries

  When using a parameterized query such as: SELECT LocationID, StreetNum, StreetName, rowguid FROM tblLocations WHERE (StreetNum = @StreetNum) AND (StreetName LIKE @StreetName) Is there a way to automatically add % to the beginning and ending of the parameter I've tried the following command: SELECT LocationID, StreetNum, StreetName, rowguid FROM tblLocations WHERE (StreetNum = @StreetNum) AND (StreetName LIKE '%' + @Stre ...Show All

• Visual Studio Labels on deleted files

     I have a project with several deleted files.  As development went on, the project was labeled and this label trickled down to the individual files.  If those deleted files are recovered, they now show the labels added after they were initially deleted.  Now when I get a project based on a label, these files show up even though they have nothing to do with the project at that moment in time.  Is there any utility ...Show All

• SQL Server When can we use Profit chart?

  Hi, all here, I have a question about profit chat (with parameters population , fixed cost , individual cost , revenue ), so in what kind of cases or scenarios should we use the profit chart Thanks a lot  in advance for any guidance. In general you use it when you select a target - e.g. if the user responds "Yes" I make $10, if they respond anything else I make nothing. You can also use it as "If I correctly ...Show All

• Visual Studio Express Editions Why MS SQL 2005 Express gets installed with VB.NET 2005 Express Edition

  I do not want to use MS SQL 2005 Express with VB.NET 2005 Exp. Ed. Can I uninstall it Will VB.NET IDE work without it Can I use MS SQL 7.0 server as that is what we are using in all our developments in VB 6. Is there a better Enterprise Manager for MS SQL 2005 Exp. as what is given currently is a piece of ***!... I tried SQL Manager 2005 for SQL Server but it could not connect to MS SQL 2005 Exp. what is happening here Is it possible to use ...Show All

• .NET Development How to retrieve current SQL-Command of DataAdapter?

  Hi, is it possible to get the current SQL-Text of the DataAdaper at the moment when it updates the database with the Insert/Update/Delete-Commands I mean: Set a breakpoint in the RowUpdated or RowUpdating-Event and get the current sql-text of the row - without the placeholders (' ')... if you are using SQL Server as backend, you can even try SQL Profiler to catch the actual executed command ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Software pattern for sequence handling

  Hello, can someone give me some pointers on where to find a good software pattern for structuring playback of predefined animation sequences (or any event that I would like to take place) in games The animations/events should be played back in structured order with exact timing. I have a set of animations that have a specified starttime, I need to take into account two types of animations; animations that are stored in .x files and animations th ...Show All

• Visual Basic Is there a way to highlight code?

  Is there a way to highlight lines of code in the VS IDE It would be cool to be able to highlight individual lines or blocks of code in custom colors. ...Show All

• SQL Server Numeric column names are pre-pended with "ID" string

  Hello I'm using SQL Server 2005 Business Intelligence Studio and have noticed an odd behavior with column names. Specifically, if you query for a table that returns a numeric column name it is pre-pended with "ID". For example, if my databaseReporting Services will show these fields in the "Report Datasets" as follows: For example, "Select identity as '1' from group_header, 1" shows a column name of & ...Show All

• Windows Forms How do I TOGGLE a font style in a richtextbox ?

  I have a form with a RichTextBox control on it (RichTextBox1) and three buttons: btnBold, btnItalic, btnUnderline. Attached to those buttons is this handler code for formatting the selection. I've tried different formatting styles on each button:   Private S ...Show All

• SQL Server Have to install to c:\ ?

  I'm having a hard time with installation of SQL 2005 on Windows Server 2000. I'm trying to put everything on d:\ but I think it is failing as a result. Is there anything I should know about this Thanks in advance. -Greg As a follow up on this, as soon as I installed everything to C:\ everything worked stellarly. In listening to the traffic here, it appears 98% of SSRS users are using a non-distributed configuration. While the product supp ...Show All