zensunni's Q&A profile

• SQL Server Security Fact Table

  Hi, I am trying to implement 'Security Fact Table ' approach in SQL Server 2000 / AS 2000. I need to do implement 'security fact table approach ' as a pilot / proof of concept to show that it works. I found the following article useful and followed exactly the same steps as described in the http://www.mosha.com/msolap/samples/Dynamic%20security.zip http://www.mosha.com/msolap/samples/Dynamic%20security.zip I am getting errors in the following MDX script as shown in the attachment. (the same problem with Microsoft support solution too ...) I have followed exactly the same steps described in the above download 131 Dynamic Security dwickert Script.doc document (Technique #2 Security Cube: Page 6 ). ...Show All

• Visual Studio Tools for Office Deployment Problem with Outlook 2003 Add-In

  I created an add-in for Outlook 2003 using VSTO2005 SE Beta and Visual Studio 2005.  The add-in worked great on my development machine, but getting it to work on a client is a different story.  At first I tried copying the addin.dll over to the client machine and adding it to Outlook through the COM Add-Ins option.  I discovered that wouldn't work, and I should probably use a setup file.  I've also tried the setup method using the tutorial provided by Microsoft at http://msdn.microsoft.com/library/d...Walkthrough.asp .  Needless to say, this didn't work either.  It has been a huge detriment to my time trying to get this to work. To simplify things, I started a new Outlook 2003 Add-In solution.  ...Show All

• Visual Studio Remote debug Web Forms/SQL Server app under IIS 6.0

  We have a nearly completed Web Forms app, using SQL Server 2005 through ADO, that was developed in C# with Visual Studio 2005. It has been tested during development with the built-in VS 2005 Web server. Recently we deployed to IIS 6.0 running under Windows Server 2003 R2. This server is destined to become an auxiliary server at a customer site and is currently a workgroup member in our development environment. We use an IIS application pool with IIS 6.0 isolated worker processes and have configured the Windows and SQL Server account permissions so that the app runs without using Administrator level privileges. At this point the app has been deployed in stock form with source located on the server and with debug enabled. It run ...Show All

• SQL Server SSIS advantages

  This may be too general a question but I'm going to ask it anyway. I'm moving data from a source DB (say A) to a target DB (say B). On A I need to join 3 tables and, after some lookups etc., I need to populate several tables in B. Inserting into B's tables involves sequential operations because in many cases I have to get back the value of an Identity column to use as in input value in a another table 'downstream'. Additionally, the tables in B are populated as a group i.e. if the insert on any one fails the entire group's insertion needs to be rolled back. I set up a set of stored procedures to do this. The master Stored Proc opens a read-only cursor and for each row of the cursor executes the other SPs in proper sequence. Some of t ...Show All

• Visual C# Disable Screen Saver

  I was wondering whether there was a ". NET " way to disable the screen-saver I found MSDN Documentation for a DirectX 9 command to disable all video effects (Font smoothing, monitor power management and the screen saver) and I know it is possible for CE in unmanaged code (reset the timeout clock every so often) but I was hoping . NET 2.0 might have some way of achieving the same thing. Take a look at http://www.pinvoke.net/default.aspx/user32/SystemParametersInfo.html for more detailed info. ...Show All

• SQL Server Report Execution timeout after 60 minutes (1 hour) - Execution cannot be found (rsExecutionNotFound)

  Dear Colleagues I wonder if you could help me. I have a report that runs for from 0 to 1,5 hours when executed. If the report executes and renders output file in less than 60 minutes - it works fine, but if only it takes more than exactly 60 minutes to run it generates the following ASP.NET exception: ReportServerException: Execution 'lmxn1q3k3zdxwjvavsargonw' cannot be found (rsExecutionNotFound) At the same time if I make a subscription to save report for example to network share it does not stop at 60 minutes and saves data to the required folder (I've scheduled it this night and the report was saved after 1,5 hours of execution). The report server Report Execution Timeout setting is set to never expire . I also tried to ...Show All

• Visual C++ Accessing the vftable (vfptr) without constructing the object

  I am sending messages across a network. I have created my base class NetMessage with virtual functions. I can send the message across the network, but I need to patch up the vftable pointer. Is there a way to access the address of a vftable without instantiating it Derived::__vfptr and Derived::`vftable don't work (I'm using VC 2005). The best I've been able to do so far is : int vfptr = 0; BOOL unused; new(&vfptr) Derived(unused); (where the derived class has an additional empty constructor with a Boolean parameter to differentiate it.) This doesn't stop any member variables being constructed though. Can anyone help Thanks Jonathan, but I can't find any relevant information on "dispa ...Show All

• Community Chat Firefox 2

  Yay! firefox 2 is being released at 8pm today!! Hooray! just thought i would let you know... Brian Kramer wrote: After installing XP2 SP2, Firefox really wasn't worth it anymore. It takes too much memory as well. The tabbed browing was nice, but I had something similar with the IE6 addon. Yes. what's its name Maxtrom Regards. ...Show All

• SQL Server Draw Bitmap from Points in report

  Hi, i have a database field that has a drawing stored as points, for example.... (x1,y1)(x2,x2)(x1,y1)(x2,x2)(x1,y1)(x2,x2)(x1,y1)(x2,x2)(x1,y1)(x2,x2)(x1,y1)(x2,x2)(x1,y1)(x2,x2) In my VB.NET application, i can take those points and recreate the image. I need to do the same in reporting services... i am trying to replace a legacy ACCESS report, that had the drawing object. How can i recreate the image in reporting services is there an easy way to do so i believe i tried to create a class and tried to reference it and call the function to return the data as an image, but i got a system.drawing not found error... Thanks for posting a reply ill try it first thing in the morning.... The drawing i ...Show All

• Windows Search Technologies no e-mails are indexed

  just installed latest version of windows desktop search on my home computer. I use it at work and think it is great. However at home no e-mails are indexed it does not seem to recognise that I have outlook installed. I have outlook 2003, windows xp, service pack 2 and latest updates. Any help would be appreciated as i would really like to be able to use this at home too. thanks Does anyone else have any other ideas I've uninstalled/reinstalled WDS (w/out the tooldbar, because it won't let me install the toolbar because I don't "have" outlook installed) too many times to count. I've reinstalled Outlook 2003 twice & still nothing. The box next to Outlook 2003 is grayed out because &q ...Show All

• Visual Studio Team System Change home site for new projects

  Hello! How i can change home site for new projects Need change servername from http://SRV01/sites/ProjectName to http://srv01.domain.com/sites/ProjectName Best Regards Ivan Mokrotovarov You need to use TfsReg.exe to change the registered URL's for sharepoint ("Wss") access. get the current xml edit it to change the url's for sharepoint access tfsreg.exe the xml http://blogs.msdn.com/jmanning/archive/2006/10/12/getting-the-xml-for-running-tfsreg-exe.aspx ...Show All

• SQL Server Get Dataset values in text box

  Hello, How can I get all the dataset value in textbox. e.g in dataset I jave field call "CustomerName". I would like to get in the textbox all the cutomer name seperated by ",". Is the same as I can use join(Parameters!CustomersName.Value,",") but I need to do that from the data set and not from the parameters since I don't have parameters for my customer name Thanks Hi Idanle!! i am trying to do the same thing... could u find finally a more elegant solution Thanks in advance!! Sergi ...Show All

• .NET Development How can I run an User Control using a Web Application...

  Framework Version1.1. I have a User Control inside a Windows Control Library named WCL1. I embed that User Control inside the web Application(named WA1) using <Object> tag.. Along that I have Add the reference for the WCL1 Now if I access through. http://localhost/WA1/WebForm1.aspx means it works... But if I access through IP Address for eg.. http://IP/WA1/WebForm1.aspx means it will not works... Please anyone give me an Idea.. What's not working .... Just the control... the page.... any error msg Rgds Rodrigo ...Show All

• .NET Development ASP .NET Web Service in .NET 2.0 upgrade to .NET 3.0

  I wrote a simple .NET Web Service and client under .NET 2.0 If I want to run it under .NET 3.0 and get the advantages of the new release what do I have to do I have VS 8.9.5, and the ABOUT page says its using .NET Framework 2.0.50727 DO I have to upgrade my VS, I think I have the latest, not sure Do I have to recompile, or just run the 2.0 code on a machine containing .NET 3.0 Do I have to redeploy the service onto IIS I am a litle uneasy about compiling with the pre-release software at this point, but I have one question If I am using the latest version of VS 2005, and compiled and am running on a machine with .NET 3.0, Does that mean my service and client are running on .net 2.0 or 3.0 ...Show All

• Visual Studio Express Editions Textbox won't accept null value

  I have a gridview of my dataset and under that i have a details view (textboxes).  If i enter a dollar amount in the cell and then delete it, it will accept that there is nothing in the cell.   When i do this with the textbox it will not leave the box unless i put a zero.   That is ok but i am trying to keep my cells clear of a bunch of zeros. And it only does this after i have entered an amount in the textbox or the cell. Is it the datatype that is the problem   How can i get around this with the textbox Thank you for any help.   ...Show All