ctrahan's Q&A profile

• SQL Server Restoring a database from snapshot folder

  Hi, I need to restore a sql server 2000 database which does not have any backups apart from a snapshot folder which contains some .bcp, .IDX and .Sch files. (there was a transactional replication setup on this database at some point and the snapshot folder is still there.) Is this possible any help will be highly appreciated. thanks, Alind sure it's possible, create a database, run the .sch files, bcp/bulk insert the .bcp files into the tables, then run the .idx files. Not sure if there are column or row delimeters, you can open one of the bcp files up and see if there are any. ...Show All

• Visual Studio Express Editions VB 2005 applications to work on Vista?

  Hello, will apps made with VB 2005 run on Vista And, will the VB 2005 Compiler (or whatever you call it) work on Vista Thanks yes it will :-) http://msdn.microsoft.com/vstudio/express/support/readme/ I believe the .NET 3.0 framework will be used to run your .NET 2.0 application, since Vista will ship with .NET 3.0 ...Show All

• Visual Studio 2008 (Pre-release) Use command line option '/keyfile' or appropriate project settings instead of 'System.Reflection.AssemblyKeyFileAttribute'.

  I'm getting this error when I open some of my existing projects in Orcas. I thought using the attribute "System.Reflection.AssemblyKeyFileAttribute" should be the default behaviour rather than /keyfile Chris AssemblyKeyFileAttribute has been 'deprecated' so to speak, and the prefered method is now use /keyfile. The reason for this, was that the attribute could provide information regarding the machine that built the assembly (because the attribute included path information) and therefore was considered a security risk. If you use the Project properties to set the strong name key, this is all handled for you. Regards David ...Show All

• SQL Server AMO - Dimension Composite Key

  i'm developing an aplication in order to create a cube on the fly, and i'm confuse with something that i read at the Msdn's web site, the doubt that i have is about composite keys in Dimension Tables, after read this paragraph (extracted from - http://msdn2.microsoft.com/en-us/library/ms345091.aspx - "Creating Dropping and Finding Dimensions) . " The primary key attribute of the dimension should be defined as AttributeUsage.Key to make clear that this attribute is the key access to the dimension " It's like the Dimension Tables must have a unique atributte as PK right , but what happens if my Dim Tables have a compositeKey . Is necessary to create a UNIQUE atribute as PK in the Dimension Tables The Key attribu ...Show All

• SQL Server Report Server Cannot Open Connection to Report Server Database

  Hi, I got consistent error of the following: ReportingServicesService!runningjobs!13!1/3/2007-10:45:21:: e ERROR: Error in timer Database Cleanup (NT Service) : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to ...Show All

• Visual Studio Bug: DocData.tt (not asking for VSConstants.VSITEMID_NIL before locking)

  In the final part of the Load method.. if (this.Hierarchy != null && global::System.IO.File.Exists(diagramFileName)) { DslShell::SubordinateFileHelper.EnsureChildProjectItem(this.Hierarchy, this.ItemId, diagramFileName); // Should have a subordinate diagram file now. If we didn't add a lock above, add one now. if (this.diagramDocumentLockHolder == null) { uint itemId = DslShell::SubordinateFileHelper.GetChildProjectItemId(this.Hierarchy, this.ItemId, this.DiagramExtension); if(itemId != global::Microsoft.VisualStudio.VSConstants.VSITEMID_NIL) { this.diagramDocumentLockHolder = DslShell::SubordinateFileHelper.LockSubordinateDocument(this.ServiceProvider, this, diagramFileName, itemId); if (this ...Show All

• Visual Studio Excel Access Violation, Next version release

  I have a simple report holding one matrix, embeded in an apsx page. When I attempt to convert to excel, excel (2003) crashes with "0xc0000005 Access Violation". I have generated the xls document using the toolbar and directly to file with the localreport.render method - both produce the corrupted xls document. I am currently tasked with finding a reporting solution for our company. It's obvious from working with the control and UI, as well as the problems on the forums, ReportViewer is still in very early stages of development. So that I have all the latest information, when is the next release planned and is there a test version or bug fix list for that release In case anyone does read these, th ...Show All

• SQL Server UPDATE Statement with a JOIN Condition

  Hi all, HERE IS MY UPDATE STATEMENT: Update WACTS_Inventory_Part_Loc_Tbl SET WIPLT_Part_New_Qty = WIPLT.WIPLT_Part_New_Qty + tmp.MATIN_QTY FROM WACTS_Inventory_Part_Loc_Tbl WIPLT INNER JOIN Temp_MatIn_Data tmp ON WIPLT.WIPLT_Part_Number_MSBA=tmp.PARTS_ShortID WHERE WIPLT.WIPLT_Location_Code='MF' I have a Problem with this satment becoz my Temp_Matin_Data_Tmp table contains two records with the same PartNumber that is (ShortId) and the two records have two different quantities. The WACTS_Inventory_Part_Loc_Tbl has only one Part NUmber Record and the key is the PartNUmber and Location_Code. Now when the Update Satement runs it updates the qty only from the first record of the temp table and does no ...Show All

• .NET Development Critical Finalizers are not called

  Hi, I have tested the new CriticalFinalizer feature of .NET 2.0 to improve reliability. But so far I am less than impressed that if any normal finalizer screws up by throwing an exception the Finalizer thread dies. This behaviour is quite unfortunate when you try to do something in a reliable manner where you expect to be called even if somebody did screw up. More details can be found here: http://geekswithblogs.net/akraus1/archive/2006/10/30/95435.aspx Is there a way to resurrect the finalizer thread or at least handle the exception inside the finalizer thread and continue with the CriticalFinalizer list Yours, Alois Kraus Hi Alois Critical Finalizers are meant to be run in certain circumstances wh ...Show All

• Visual Studio Team System what is the function for transation and think time in unit test?

  1.we have to add transations and think times in my unit test script... can any one tell me what are the functions for trasations and think time in unit test 2.is it possible to insert rendezvous points in unit test ....... if it is possible how can we insert rendezvous into unit test scripts.pls give me a quick answer.......................................... thanks in advance 1. For thinktime you can use Thread.sleep. Check out this post for transactions: http://blogs.msdn.com/slumley/archive/2006/04/14/load-testing-web-services-with-unit-tests.aspx About half way down the post it talks about timers which are transactions in a unit test. 2. Is this what you mean: http://blogs.msdn.com/billbar/archive/2006/02/09/52883 ...Show All

• SQL Server How can i split the rows in 2 textboxes - Urgent

  Hi, I have a report and its been populating from a sproc. and i have 2 text boxes called both of them are poplulated by Fields!Investment Names, but right i can display the data left to right but i want to display the Data starting top to bottom and then towards the right. I tried grouping the data in this way for one text box = CountRows()/2 > 10 . and this shows all the records one below the other, so is there a way that i can display half the records in one text box and the other half in the other text box. I am going kinda nuts over this. Can someone please help me. Regards Karen Here you go! http://msdn2.microsoft.com/en-us/library/aa179186(SQL.80).aspx cheers, Andrew ...Show All

• Visual C# how can i serialize a object received from a MessageQueue?

  I am sending to a message queue objects of a type "employee" ( a type that i created), sending part executes properly.. i need to know how i can retrieve the objects properly, how can i serialize it back to "employee" type currently i'm using the following code.. it doesnt work.. BinaryFormatter binaryFormatter = new BinaryFormatter (); MessageQueue msgQueue = new MessageQueue (MessageQueueName); System.Messaging. Message msg = msgQueue.Receive(); msg.Formatter = new System.Messaging. XmlMessageFormatter ( new string [] { "System.String" }); Employee emp = ( Employee )msg.Formatter; MessageBox .Show(emp.Name); Hi, Have you i ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game Maker Studio .Net

  Howdy, It is time for me to show you all my little toy. Game Maker Studio .Net (GMS.net) is still in early development and I am doing most of the work myself of my days off. The aim of GMS.net is to build an Editor, Engine and Framework based on XNA, and .Net Framework that specializes in building 2d RPGs and RTSs. So why would you be interested in GMS.net … Well if you don’t like RPGs or RTS then you will not be interested. On the other hand this set of tools will greatly improve your productivity if you are interested in build this type of game. Think of it as GSE on steroids! You still use all the great features of XNA, the Content Pipeline, a Visual Studio friendly environment, support for C#.net or VB.net devel ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Methods to check 2D rectangle collision?

  I enjoyed Win32's IntersectRect() before for this kind of work. Is there a similar method for 2D collision It depends on how accurate you wanna be, what kind of collision you wanna do, and what kind of info you wanna get from it... 1.- use Axis Aligned Bound Boxes as a discard method. 2.- If you want to check just if two rects intersect, use the methods of the api 3.- If you want to get a more detailed information, like the collision normal, penetration, etc, (useful for dynamics algorithms like rigid bodies), you should go to a more complicated algorithm, like the Separating Axes Theorem. ...Show All

• Visual Studio Express Editions Autocomplete Combobox

  I'd like to mimic Access's autocomplete combobox with the NotInList event. User can start typing and if the text exists it will appear... if it does not and user hits enter, an error messagebox "does not exist" is shown. Please can someone help direct me to a solution in C# it shouldnt matter where you are binding it from, unbound or bound. Can you do one quick test and just do the same as above BUT dont bind the control instead, add your own custom entries (test, testy etc...) and see what happens remember there is an exclaimation mark just after the first opening bracket after "if" - it means "not" in case you didnt know ;-) if (!..........) { .. ...Show All