brianpmccullough's Q&A profile

• Visual Studio Team System FEATURE REQUEST: 'Select All' and 'Deselect All' on New Data Comparison

  DataDude Team: Can the ability to 'Select All' and 'Deselect All' tables on the New Data Comparison window be added Warmest regards, Doug Ramirez In order to ship Team Edition for Database Professionals before the end of the year, I believe we're down to taking performance fixes and ship-stopping bugs at this point. We'll put feature requests, like this one, on the list for consideration for our next release. thanks for the feedback. I believe we've had other requests for the same feature. ...Show All

• SQL Server Network timeout to Mirror causes Primary to deny connections

  We've had two instances now where when there is a network connection timeout to the mirror from the primary, the primary db server goes to 100% utilization and refuses all connections. The first time we had to reboot the primary, the 2nd time mirroring picked up again 10 minutes later. There are two dbs being mirrored, one is 15gig, the other 4gig. Both boxes are running SQL2005 64 bit and Win 2003 64bit. This happened at 6am and typically there shouldn't be a lot of traffic at that time but here are the error messages in the SQL log below. We are going to try and move db communications to a separate network and network card - but this looks like either a bug in mirroring or a configuration problem on our end - though it works ...Show All

• SQL Server Can't uninstall or reinstall nonfunctioning sql server

  In previous post in the Getting Started section, I discussed problems trying to run queries on multiple databases: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=299240#299240&SiteID=1 Nobody could help with the problem. I eventually got a query to run after several attempts at deleting and recreating databases. Then, I was hit with the following error message: Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration) Nobody could help with that either but based on posts with the same message, I tried uninstalling sql server. It wouldn't uninstall nor can I repair or reinstall. Uninstalling thru Add or Remove ...Show All

• SQL Server money format

  Hi. I have a money field and its value is greater than a thousand.For example its value = 32.885,60 I want to show the field's format like this (this number's format). I mean the thousand separator should be .(dot) and the decimal separator should be ,(comma) And I want two digit after the decimal separator.All these conditions matches with this number(32.885,60) Could you help me Hi Muhsin, sorry this isn't an answer for you, but very curious as to the currency you are working in I am used to formatting it the other way around (32,885.60) 99 ...Show All

• SQL Server Error Deployiong Analysis Services Cube

  Hi: I am getting the following error when deploying the cube on my laptop. "The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server." I confirmed that all the services are running. Can you someone guide me here This is the first time I am trying to deploy the cube in analysis services 2005. Please let me know. Thanks Try using machine name instead of the "localhost". Try conne ...Show All

• .NET Development Help with TripleDES and RC2 cryptography.

  I have 2 questions - 1) I get the following Exception when I try to decrypt data using TripleDES. - "An unhandled exception of type 'System.Security.Cryptography.CryptographicException' occurred in mscorlib.dll Additional information: Specified initialization vector (IV) does not match the block size for this algorithm." How do I make things right The code is as follows - /* Provides TripleDES encryption and decryption using classes in the .net Framework 1.1 */ public class TripleDES_Cryptography { public static string Encrypt(string plaintext, string key, string IV) { TripleDES des3 = new TripleDESCryptoServiceProvider(); des3.Mode = CipherMode.CBC; byte[] by_plaintext = Encoding.ASCII.Ge ...Show All

• Visual Studio Tools for Office Problem with running word 2003 customization in Office 2007

  Hi :) I have next solution: Customized word documents, which are on ASP.NET server. When user download one of these documents, customization should run. Assembly evidence for this document belongs to the code group : URL. It works fine with Windows XP and Office 2003. When i try to run it under Vista with Office 2007, it doesn't work. I get message like ' assembly * can not run ........ ' Like word 2007 doesn't recognize name, or manifest and ddl path. Only * is visible. Customization contains action pane and cached data. Thanx :) VSTO 2005 Office 2003 solutions require the VSTO 2005 SE runtime in order to run on Office 2007. Can you confirm that you have the SE runtime installed on the ...Show All

• Windows Forms Print Preview problem(Bug)

  Hey, I have this code in the PrintDocument control under the PrintPage event: private void printDocument_PrintPage( object sender, PrintPageEventArgs e) { RtextboxUC thisrichtextbox = GetCurrentTextBox(); //Start printing text and store last letter... checkPrint = thisrichtextbox.Print(checkPrint, thisrichtextbox.TextBox.TextLength, e); //Check if there should be more pages if (checkPrint < thisrichtextbox.TextBox.TextLength) { e.HasMorePages = true ; } else { e.HasMorePages = false ; } } There are no errors, but when I test it on my program and click print preview...when it opens the PrintPreview dialog It shows the dialog that is telling you how many pages it is det ...Show All

• Visual Studio Express Editions Table only updates once during runtime...

  I have a dataset that i am updating during runtime of my program.  To do this, I first delete all of the data in a datatable using "DELETE * FROM Table1" command, and then updating the dataset.  To initiate the update, i double click on a datagrid.  The first time i double-click on the data grid, the program works exactly as planned--i step through the code and verify that first all the records in the datatable delete, and then is updated with all the new records.  The problem i'm having is that the next time i double-click on the datagrid, the table doesn't delete!   Why would this happen   Here's my code: Sub UpdateTeamTable() Dim dt As New DataTable Dim strSQL As String Dim int1 ...Show All

• SQL Server Invoice Detail

  Hi I have a invoice that displays the company name in a rectangle on top then it has a list in the list it has details tables my problem is that the invoice detail goes on the next page I need to have the company name as well on the second page I cant put it in the same table as the detail because I have a few tables in the detail so it is actually no header is it possible to have Repeated the Company name information on the next page Thanks << You may be able to add a conditional text box that displays whenever RowNumber > a certain amount, which would be equal to the amount of records that could fit on a page.>> Hi Thanks Andrew can you please explain a litt ...Show All

• Visual Basic Open a form and show a particular record

  Hi, I have a stored procedure that returns a record dependant on a value sent to it. I have created a form that shows the detail view of the Dataset from this stored procedure. How / where do I send the form the parameter (from another other form) so that the form opens on the right record Ta. John Thanks for your answer. I tried adding a new sub and got a " Public Sub New ( ByVal recordcriteria As String ) in designer gernerated type "Trial.frmName" should call initialize method." error Also, I cant see the fill method having such a form. Get a too many arguements error... I'm OK with passing the criteria, it's just geting the criteria into the adaptor/recor ...Show All

• Visual Studio 2008 (Pre-release) Creating a control which can have a collection of children in XAML

  I will try to explain this as simply as possible. I am using .net framework 3.0 june ctp, and trying to write a wpf program. I have created a class which inherits a grid, and I have then extended it. It creates a windowsforms reportviewer control, puts it in a windowsformshost control and then puts it inside the inherited grid. Along with a few custom propeties I've defined theres not much else to it, and the XAML to put it in an application is as follows: <l:ReportSlide Duration="10" ReportPath="/Report Project1/Weekly GWP" ReportServerUrl = " http: / / server2: 102/ reportserver " /> This is where I'm having difficulty now. Many of the controls that are standard with avalon allow you t ...Show All

• Visual Basic Can't open myscape.vb in Design Editor

  Alright, let me describe the problem I'm having: I was working on a program - a world switcher (yes, legal) for the game RuneScape, for my help site - and got quite far in. I had saved a few times along the road... And then Visual Basic crashed. No, the files were not corrupted, they had been saved several minutes before this. Anyway, I boot up Visual Basic (Express Edition) and click File -> Open File -> myscape.vb ^^ Can't get the design editor to come up. I see all the code that appears when you double-click an icon in the Design Editor... And yet... It doesn't load properly. In the same folder, I also have: myscape.Designer.vb (No changes made by me) myscape (.NET resource file [no changes made by me]) ...Show All

• Internet Explorer Development Delete an element using Javascript?

  How do I remove this element using Javascript document.getElementById(WindowID+ "_TaskbarButton" ) Hmm... I've figured it out... var el2 = document.getElementById(WindowID+ "_TaskbarButton" ); el2.parentNode.removeChild(el2); ...Show All

• Visual Studio Tools for Office VSTO and AVG...HEEELP!

  Hi, today I've installed the AVG antivirus...I knew that it used to install a plugin for Outlook, but I choosed to not install it... However...my plugin stopped to work! And I've no idea why!! I tried to disable the Personal Email Scanner, reinstall the plugin, anything, ANYTHING...nothing works anymore :((((((( None of my Outlook plugins works...has anyone experienced something like that ! ! Has anyone solved it! ! ! Please, I cannot work anymore without my plugin...even starting it through VS doesn't work! I've already written top the AVG forum, but I'm hoping to find here anyone with my same experience...and maybe someone who has solved this problem :(((((((((( Thank you LastHope Solved, but the solution is in this thread...I hope ...Show All