james_m's Q&A profile

• SQL Server What does and does not get backed up or log shipped in 2005.

  This is a compilation of questions from other people: 1. Will managed code objects get backed up with the database or must the dlls be copied manually (Answer: They get backed up with the database. No manual backup of the dll files is necessary.) 2. If you have two servers and are using log shipping, how will managed code objects be handled Will they be available after the log is processed on the other server 3. Full-text indexing relies o ...Show All

• Visual Studio 2008 (Pre-release) Problem in merging XPS documents

  When i tryed to merge the pages of XPS Documents into one XPS file  I encountered a Exception when i call the AddChild method: System.InvalidOperationException: The specified element is already the logical child fo another element. Disconnect it first. How can i disconnect one child from its parent     FixedDocumentSequence MergeXpsDocuments(FixedDocumentSequence[] xpsDocs)    {  &nb ...Show All

• SQL Server SQL Server 2005 Express and SQL Server 2005 Developer

  I am new to sql in the new .net framework and recently purchased VS2005 Pro which has the Sql Developer 2005. Can I use both these together on the same box, and still create and deploy express database applications while benefiting from learning the sql developer 2005 edition ...Show All

• SQL Server Problem with a date function

  Hello All! I have a table with a date column. I would like to be able to DELETE the rows based on the date column. The condition is 30 days from todays date. So anything older than 30 days from todays date, it will delete those rows. Any suggesttion the best way to do this. I was thinking of a simple select statement, but can't figure it out. TIA!! Rudy Hi there, Is your date column of data ...Show All

• Windows Forms Framework Version

  Is there a way to get the version of the latest installed framework as a string value  For instance, if I have v1.0.3705 and v1.1.4322 installed, the v1.1.4322 would be returned. Ah, okay.. Not sure how to do that... There are  ...Show All

• SQL Server Output query to xml file

  I have an sp that runs a query in xp_cmdshell/BCP combo that puts the output into an XML file (using for xml auto hint on the end of the query). I personally feel that I should now (under SQL 2K5) be able to do this within a query, not going any where near xp_cmdshell or bcp, and then use SSIS in the final step to ftp it up to the clients site. It builds a command string in the sp, then runs that command string via xp_cmdshell. I guess what ...Show All

• Visual C++ CSplitterWnd fixed split bar?

  In MFC, is it possible to create two split windows with CSplitterWnd and make the split bar fixed (doesn't allow the user to adjust the size of the split window)   Also: http://www.codeproject.com/splitter/usefulsplitter.asp ...Show All

• Visual Studio References info from ProjectNode?

  Hi. I'm building a custom compiler and integrating with VS2005 using the Managed Package Framework classes. I'm trying to get Intellisense to work, but I need the references from my custom project for type resolution. The ParseRequest object passed to my override of LanguageService.ParseSource() doesn't have any project info, though with some help from the newsgroups, from DTE I was able to retrieve my project instance, which is derived from Pr ...Show All

• SQL Server Error in sql server 2005 developer edition.

  Previously I have posted for the step of installation http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=312644&SiteID=1 I have just installed sql server 2005 developer edition. After installation is completed when I open sql server management studio I am gwetting Following error.What can I do. The error is See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ****** ...Show All

• Visual C# Navigate DataSet

  Hi all, I had a datagridview which is bind to a dataset. I want to do some condition checking where by if certain field is empty, I will highlight the row of datagridview to some other colour. By doing this, am I right to say that I need to navigate through the dataset to check if the field is empty. If yes, may I know how to navigate the dataset Please help. Thanks Is this ASP.NET application o ...Show All

• Visual Studio Team System error 32000

  Team Foundation Server Dual-Server Deployment ,while install Application Tier get the error: Error 32000.Failed to get CustomActionData. here is log file info: vs70uimgr: DisplayMessage_START:Error 32000.The Commandline '"Z:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\widbloc.exe" -s datasvr -d CurrituckDB' returned non-zero value: 1. [06/16/05,23:57:14] vs70uimgr: DisplayMessage_END:Error 32000.The Commandline '"Z:\Progr ...Show All

• Visual C++ Problems with error LNK2019: unresolved external symbol

  Hello, I am currently learning C++, so I created a simple test application to see how I could created header files that used each other and would not cause errors by doing so. The code is broken up into 6 files, I am listing them below: //////////////////////////////////////////////////////////////////////////////// // First file is the main file. QuickTest.cpp ////////////////////////////////////////////////////////////////////////////// ...Show All

• Windows Forms Unable to paste CSV format into Excel

  Hi, I am trying to put data onto the clipboard which can be pasted into Excel.  I have successfully implemented HTML, Text and XML Spreadsheet but cannot get the CSV format to work.  Even the example provided by MSDN won't work: string comma = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ListSeparator; String csv = "1" + comma + "2" + comma + "3" + Environment.NewLine + "6" + comma + "8" + comma + "3"; byte [] ...Show All

• Visual Basic Using Visual Basic 6 with CLR Profiling API

  I am using the profiling api with Rotor. However, I've found that using C++ to implment COM interfaces is very, very painful. Has anybody created profilers using Visual Basic 6.0 dll's having objects that implement ICorProfilerCallback If not, should this work in theory (writing a profiler in VB6 instead of C++) Does anybody have any idea where I can find a typelib for the Profiling API that would include a definition of ICorProfilerCallbac ...Show All

• SQL Server SQL user connections

  I am in the process of installing 7 remote desktop computers that are furnishing data to a SQL server. We will also have 40-50 Managers/Supervisors who will have access to the database for information retrieval. Are there any tools available that would allow me to monitor who is connected to the Server My main interest in monitoring are the 7 desktops which are permanently connected to the database. Until we have some history, I would like to ma ...Show All