rhansen's Q&A profile

• Visual C# How to copy a DB, with Smo?

  Good afternoon. How, with Microsoft.SqlServer.Management.Smo, to copy a database under other name (i.e. the DB - bd1 should be copied it in bd2. Business occurs on one server MS SQL 2005) But to copy, so that transferred all procedures, triggers, ... . Thanks! You should execute TRUNCATE TABLE TableName command for every table that should be cleared.  Why not explain the task a litle more, and maybe someone will give better (or completly different) way of doing the job. ...Show All

• SQL Server Need advice on expanding to Direct Attached Storage

  We are currently using an application which uses SQL Server 2005. Both sit on the same box. This month we're adding another piece of software to our network on a new box which also depends on SQL Server. Since we don't have a directed attached storage device to store (as recommended by Microsoft), we're contemplating installing SQL Server again just for this application. Of course this means that we have to maintain two separate SQL Server databases. Any thoughts on what we should do Thanks Hi, You can install and run two or more instances of SQL Server on a server. But this means increase in number of services and maintenance (like SP upgrades, etc). But if you have different instances, you can restart an instance withou ...Show All

• Visual C# Direct Saving

  Hi, I've got some code for saving, but I want to direct it so it always saves in the same folder as the same file. Could somebody please update this text StreamWriter writer = new StreamWriter ( "File.txt" ); writer.WriteLine ( "This should be saved in the same spot." ); writer.Close(); Thanks. Hi, you probably want to save the file in a specific folder To do so, include the folder name in a string, where you're specifying the filename: using ( StreamWriter writer = new StreamWriter (@"c:\MyFolder\File.txt")) {     writer.WriteLine( "This should be saved in the same spot." ); } Also, you can check the Environment object for some system/user-defined paths, like ...Show All

• Visual C# Should I use Dispose in this situation

  hello, i'm initiating an object inside a method: private void Example () { MyClass ins = new MyClass(...); ins.AMethod(); ins.Dispose(); } i'm wondering if the last line: ins.Dispose(); is necessary Or C# does it automaticlly ... i mean disposing the object as soon as the method is finish. please advise Hi, It is very advisable to call an objects Dispose method. If the object is implementing IDisposable, or has a dispose method available then you'll need to call it. In your example, after the method finishes executing your object would be removed by the garbage collector. But what if that object uses a umananged resources That is when memory leaks appear. So as a precaution, alwa ...Show All

• Gadgets About updating and submissions

  I think this is a message for the aproval team. The 1st when I submit a webgadget for spaces (ok live.com too) both add buttons where availble http://gallery.live.com/liveItemDetail.aspx li=e140b8bc-72e8-4902-8adf-3036e327cfd2&l=1 after we''ve updated only the live.com add button is visible. What's the policy Ergo the space button should be added too after the update, maybe it's a good idea too ad checkboxes for a which buttons should be added Or should we include a readme.txt for the approvement team. Thanks in advance ...Show All

• SQL Server Sql 2000 Connection Problems

  I am trying to install Sql Server 2000 at the moment but when i try to connect to local Windows NT server i get this messege http://img293.imageshack.us/img293/3263/connection8rq.jpg and if i go to properties of the server i get http://img369.imageshack.us/img369/1335/properties9dd.jpg. I believe it is trying to log in using my Windows Authications. Thanks for any help. James Here's a good place to start: http://msdn2.microsoft.com/en-us/library/ms190944.aspx Buck Woody ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Trouble with 2 sets of texcoords in a custom vertex format

  I created a custom vertex format with a Postion, Normal, Texcoord0 and Texcoord1. This is used for multitexturing with a blend map. So texcoord0 is used for the texture that gets stretched across the entire tessalated surface. texcoor1 is used to tile the textures across the tessalated surface. The behavior that I'm getting is it only acknowledges one set of texture coordinates. So if i use texcoord0 for the tiled coordinates, then the texture that should be stretched is not. and If I use texcoord0 for the stretched texture, then I don't get any tiling. here's my VertexElement declaration public static readonly VertexElement[] VertexElements = new VertexElement[] { new VertexElement( 0, 0, ...Show All

• Visual Basic Please suggest me a MS.IT level project to undertake in my college (inhouse project)

  Please suggest / list me the project definitions that you guys can think about that i can pursue as my inhouse project in my university.   ShadowMan wrote: Hey m8, not that kind of project i mean like a hospital management, remote desktop system, some kind of embedded system, which is really good and interesting in doing.. How about doing a custom database management system then in aspx pages via visual studio or just do it as a standard application rather than a web-site based one Consider Admin and user logins too or consider doing a checkout system that can read barcodes etcetera, that is embedded in the terminals at the checkouts for the supermarket i work for, it has not got certain features that i wish i ...Show All

• .NET Development Remoting between 32-bit and 64-bit processes?

  Will a remoting scenario work where one side of the conversation is a .NET 2.0 app compiled using the x64 platform and the other side is a .NET 2.0 app also running on the same x64 box, but compiled using AnyCPU and therefore running as a 32-bit process These are two separate apps, in case that's not clear. I'm just a beginner with using remoting, so no specific restrictions on protocols other than what would be necessary for same-machine communication. Thanks, Chuck If both are on x64 box, then the process compiled with 'anycpu' will run as 64-bit proces and not as a 32-bit process.. Remoting should work.. An excerpt from www.64advantage.com/files/ Microsoft% 2 0Windows% 2 0 64-Bit % 2 0Technology% ...Show All

• Visual Studio Express Editions MenuItem Question

  How do I add hyperlinks to Menu Items through the code. I wanted to make it where _Click() event would occur and then it would open up IE for the user and send him to that hyperlink. To be more specific My link would be graphed like this: Menu Item "Links" -> Phoenix Fire Homepage and when they clicked on Phoenix Fire Homepage, it would send them to that website using their default browser. ...Show All

• SQL Server error when processing cubes just migrated from 2000 to 2005

  im in the process of testing how to upgrade from analysis server 2000 to analysis server 2005. i have migrated my cubes to a test 2005 server and created a project out of them. when i try to deploy this project i get these two errors: Error 1 OLE DB error: OLE DB or ODBC error: The multi-part identifier "PrintDimensionTransactionDate.TransactionDate" could not be bound.; 42000. 0 0 Error 2 Errors in the OLAP storage engine: An error occurred while processing the 'Print' partition of the 'Print' measure group for the 'Print' cube from the testSRDBProj database. 0 0 these cubes worked fine before i migrated them. does anyone know what could be going wrong the ...Show All

• Windows Forms KeyPress is handled before KeyDown?

  I thought that the KeyDown event was handled before the KeyPress event, but it looked like I was wrong. Can someone please confirm that KeyPress is handled before KeyDown By the way, why the Delete key doesn't get trapped in the KeyPress event (it does get trap in KeyUp/Down events though). Thanks. Hi Under the covers KeyDown is analogous to the WM_KEYDOWN message, KeyUp is the WM_KEYUP message. Key Press is a .net event that's fired after the key comes up. The easiest way to figure this out is to over-ride WndProc in your form with a few Debug.WriteLine / Print statements to see what is happening. Something along these lines: protected override void WndProc( ref Message m) ...Show All

• Smart Device Development check if clicked in region

  Hi, I have an array of points. Those points form a freeform polygon. Now I want to check if the person clicks in or out that region. In the full framework i use graphicspath.addPolygon(array) and then graphicspath.isvisible(x,y); This works fine in Full Framework but in the CF2.0, graphicspath is not supported. Anybody an idea how to solve this Grtz Annihil8 You'd need to do some rather simple calculations yourself, e.g. like this . ...Show All

• Visual Studio 2008 (Pre-release) WSDL Import ,XSD and Soap Address Locations

  Generated WSDL's Import ,XSD and address locations are point to system name . How to replace system Name with domain name please <wsdl:import namespace=" http://www.domainname.com/wcf " location=" http://dedXXXXXX/WCF/Service.svc wsdl=wsdl0 " /> <soap12:address location=" http://dedXXXXXX/WCF/Service.svc " /> <wsa10:Address>http://dedXXXXXX/WCF/Service.svc</wsa10:Address> Thanks See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1095396&SiteID=1 The host headers for an IIS-hosted service can control the ServiceHost's BaseAddresses, which control this in the WSDL. ...Show All

• Windows Forms Saving TreeView information;Loading TreeView information from files

  Greetings MSDN members! I am working on a branched dialog editor for my text game engine and have run into a problem, but before I get into the problem I would like to explain what it is I am trying to do. The developer will use a GUI editor to create some branched dialog. Each dialog entered into the branch will be given a command. The engine takes that command and will either show the dialog as being from the player, NPC, monster ect. and if it has a command for giving the player a skill or item ect. it will due so. I am currently using a treeview to store all of the dialog, allowing the user to create a complete coversation with more than one ending. A user can choose different answers and get different results from the dialog ...Show All