Mgale1312638's Q&A profile

• SQL Server Forcefully Disconnect All Users and Drop a Database

  Hey all, I am trying to write a function to drop a specific database no matter the connection status. I have tried con = new ServerConnection (sql); con.Connect(); Server srv = new Server (con); srv.KillDatabase( "Name" ); ,and also tried Database db= Database (srv, "Name" ); Database db=srv.Databases[ "Name" ]; db.Drop(); None of these worked. That surprises me because KillDatabase is supposed to disconnect all activity to the database, at least that's what it says it does. Thanks. You all most had it all you need is to add the following line and it will work., Database db= Database (srv, "Name" ); con = new ServerConn ...Show All

• SQL Server sp_spaceused bug???

  Hi all I guess sp_spaceused is the widely used stored procedure to monitor the space usage. I have found some interesting things recently in the stored procedure. If you compare the SQLServer2000 and SQLServer2005 implementations there is a dfiference in the way that the various calculations are made. In 2000 , sp_spaceused excludes all the non-clustered indexes with the filter-- where indid in(0,1,255). The 2005 implementation of the stored procedure includes the non-clustered indexes also(there is no filter-where clause), but it has a comment line saying that /* ** Now calculate the summary data. ** reserved: sum(reserved) where indid in (0, 1, 255) this is really strange. It makes perfect sense to include ...Show All

• Visual C# Input Message Box in C#?

  Is there any control like an Input Message Box (users of VB would recognize this) I need a pop-up in the same form (pop-up not being a seperate form or a MDI child) for the Login Id and password Any Suggestions thx in advance, Just add the reference "Microsoft Visual Basic .NET Runtime" to your project. you needs to import " using Microsoft.VisualBasic;" then try to access the inputbox method. For ex:- string x = Interaction.InputBox("hi","hello","nothing",10,10); MessageBox.Show(x); ...Show All

• SQL Server Major Problem!...Multiple user connection problem in reporting service 2000 with SOAP

  Hi Everyone, I am having a big problem here. I am using Reporting Service 2000 and Visual Studio 2005. I have developed a custom web control which communicates with reporting web service and displays report. I pass username, password and domain information as network credential for communicating with report server (report server is remote). This is a web application in which users can see reports on the web page which uses my custom web control. Everything works fine when there is single user. But when another user logs onto website and tries to access same or different report it seems like connection of the first user gets lost. And everything crashes for first user and for second user it works fine. In fact if second user is ...Show All

• .NET Development dll form behaving like an MDI Child form.

  Hi all, Just wondering if there's a quick and easy way of doing this In VB 6, we use API call to made the dll form to behave like a child form of an MDI application. Do any one know of a way to do this in VB .NET I use reflection to call my dll which bring out a form. But this form behave like another separate entity. I want it to behave like a child form to the MDI application i called from. Seems like there's a way to do this in Delphi by passing in Application.Handle to the dll form. Just need some insight. Thanks for reading this far. Dan I had no trouble doing this, but didn't use reflection. Load your Windows Forms project, File + Add, New Project, pick the Windows Control library template. Add your n ...Show All

• SQL Server Using VB file picker

  What would be the syntax to use the VB file picker in the code section I want to do something like =code.Filename in a parameter. Where this would cause the file picker to open and allow the user to use the standard interface to track down the file. Use a data delivery extension. There is a sample that comes with Reporting Services. Check out http://msdn2.microsoft.com/en-us/library/ms160918.aspx ...Show All

• SQL Server How to load data from a data warehouse to a Cube ?

  Hi All, I am just curious to know how I can load data from a data warehouse to an Analysis Service Cube (both to the fact tables and dimensions). Whenever there is a change in the data warehouse, it should be reflected to the fact table and dimension Does any body have some way to achieve this I appreciate if any body provide me a good material which describe this scenario. Sincerely, --Amde I understand what you are saying. I want to confirm one thing. Let's say we have 6 dimension, we need to create 6 jobs and schedule them at the same time. Am I right saying that --Amde ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Loading uncompiled assets at runtime in XNA

  I am working on a game in XNA and have encountered a problem. I want people to be able to mod the game, but I would need to load image assets from .bmp files at runtime. I have not found any way to do this in the XNA documentation. How can I do it Is it even possible You can use Texture2D.FromFile() to load textures at runtime without the content pipeline. Or, you could have modders download VC# Express and GSE and then they can convert their assets so they can be loaded through the pipeline. ...Show All

• Smart Device Development Support for Global Interface Table (GIT)

  Does anybody know if WCE support the GlobalInterface Table. I get a "Class not registered" executing: CoCreateInstance(CLSID_StdGlobalInterfaceTable...) If not, what is aviable under WCE to marshall interfaces across threads. Thanks in advance. JEK Since DCOM isn't supported there is no support for marshalling data across processes. Only inproc COM dlls are supported for devices with minimal COM support (devices like PPC or Smartphone). Thanks ...Show All

• Smart Device Development Printing in Windows Mobile 5?

  I have done a but of looking but can not find a way to print from my Symbol MC70 that runs Windows Mobile 5. Does anyone know if this is even possible And if so, how to setup a printer on the device Thanks, Philip Please don't post multiple messages for the same topic. You've to use 3rd party software to do printing. There is no native support. Closing this as duplicate. Manav ...Show All

• Visual Studio Express Editions C# almost double as fast as VB.NET?

  Check this out: C# code: using System; class SpectralNorm { // // // // Var Def // static DateTime startTime; static DateTime stopTime; static TimeSpan elapsedTime; static long elapsedMS; static void Main(String[] args) { startTime = DateTime.Now; int n = 1000; if (args.Length > 0) n = Int32.Parse(args[0]); Console.WriteLine("{0:f9}", new SpectralNorm().Approximate(n)); stopTime = DateTime.Now; elapsedTime = stopTime.Subtract(startTime); elapsedMS = (long)elapsedTime.TotalMilliseconds; Console.WriteLine("Elapsed Time: {0}", elapsedMS); Console.ReadLine(); } double Approximate(int n) { // create unit vector double[] u = new double[5000]; for (int i=0; i&l ...Show All

• Software Development for Windows Vista Lockup

  Hi. I like CardSpace, and I have had it working since it came in Windows Updates. But today when I ran it (and I've tried a few times) It just sticks at "Please wait while Windows CardSpace loads". It doesn't do anything, except stick there and display the egg-timer cursor. My only way to get out of it (as Windows key doesnt work, ALT+F4 doesn't work, CTRL+ALT+DEL doesn't work, is to restart (I use the hardware reset button). Anyone know why it's locking up There was no progress bar. I opened it from the Control Panel>Users>Windows CardSpace (well, a shortcut I've created to there, but I've re-tried using the control panel method) ...Show All

• .NET Development .Net client for a secure Java web service

  Hello, I want to create an .net client for a secure Java web service, deployed under SSL. I want this client to accept whatever server certificate. With Java + Apache Axis, i1ve done that using the following line of code: AxisProperties.setProperty("axis.socketSecureFactory", "org.apache.axis.components.net.SunFakeTrustSocketFactory"); Is there a way to do something like that in .net thanks in advance If the certificate is not trusted, expired or not issued for the server, the client will refuse to talk to the service. Unlike people, who can make some conscious decision about whether they are willing to trust a service given something is fishy with a certificate, a service cannot do ...Show All

• Visual Studio 2008 (Pre-release) How to get HDC of a control?

  Hi! Can anyone help me with this: How can I get HDC of any control in WPF Is it possible at all If not, then can I at least place a control (which does some stuff using hdc of a child control) which was created earlier in .NET 2.0 onto a WPF form and perform all these great manipulations (scaling, rotating) Thanx for any help! Thank you for the reply! But I just wonder what is going on So, basically, is Microsoft going to make us be able to use previously created in WinForms (.NET 2.0, .NET 1.1) controls (not that simple to develop them again, really) Are these issues only related to CTP (Beta) stage of the development Or should we prepare for the worst :) Thank you for any clarification ...Show All

• SharePoint Products and Technologies Meta tags in MOSS 2007 master pages

  Does anyone know how I might go about inserting meta tags such as "description" and "keywords" into my master pages and page layouts in a MOSS 2007 external facing site Ideally, when an author or editor is editing a page, I want field controls for the meta description and keyword tags, so the author can fill those in and save those with the page content. The problem is that I can't put a server control like a contentplaceholder inside of the content="" attribute on a meta tag. I've tried the following: <meta name="description" content="<asp:ContentPlcaHolder ID="PlaceHolderMetaDescription" runat="server"></asp:ContentPlaceHolder>" /> The ShareP ...Show All