Mark Ells's Q&A profile

• SQL Server How to make a hierarchy in a document map?

  How to make a hierarchy in a document map In the report designer, I have two levels of grouping: First Level: Country, Second level: City. I have no problem to create a document map containing both grouping. However, the city and country are listed in a sequential order in the document map. What else should I do and how, to make them a hierarchy that looks like a tree (file folder) structure Thanks. Well, go through the connect.microsoft.com site and search for this suggestion., If not listed yet (big doubt) file a new one. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- ...Show All

• Windows Search Technologies CAN SOMEONE HELP PLEASE? WDS STILL NOT WORKING

  Hi Everybody, It's getting very frustrating that WDS Beta 2 is still not working for me. It only works from within Outlook 2007 beta 2 technical refresh 2, but i always get " NOTHING FOUND " from the normal Search Deskbar.This while i basically went through all possible settings 100 times and installed, deinstalled and reinstalled the product multiple times, the last two weeks. Also if i install another search engine, like your friend Google or Copernic, it works instantly. Something must be broken somewhere, but everything else on my computer is working fine and actually it's quite a fresh install. Can somebody please make a point about this and help me out Am i the only one with this problem, i can't imagine. Sure, ...Show All

• Visual Studio Team System Managing Object Permissions using VS 2005 for Database Professionals

  Hello, Does anyone know what is the best way of managing Object Permissions using Visual Studio 2005 for Database Professionals I reverse-engineered an existing database but the IDE created a "post-deployment" script to revoke permissions and then grant them again. The problem is that if some developer decides to add a new Stored Procedure, then he/she will have to remember to add lines in this script too. Is there an easier way to manage this Thanks. Deepak. Dear Deepak, In the current version Post-Deployment Scripts, and specifically Permissions.sql is a proper place to define permissions for your objects. Once it becomes part of the process, Database programmers will remember ...Show All

• SQL Server SP1 Install Caused Problems

  Had a couple questions about some Event ID 6702 errors on the server I’ve been getting recently. I can’t seem to find any intelligible information on Microsoft’s site about it; however, I did find this: http://support.microsoft.com/kb/842006/en-us#XSLTH5294121122120121120120 There are no replication partners for all I know on this server. As far as the A records that it wants me to check, when I take a look at dnsmgmt -> Forward Lookup Zones -> DI-COMM.local, there are several A records for all the machines on the network. The support doc is telling me to delete all A records except those corresponding to the actual server. As far as I know, I NEED these A records for the name lookup to resolve to IP. Wh ...Show All

• Visual Studio Reverting back to another version of a project

  I am constantly creating vastly different versions of the same Visual Studio solution as I program. Is there a way for me to roll back an entire project version or store copies of older versions within the DB Rolling back the version of an individual file is not going to help me. I need to have the capability to revert back to a previous state of an entire project. Is this possible Hi, I've found by checking in the project file (.csproj etc.) and the solution file (.sln) after each change, these can be recovered. Don't check in the .suo if you have more than one developer on the team - these are the user settings for the solution, and differ across machines. Simon Harriyott ---------------- http://harriyo ...Show All

• SQL Server Changing the MDX Query based on a I/P Parameter. Is this possible?

  Hi I am generating report with my datasource to an OLAP Cube. I have scenario that there are 2 dimension tables pointing to a single fact table. According to a user input, i have to use one dimension table and not the other and vice versa. I tried using IIF statement in the MDX query designer., but was facing errors. First of all i want to know if this is possible and if yes, how Also , Is it possible to open a window form on clicking any report data (Similar to assigning hyperlink, but i want to open a window form instead!!!) regard Sai Hi Sai, I am trying out a similar thing. Did you get an answer for this post Regards, Dinesh ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What kind of data will invoke the excution of a GS

  GS provides a flexible way for users to generate new primitives. We want it is more flexible. If we emit some new primitives without use any input data such as position or color. This case supported by current DX10 MS SUPPORT: void GS(inout TriangleStream<PSIn> stream) { PSIn element; element.pos = float4 (0.0f, 0.5f, 0.5f, 1.0f); stream.Append (element); element.pos = float4 (0.5f, -0.5f, 0.5f, 1.0f); stream.Append (element); element.pos = float4 (-0.5f, -0.5f, 0.5f, 1.0f); stream.Append (element); } ...Show All

• Software Development for Windows Vista Drive letter access for DVD in Vista

  I'm a software developer, and have an app that currently uses Roxio Drag-to-Disc on XP for drive letter access to DVD and CD media for write and read. It appears that Vista now contains this type of functionality built-in. Windows Explorer for instance can format a DVD with a UDF file system, and when ejecting a DVD, the user may close the file system, etc. How is this functionality accessed from a user mode app I've searched the SDK docs, but can find no mention of this. Hi Henry; Thanks for your reply. Some more detailed questions now... My program is a backup application. It can use DVD or CD media, either write once or rewritable. For example, using Roxio Drag-To-Disc (on XP), a write onc ...Show All

• Visual Studio 2008 (Pre-release) Problem with Menus and Frames with HTML source

  In a Browser Application, I have a Menu and a Frame on a page and the page opens a web page inside of a Frame. The problem is when the Frame source is a webpag, the menu drops down BEHIND the Frame. If the Frame source is an xaml page, the menu drops down in front of the frame area like it should. Is there any way around this Example: (the amount of menu items is necessary to see that the menu actually does open up and it is under or behind the frame) < StackPanel > < Menu > < MenuItem Header = " Menu " > < MenuItem Header = " Item " ></ MenuItem > < MenuItem Header = " Item " ></ MenuItem > < MenuItem Header = " Item " >< ...Show All

• Visual C++ sprintf for output as binary

  Am I able to use the sprintf function to output text as binary For example, how would you convert text in textBox1 "hello world" to binary I have the code: private : System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { txtBx3->Clear(); String^ myString = gcnew String( txtBx1->Text ); txtBx3->AppendText( myString ); } But I want to make the code in txtBx3 appear as the binary version of the text in txtBx1. Can I use the sprintf function, what is the easiest way of doing this. ********************************************** I AM USING C++ in VS2005*************************************************** In C++, you could do this: ...Show All

• .NET Development Invoke exe from Windows Service

  I want to invoke an exe from Windows Service. I had tried using system.diagnostics.process.start but it is not woking. Is that any idea..to do this......... Please help me...... Thanks in Advance... Regards, C.Babu. Hi RomanGuzi, you right that " processes created by the service cannot display a user interface ." but the solution is still not provide. could you tell how to run a 'window application (suppose a win form) exe' through window serivce onStart()Event. thanks ...Show All

• Visual Studio Team System Development enviromnet setup

  Hi, We are tried to dsign a new developmnet enviromnet and upgrade from VS2003 to VS2005. In order to benefit from the features that VS2005 Team edition has, we think to have one release VS2005 team edition to benefit from the architecture release and many Profesional release. In this design, will the architecture be able to manage the code of all the developers Hi, Actually, I wanted to have one release of VS2005 team suite and many licence of VS 2005 professional. As the developer edition of VS2005 team is no longuer in the market. the purpose was to check if as architect I can manage the design of a code that developers are working on through VS Pro. If I can manage the life cycle of t ...Show All

• SQL Server report server parameters

  Hi! I have a report (*.rdl) in my report server, and this report calls a dataset (by an ObjectDataSource of the reportviewer) that has query parameters. I try to run the report but the following error appears: An error has occurred during report processing. Query execution failed for data set 'DataSet3_generar'. Must declare the scalar variable "@Param1". I read that, when you create dataset parameters that the report should inherits these parameters automatically. And when you upload the file into the report server, when you select it in the report manager and see its properties, it should appear a link of parameters. But my report doesn't inherits the dataset parameters automatically, I tried to do ...Show All

• SQL Server query large database

  Hi, I have a very large table to query, it has 11 million rows because it is a detail one. When I try to query against the table it took approximate 9 minutes. Is there a way to make it more faster I've already use partition scheme and indexes but seems 9 minutes is the fast result. Thanks in advance. best regards, Hi, Sorry not to mention more deeper, I've applied the filter year(trx_date) = '2006' since the result should return by year. And 11 million rows that I mentioned before means all transaction in year 2006. I've applied index on trx_date field with noncluster option. Thanks in advance, best regards, ...Show All

• Visual Studio Visual Studio 2005 Service Pack 1 Beta

  Has anyone else tried to install the beta of Visual Studio 2005 Service Pack 1 Just running the setup program hogs my machine. It literally took over an hour, maybe more, for the message box to come up asking me if I wanted to install it. I tried it around 4:15pm yesterday and since it was still going even past 5pm I just left work figuring it would be installed by the time I came back in the morning. Well, I'm back and all I see is the message asking if I want to install. I say yes and then a few minutes later it comes back saying I have to uninstall the Web Application Projects addon because the release version is included in the service pack. Great, I hit OK and now I have to start all the way over! I've never seen an install program h ...Show All