ares_l's Q&A profile
SQL Server Copying my SQL Database to another server
Hi guys, I have created a new SQL database (named “DB”) on my personal pc at home. I want to copy “DB” to my job’s computer, which works on a local net with SQL server. What should I do Thanks a lot, Aldo. 1. Open your SQL Server Enterprise Manager 2. Expand and Point to your database. 3. Right Click on your database (Db), and navigate to "All Task " -- "Backup Database" -- "Add" -- "File Name" 4. Give a proper file name and note the location where the backup file is being created. 5. Copy This file to your Job Computer 6. For Restoring on your Job computer check the following steps 7. Open Enterprise Manager on your job computer. 8. Point to Database Node ...Show All
Visual Basic Making a window appear at the mouse
But I want the bottom-right hand corner to appear at the mouse popint. How would I do this Private Sub Form1_MouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Me.MouseClick Dim F As New Form2 F.StartPosition = FormStartPosition.Manual F.Left = Cursor.Position.X - F.Width F.Top = Cursor.Position.Y - F.Height F.Show() End Sub ...Show All
SQL Server control flow of execution of statement
is there a way to check to see if the previous sql statement has completely executed before executing the next statement I have a stored procedure that basically has several insert statements. At the end of the insert statements I call bcp to write the table to a text file. The first insert will write a header record into the table. Then it will insert a bunch of records that are selected from other tables and then lastly will write the footer record. My dilemna is that for some reason the first insert of the header record isn't actually happening until the middle of the second set of inserts where it inserts several records from another table. so basically my file ends up looking like this payment record payment record payment r ...Show All
Visual Basic Load COM add-in in Visual Studio 2005
Hi there, my problem is, that I need to add a COM add-in to Visual Studio 2005. I've found the suggestion, to look under Tools\COM add-ins, but there is no "COM add-ins". I've got WS 2005 Professional, where do I find that Could anyone please help me Thanks so far Christian Well, I thought so. But there are no Add-ins available. Maybe I'm doing wrong. I wanted to use a MapPoint 2004 COM add-in in my program. Though, I never used COM before, I thought of using it as component (like drag & drop), but the using seems to be different... Well then, thanks for your reply. I hope I'll find a hint in the web to solve this Thank you very much Christian ...Show All
Game Technologies: DirectX, XNA, XACT, etc. PNG Alpha Channel
I've imported a semi-transparent PNG to use for a sprite but the alpha channel isn't taken into account. It just renders as a fully opaque texture. How can I enable alpha channel support I used Photoshop CS to make my transparent PNG files and had no issues. In Photoshop did you save your PNG file with a white background still showing I got my image ready, deleted the white background so that the Grey and greyer squares (denoting transparency in Photoshop) were showing, and then saved as a PNG file. After that I simply set my mode to Alpha (as mentioned earlier in this chain) and drew it to the screen with no issues. Hope that helps. ...Show All
Visual C# Calling Event Issues??? Help!
When my form closes I want to fire an event that will do somethings....but i think i may be calling it wrong...Here is my method signiture...and this is the error.... [code languge="C#"] public delegate void frmClosing ( object sender, FormClosingEventArgs e); public frmClosing ClosingVendorDetails; public static void DisplayVendorDetails(System.Windows.Forms. Form ParentForm, BHFreight.Tracking.BusinessObjects. VendorOrderLegDetail _VendorLeg, frmClosing ClosingForm) { BHFreight.Tracking.UI.MainWindows. VendorOrderLegDetailsForm frmVendorLeg = new VendorOrderLegDetailsForm (); frmVendorLeg._VendorDetail = _VendorLeg; frmVendorLeg.LoadVendorObjectToForm(); frmVendorLeg.ShowDi ...Show All
SQL Server Documentation of RMO and Merge Replication
Hi there, In a lot of the Replication documentation it only refers to the merge agent operating in the context of a push or a pull configuration. i.e. if it is push then the merge agent is at the distributor but if it is a pull then the merge agent functions at the subscriber. I recently joined a project which is configured as a push but it uses RMO for synchronisation. This RMO application is installed on a compeletely separate server. Initially I thought the RMO was just passing requests through to the publisher/distributor/subscriber but the distributor didn't seem to be doing any of the work. It therefore seems that the merging/synchronisation is being performed on this RMO application server and not the distributor or subscriber ...Show All
Visual Studio Team System Problem with source control, web projects and the bin directory
Hi I have a problem with web projects and source control. It appears that the bin directory is automatically added to source control. This is causes a problem whenever anyone compiles the solution as the same binaries are attempted to check in and of course someone has already checked out and locked the binary. I assume if a change is made to a binary it is automatically locked. Unfortunately even though I have deleted the bin directory from source control whenever the solution is compiled it tries to add the binary to source control again. Does anyone have any suggestions on how I can get around this. Cheers Brett Hello, I have a similar problem. We have a Web App with a lot of references, and every time we do Check I ...Show All
Visual Studio Team System Branching strategy for multiple projects
I have been working on a new folder structure and branching strategy, and I have done quite a bit of research over the last few days. As a result of my research and my own experiences, I am a big advocate of the trunk/branches/tags methodology: $/Project $/Project/trunk $/Project/branches $/Project/tags All of the new development is performed on the trunk. When we get close to a release, a branch is created for the release (ex: 1.0_Branch). Stabalization is performed on the 1.0_Branch and eventually the final release is built from this branch. At that point, a "tag" is created. A tag is just like a branch except that it has no future. In other words, it's just a branch that nobody has permission to edit. All maintenance is ...Show All
Software Development for Windows Vista How to use the Vista Hands OnLad
Dear all. I do download and install the HandsOnLab. http://download.microsoft.com/download/9/e/2/9e2bb139-b8b4-40ba-99e8-2582d8c18640/WindowsVista_HandsOnLab.EXE the problems is : The Word doc references the sln file --- but where is it there are two msi files: VistaAppCompatDemo.Bad.x86.msi and VistaAppCompatDemo.x86.msi. The "bad" msi installs the LuaDemo.exe, but no source code. The other msi installs a service called LuaDemo. how to use this hands on labs need a readme please !!! Hello Polo Lee, Thanks for your patience while I looked into this, seems like they did not include the source from the download location you specified. However there is a second copy over here: http://devreadiness.org/ ...Show All
Visual Studio 2008 (Pre-release) Active Window
Hi, could anybody tell me how to get the active window of a WPF application Thanks, Chris ...Show All
Windows Forms Delete a row programmatically in DataGridView
How can I delete a newly added row with code in a DataGridview I cannot find any delete method in any of the features of the DataGridView. I test for correct data in the _RowValidating event that sets cancel to true. But when the user leaves the row without correcting the value, I set e.cancel = True. But the row is still there with the invalid value in one of the cells. I want to delete the row if the data are not correct and the user navigates away from the row. Can this be done Is RowValidating event the correct place to do the delete How and where should I do it The DataGridView is bound to a binding source which is in turn bound to a datatable. There is no delete method in the binding source and the record does not ex ...Show All
SQL Server reading pdf files with SSIS 2005
hello to everyone, i would like to ask u if you know how can i import pdf files in sql server integration services 2005 does anyone have a script thank u Do you just want to import the PDF file into a BLOB, Image or Varbinary(Max) column in SQL If so, you can use the Import column transform to read a directory and suck them into SQL or another RDBMS. To push them out of the DB, use the Export column transform. ...Show All
Visual C++ Warning if variablename in function differs from implementation
Hi I have searched in the compiler warning list, msdn and a lot of other forums, but i couldn't find any warning for this. Is there such warning, or can i get it in another way It would be nice if the compiler raises a warning for this, just to keep my code clean. example: headerfile: class myClass { int myFunction(int a, int b); } cpp file: int myClass::myFunction(int c, int d) { return c+d; } Some would argue that named variables in function declarations break encapsulation, others would say that it helps build an understanding of the interface (and thus has nothing to do with the encapsulation). I'm with the latter ...Show All
Visual Basic How to check if an Array contains a string.
I want to search through an array and find out if a certain string is contained within. But, Array does not have a Contains member so I do not know what else to use. Thank you, Troy L one way would be to get the string representation of the current item you are iterating through the array. Example: for each currentItem as object in MyArray if currentItem.ToString().Contains(" blah ") then 'do stuff end if next you maybe better of storing your string collection in a generic list of string, since this collection will only ever contain string elements, so there is no need for the .ToString() as above as you know all items will be of type string does this help ...Show All
