Scottaroberts99's Q&A profile

• SQL Server SQL Exception like clockwork

  Setup: Windows Server 2003 (Standard Edition) WITH Service Pack 1 SQL Server 2000 WITH Service Pack 4 SQL Reporting Services WITH Service Pack 2 SQL Server 2005 Upgrade Advisor - Migrate Legacy Maintenance Plans Installed SQL Server 2005 + SQL Server 2005 Reporting Services Pretty impressed at how smooth the transition was during the upgrade. SQL 2000 went down for less than a minute and up came SQL 2005. The upgrade was a success (nothing broken). BUT. Problem 1.  "Cannot find folder "\Maintenance Plans"."                Solved by using a system sp to add t ...Show All

• SQL Server JuneCTP Install Issue: WMI 0x80040154

  I'm following these instructions from a previous issue on another install from Dan If you want the latest SQL Server CTP, the June CTP and VS Beta 2 you will need to do the following: 1) Install VS Beta 2 (do not install SQL Express) <=== Seems to work fine and I can access my w2kSQL server on another machine from code. 2) Uninstall .Net Framework 3) Install SQL Server June CTP When I try and do a install of the June CTP, I get a message halting the install and says the WMI is not configured properly. I found other links regarding the WMI and tried the following. Mofcomp.exe %windir%\system32\wbem\cimwin32.mof But I get an 0x80040154 ...Show All

• Visual Studio 2008 (Pre-release) Exception thrown when using .Assign(value)

  I have a class called Stay with the following EntitySet property: [Association(Name = "FK_tblServiceReceived_tblStay", Storage = "_ServiceReceiveds", OtherKey = "ColStayId")] public EntitySet<ServiceReceived> ServiceReceiveds { get { return this._ServiceReceiveds; } set { this._ServiceReceiveds.Assign(value); } } The same class has the following statement in the constructor: this.ServiceReceiveds = new EntitySet<ServiceReceived>( delegate(ServiceReceived entity) { entity.StayEntity = this; }, delegate(ServiceReceived entity) { entity.StayEntity = null ...Show All

• .NET Development return inside using?

  Hi, I would just like to ask, if string GetText( int id) { using ( SqlConnection con ...) { SqlCommand cmd = new SqlCommand ("SELECT text FROM texts WHERE id=" + id, con); return cmd.ExecuteScalar(); } } closes the connection Or should I completely avoid calling return inside the using block ...Show All

• Visual Studio Team System BUG - Save query before Running it

  Steps to reproduce bug: 1.) Right click "My Queries" in Team Explorer and Click "Add Query" 2.) On the second line of the query tool, click dropdown for "field" and set to Work Item type. 3.) On the second line of the query tool, select dropdown for "value" and set to "Task". 4.) Click save button. (Don't Run query.) 5.) Take the defaults and click the save button on the "Save Query As" window. 6.) Right click on new query and select View Query. 7.) Notice that "value" field on second row is not populated. Thanks Jason. I will make sure it does not repro in a couple more latest builds. If it does, I will open a bug to track the issue. ...Show All

• Visual Studio Team System User account deleted and recreated: SID problem?

  I'm using workgroup edition on a single server in our domain. One of our users recently had his Active Directory account deleted and then recreated with the same username. His username no longer appears in the Team Foundation Licensed Users server group, and if I try and add it again, i get this error: Microsoft.TeamFoundation.Server.AddGroupMemberOverLicenseLimit: TF50626: Maximum users (5) in License group. Unable to add Joe Bloggs. I guess I need to do something with his SID - but what d'oh! forgot something. i also ran: delete from tbl_gss_group_membership where member_sid=<sid of old user account> ...Show All

• Visual Basic Subclassing controls

  I have subclassed a text box like this Public Class RMText Inherits TextBox Public Sub New () MyBase .New() Font = New System.Drawing.Font( "Verdana" , 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType (0, Byte )) Text = "" Width = 200 BackColor = System.Drawing.Color.White ForeColor = System.Drawing.Color.Navy End Sub Public Sub EnterHandler( ByVal Sender As Object , ByVal e As EventArgs) Handles MyBase .Enter BackColor = System.Drawing.Color.Cornsilk ForeColor = System.Drawing.Color.Navy SelectAll() End Sub Public Sub LeaveHandler( ByVal Sender As ...Show All

• Windows Forms Getting the dataGridName.CurrentRowIndex in click events

  I noticed that the currentRowIndex is not updated until after the click events - what other event would you use   I don't see any documented, like CurrentRowIndexChanged, etc. oops sorry - its CurrentCellChanged event, that works :)  ...Show All

• Visual Basic Simple FTP

  How would you do a simple FTP with a login, password, and to and from filepaths in textboxes. I use this code: Bold -> Constant Variables Public Function exportFiles(ByVal path As String, ByVal username As String, ByVal password As String) As String     Dim fso As New FileSystemObject     Dim shortPath As String     Dim iError As Integer     Dim wkStr As String         shortPath = ShortPathName(path)          fso.CreateTextFile path & "\" & fileFtp     ...Show All

• Visual Studio 2008 (Pre-release) FlowText in Feb CTP

  FlowText seems to be missing from the Feb CTP. What was the rationalle from dropping it, if any Can we expect to see it return ...Show All

• Visual Studio Reference to DTE

  I have a component which sits in the component tray. When the user clicks the control I want to add a file to the project. How do I get a reference to the DTE object I want to essentialy have a control (in the component tray) which adds code into a solution. I can only see how to get a reference to the DTE at runtime or via an addin - can you get a reference so at design time (I know the control will be running) - I can add a file to the current solution (which is still in design time) I hope this makes sense Cheers Si Hi Si, I believe you can only get this access to the IDE at d ...Show All

• SQL Server SQL Authentication and SQL Express

  (FYI - the Search box throws a scripting error when I type in it) I see in SQL Express Manager that I can connect using either Windows Authentication or SQL Authentication. Is the SQL Authentication for use with SQL Server 2000 and perhaps the full SQL Server 2005, but not for SQL Express My product uses SQL Authentication with SQL Server 2000; I am testing my product with SQL Express, but it fails on the authentication step: Event Type: Failure Audit Event Source: MSSQL$SQLEXPRESS Event Category: Logon Event ID: 18452 Date:  5/24/2005 Time:  3:13:26 PM User:  N/A Computer: XSDEV02 Desc ...Show All

• Visual Studio Team System SolutionRoot and other Team Build properties

  Is there a reference that defines Team Build properties exposed in msbuild I don't see that any of the online or shipped docs call these out, and I see questions on MSBuild list around these too. Pointers appreciated. You can set the verbosity level using the TFSBuild.resp file. You can check this file out of source control and write /verbosity:diag in the file and check it in. This will enable diagnostic logging on your team builds. ...Show All

• .NET Development [C#] having a long menu not taking all the screen height

  Hi, I display a lot of images in a context menu, using OwnerDraw=true and overring OnMeasureItem/OnDrawItem. The automatically displayed arrows are great, but the menu takes all the screen height! My boss want the menu to be shorter... I tried to display only a few images, and added my own arrow items at the beginning and the end of them, but I can't make the menu scroll when I click/select the arrows! - when clicking the arrows, the menu automatically closes - when selecting them, I dynamically modify the images items, but I can't make the menu update ! I tried everything: Refresh/Update/Invalidate of the parent control, PerformSelect on ...Show All

• Visual C# dataset c# VS2005

  First post please be kind, i have the following problem. How do i make and use a dataset in vs2005 all the examples are in vs2003 and in visual basic. this is what i want to make: a hour registration webform, after 1 populated a row a new row will be edited. The standaard datagrid only have a insert button. --------------------- add   (hours, comment etc then add row button) --------------------- add --------------------- add OK (now the complete dataset will be send to a stored procedure.) I must use a disconnected model because i want to manipulated the data before it's send to the database. ...Show All