retkow's Q&A profile

• SQL Server Switching reports between database instances at run time

  We are building an application where the same set of reports hosted on the same report server will need to be able to report data from different database instances based on the user running the reports. Has anyone ever tackled this problem, and if so what suggestions do you have for handling this I am guessing we could pass in the database instance to be used as a report parameter, but my guess is that we could then not use data driven parameters in the report because there would be no way to point the data source for the parameter queries to the correct database instance (the one passed via the report parameter for the database instan ...Show All

• .NET Development GC.Collect() freezes for several seconds on gen 2 collection

  I have a server application which manages a few hundred thousand objects in a Hashtable. Each object has to be in memory for fast lookup and access. The keys are not changed so the Hashtable itself is fairly static, but the objects are constantly updated via incoming data and read to serve user requests. The problem is that every 5 minutes or so the GC kicks in and freezes the entire process for up to 4 seconds. This is regardless of whether other threads are running, e.g. even if I do no updates or queries, it takes this long just to create all object graphs for collection, even when nothing is collected (i.e. GC.GetTotalMemory returns ...Show All

• SQL Server Lookup - full caching vs partial caching vs no caching

  I needed to do lookup on tables with approx 1 million records (how else do I know if record already exists ). Full caching: SSIS caches all million records (consuming around 1 GB RAM) and cripples my lowly system with only 1GB physical RAM. This works for now, but the lookup tables will keep on growing. This means that full pre-caching may not scale for this scenario. Partial caching and No caching: I don't really know how SSIS works in these modes. I can make my guesses but it will be great if someone can explain those. The behavior that I see when I use partial cache of varying sizes or when I use no cache at ...Show All

• Visual Studio Express Editions keyboard shortcuts to buttons?

  Hello, is there a way to put shortcuts to buttons like enter Additionally you can click a button using ALT + char combination by adding a '&' in the fron of that char (in the button Text property) like: button.Text = "&File" for ALT + F ...Show All

• SQL Server DATEDIFF question

  Uses: SQL Server 2000 Personal Edition with SP3, Windows XP Pro; Hi, Is there any possible way that I can differentiate 2 different dates and get in a format inclusive of hh, mm, ss part altogether, rather than only getting one part Like this: if StartDateTime = 10:15:01 AM and LastDateTime = 11:20:01 AM then the difference of LastDateTime and StartDateTime will be = 1hour and 05 Minutes and 00 seconds (I need like this). So using DATEDIFF function I will be only getting one part either hour, Minute and Second. I would like to know is there anyway either by using DATEDIFF function or other to get in the format inclusive ...Show All

• Visual FoxPro VFP9: Customize toolbar margin, background picture, border, titlebar?

  I'm wondering if its possible to customize any of the following toolbar properties under VFP 9 Note that while none of these properties are exposed in the VFP 9 toolbar object, there may be alternative ways to acheive these goals via different techniques or through the use of Windows API calls in conjunction with a toolbars hWnd property. 1. margin (area between toolbar borders and child controls) 2. background picture (similar to the .Picture of a form object); I would like to add a gradient background to a toolbar 3. border and titlebar (I would like a borderless toolbar) The margin and background picture questions are related to my de ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Modeling Programm

  Hi! I just wanted to know which 3D modeling programms you are using. I am using Cinema 4D and I would be very pleased if you can tell me some sites with tutorials on it. greetings I think you'll find many professional studios use 3D packages like 3D Studio MAX, Maya or SoftImage. However you can use most anything your comfortable with. Have you checked out http://www.4dtutorials.com/ seems like there are quite a few tutorials there. ...Show All

• .NET Development how to prevent modification(deletion, rename) to an assembly?

  hi , suppose i have an application which uses a assembly "***.dll" and it loads the assembly using reflection and creates a object of it that too using refelection. now i want that if the assembly is loaded nobody should be able to delete it or rename it.how can that be done.more specifically how to lock that particular assembly dll. thanks and regards ramneek .NET does not provide that type of security. You must rely on the normal operating system permissions for files and folders. In other words, it must be installed by a different user (perhaps administrator), the user must not have the same permissions ...Show All

• Visual Basic VB.Net and Access Question

  I am trying to learn how to use access and VB.Net in conjunction with each other. I have a few books regarding them but all i want to learn initally is how to add, edit and delete in vb.net. But the books, even though one is actually called Simply VB.Net, dont seem to show any structure as to how this should be done. Can anyone illustrate to me exactly how an item can be added to a database from various textboxes on a form in vb.net. Can someone show me what structure the code should take and even give me some sample code if possible. Anyone helpin me would be a BIG help. Any books that can help me learn this if you can let me know i w ...Show All

• Visual Studio Tools for Office Problem of Office add-in (C#)

  I have a problem in that I have a MS Word Add-in which works fine on the computer where I developed it (in MS Visual C# .NET) but when I try to deploy it on other machines it doesn t work. To deploy the project I am using the Setup project from the Add-ins solution explorer as per instructions at, http://support.microsoft.com/default.aspx scid=kb;EN-US;q316723 I tried to isolate the problem using some simple examples. I made an add-in that simply pops-up a Message Box in the OnConnection method. This deploys fine on the target machine. Next I tried the simple add-in as outlined in the KnowledgeBase article 302901, How to build an Office ...Show All

• Visual Studio Team System How to set permissions to a field in a workitem.

  Take a bug as an example. 1) How could I assigne permissions to "state" field, so that only users in the QA user group can change the state from "active" to "closed" 2) For a certain field, I only want it to be readonly for user group A, while it is modifiable for user group B. How 3) Another question: How could I set up permissions to only allow users in "QA" user group to create a bug workitem Many thanks. 1) You can control who can change the state of a work item using for and not qualifiers on the transition rule. From the SDK: <TRANSITION from="Active" to="Complete" for= ...Show All

• Visual Studio 2008 (Pre-release) SSL Support

  I am currently implementing a service utilizing BasicHttp binding using XmlSerializer serialization....effectively giving me a bare bones service consumable by a smart devices app. What's the easiest, most straight-forward way to utilize SSL over the Http I don't want any username or password tokens, etc. All I want is SSL encryption over the connection when the smart device client connects. Given the above, I believe I need to use Transport security mode which requires a certificate. Am I correct in assuming this If, so how should I go about setting up a certificate I've come across the ServiceHost.Credentials.ServiceCertificate.Se ...Show All

• SQL Server SQL server express 2005 local accounts problem. please help!

  Hi all, After working for weeks on a project in VB.Net, I decided to deploy a test version on a user's computer. The user's XP SP2 computer has sql server xpress 2005 installed, and my VB.net creation. Everything works without problem when the user's XP account is set with Administrator permissions. But when i change the user account to Limited, the program fails with the following message: "Failed to generate a user instance of SQL server due to a failure in starting the process for the user instance. The connection will be closed." The connection string I'm using is: "Data Source=.\SQLEXPRESS;AttachDbFilename=&qu ...Show All

• Visual Studio VS 2005 SDK: how to nest multiple folders in a project?

  I’m trying to create a custom VS project using the managed framework but I’m hitting the following problem, even with the sample provided in the latest SDK (the MyProject sample): I cannot create nested folders and if I manually modify the project file to have nested folders, the files in the second folder does not show up. The + sign shows up but the items do not. Ex: my project (and files on disk) contain this:     < Content Include = " test\file.xml " >       < SubType > Content </ SubType >     </ Co ...Show All

• SQL Server Problem creating diagrams

  I just upgraded an existing sql server 2000 installation with the RTM sql server 2005 (developer). I went to work on a database that I've been working on for a couple of weeks before the upgrade, and wanted to create a database diagram. However, when I click on the "Database Diagrams" tree node, I get this message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a ...Show All