John Sudds - MSFT's Q&A profile

• SQL Server Missing table in Datasource View dropdownlist of ProcessAdd config form of AS Process Task of SSIS

  I made 12 facttables and set them to the 12 partitions. the 12 facttables are the same, and I only build measures on facttable11. My first question is , will this be ok You know, when you build a measure group, it ask you to chose a facttable. I could not chose all the 12 facttables, right I only need to chose ANY one of the 12 tables,right If the answer is YES, could I chose diffrent tables for diffrent measure group and get the same result Nothing mentioned in MSDN. My second quesiton is, when I drop an AS Process TASK in SSIS, and chose to do a ProcessAdd on a partition, on the config form it ask me to chose a table or view that point to the partition i need to Process. On the Datasource View dropdownlist, If I chose the Datasou ...Show All

• SQL Server Regd - License requirement for Replication

  Hello, I am trying to figure out if we want to implement replication in SQL Server 2005 does it require licensing . I have got information on BOL for license information on cluster and log shipping , but didnot get any exact information for license regardign Replication and Database Mirroring. Can anybody please direct me to where I can checkout . Thanks Replication is part of SQL server, so if you have the appropriate SQL server license, that should be sufficient. Since you can only use replication from one SQL server to another server. Gary ...Show All

• Visual C# Generics: Test for a datatype

  Hello, I want to add special handling for a generic class I am writing. See below: class MyGeneric<T> { private T val; public MyGeneric(int src) { // I want to add customized handling such as this below: if (T is string) val = src.ToString() } } Is this possible with generics The code belos is not exactly what I want to do, but hopefully it gets the point across... I want to have customized handling for cartain types for T. GMagana, as you found out you cannot put a constraint on your generic type that is a sealed class. I was annoyed by the limitation at first, but it makes perfect sense... since you cannot derive a sealed class, there is only one type that will satisfy the constrain ...Show All

• Visual Studio Team System Solution: "cannot locate license assembly" during Team Build process when using third-party components

  Hi there, when using Team Build with a project that uses third-party components such as Infragistics that use the license.lix licensing mechanism I get the error "cannot locate license assembly" during the compilation phase of the build process. I do not consider installing the Infragistics controls on my build servers since they are supposed to be clean. What am I doing wrong here What would be the recommended way to accomplish this Why is a license neccessary to compile Thanks, Neno Steps to Reproduce: -> Open Team Explorer -> Create a BuildType for a Team Project that references Infragistics -> assemblies Start Build => Receive build error "cannot locate license assembly" I ...Show All

• Visual Basic How will i share my mdf file

  How will i share my .mdf file so my program installed in other computer in the network could access it I tried to share the folder where my mdf file is located but my program in the other pc in the network cant access it. ...Show All

• Visual Basic about copying info from a ".txt" file to a listbox

  This myt seem lyk a very stupid question for most of you people out there, so i apologise for my ignorance. I am learning computing at school this year, and i had to do a project at school. Anyways, i am really really stuck on this, i have been trying 2 do it for the past 3 hours and it seems like i really need some help. I have got this txt file with the info like this: "DEF $13.45" "ABC $12.95" "Cheese Lovers $11.90" "Vegie Supreme $11.90" "$50.20" I was wanting to copy the whole file into a listbox. So this is what i tried, but it never seemed to work. This is what i have thought of, i have tried alot of other methods but they dont work too. Fi ...Show All

• SQL Server Drill Down in a Matrix report

  is it possible to have drill down feature in matrix report A B C x 1 0 1 y 2 2 2 z 4 0 7 What would be nice is if the user clicked on "7" and a report opened showing the detail for that value. eHaze, Yes, in your Matrix design, right click on the Column, select properties, set the navigation tab and in the HyperLink Action select how you want to drill down to your report. Ham ...Show All

• .NET Development binding a dropdownlist

  <% @ Import Namespace = "system.data" %> <% @ Import Namespace = "system.data.oledb" %> < script runat ="server" > Sub button_click( ByVal s As Object , ByVal e As EventArgs) Dim conAccess As OleDbConnection Dim cmdInsert As OleDbCommand Dim cmdSelect As OleDbCommand Dim dtrteam As OleDbDataReader Dim strInsert As String conAccess = New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=C:\Documents and Settings\axb59274\Desktop\PfE New Tables.mdb" ) conAccess.Open() strInsert = "insert into lis_per ([last], [first], [teamid], [email]) values ( , , , )" cmdSe ...Show All

• Visual Studio Team System Future of TFS with Performance Point 200x

  Hello - I work at a mid-sized development company and we have been using TFS in development for a little over a year now (yes, we started with Beta2). Everything related to work items, running builds, getting build reports, etc. is working great. But we are finding that without any clear direction in the way of project management tools integration we are having a hard time answering managment's questions/concerns regarding the use and future of TFS. We've recently hired a Project Manager Manager (yes, a manager of project managers) whose first responsibility is to standardize development methodologies across all products/groups by implementing MSFs,TFS, Project, PeopleSoft, etc. Looking together at how we are using TFS in ...Show All

• Visual Studio Team System Database Projects (Create Scripts) and Team Foundation Problem

  Maybe I'm doing something wrong, but I'm getting a few problems using database projects with TFS, and things aren't being checked in properly. My database project has a number of sub-folders in "Create Scripts", one of which is for tables. If I edit my database, and use "Generate Create Script", a script is automatically generated in the root of the "Create Scripts" folder, so I manually drag it to the "Tables" sub-folder. I get a couple of warnings: A file already exists with the same name The item was not renamed in the source control database because there is already an item with the same name in the destination folder. This leaves me with two main problems: 1) Even though I have moved the file, ...Show All

• SQL Server Tool to Switch between 2000 and 2005

  Hi All, Is there a tool where I can switch off all of the SQL 2000 services and turn on the SQL 2005 services, and vice-versa. I'm running all this on my portable and it is taking quite some memory, causing my system to swap more, and if there is one component that is slow, it is the harddisk. Thanks. YOu could write a batch using the net stop / net start commands. Use the appropiate service names to start and stop the service, e.g. net stop MSSQLSERVER net start "SQL SERVER (MSSQLSERVER)" HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Error viewing report created in Report Builder

  Using the report builder, I created a simple report based on a report model. This report runs ok in the report builder. I proceeded to save the report to the report server, but when I want to view this report in Report Manager, I get the following error: An error has occurred during report processing. Query execution failed for data set 'dataSet'. Incorrect syntax near '<'. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The la ...Show All

• Visual Basic releasing resources

  having created a user control (which contains a few buttons and text boxes ) and added several of them to a panel...how do i release their resources/memory when i want to clear the screen and start over do i need to create a dipose or finailize method in the user control class do i just need to iterate throught all the controls and call their dipose methods or something else how do i release all the variables associated with the class Thanks, Dan I suspect something else is going on - for one thing, you mention opening files. Yes, a lot of controls will use a lot of memory, but is unlikely to cause an out of memory exception (the garbage collector is quite smart). Try populating w ...Show All

• SQL Server VS pro install, SQL error

  Hi I signed up for the Empower program and have finally installed VS 2005 pro. I am first testing it out on a spare laptop, it has a fresh copy of xp sp2 and during install, I selected everything, however it says failed to install SQL express. I have tried several times to redo this through add/remove components however I get the same problem. In start > all programs, I have Microsoft SQL server group, so I really do not know what has happened. Also, from looking at the VS website, I was under the impression that sql server developers edition came with VS pro, and not the free express edition, so I am a little confused, unless this means that you just use the cd that came with the MSDN sub Also, I was under the impressio ...Show All

• Visual Studio Team System How to allow negative input

  Is there a way to allow negative value input, i have created my custome field and tried with integer, double, string and plain text. non of them allow me key in "-". Sorry for not giving enough info. im using TFS and i have customized the Agile template. i add a field in task and want its value can be negative value. but seems can't get it work. ...Show All