SerratedSoftware's Q&A profile

• SQL Server What version of SQL can I install for XP where I can use the enterprise manager???

  Hello Everybody,   I would like to know which version of sql server I could install locally in my personal laptop where i can create new databases and use the enterprise manager   Thanks for suggestions,   Ed. You can install both SQL2K and SQL2K5 on XP.  Enterprise Manager will only work against SQL 2000.  If you want to manage both SQL 2000 and 2005 use the SQL Serv ...Show All

• SQL Server How can i insert a default row if it doenst exists already?

  Hi, I am currently loading dimensions using a Sql Server Destination and i was wondering if i can create a middle step to insert a certain row so i would identify in my dimension the undefined records... I know i can do it with sql statement but i was wondering if there is a better way. Best Regards, Luis Simoes Would this not be part of the fact load, you wish to infer the dim member from the fact data when there is not already a ...Show All

• Visual Studio 2008 (Pre-release) DLINQ vs DataTable,TableAdapter, etc

  Hello,     I may not understand DLINQ fully, but what are the advantages of it vs. just using a datatable, dataset etc   Thank you!   Edited -Changed LINQ to DLINQ I've not played around with it myself but from my understanding the syntax and ability to manipulate is greatly improved and more intuitive (especially to those with prior sql background). ...Show All

• Windows Forms Transparent Usercontrols

  Currently transparent background color is not supported in usercontrols with overlapping controls as it was supported within VB6 with the backstyle proeprty. In the transfer of our software from VB6 to VB.Net this lack of functionality is killing our applicat ...Show All

• Software Development for Windows Vista HELP!! Tracking Service is not working

  I'm playing with the WF tracking service but couldn't get it to work even for the simplest use case. I created the Sql tracking database and tried to run the "SimpleTrackingSample" solution is the SDK. The workflow runs ok but never terminates. If I commented out: workflowRuntime.AddService( new SqlTrackingService (connectionString)); The workflow worked fine then. We're evaluating WF as the foundation of our next-generat ...Show All

• Visual Basic How do I get data from an XML file in VB.NET Express 2005?

  How do I get data from an XML file in VB.NET Express 2005 I'm making a program that gets data from an XML file when the user clicks a search button. The collected data would be displayed in text boxes. You can also use the System.DAta.DataSet class, and its ReadXml method. Dim myDataSet As System.Data.DataSet myDataSet.ReadXml("c:\xmlfiles\xmlfile.xml") TextBox1.Text = myDataSet.Tables(0).Rows(0)("FirstColumnName") Hope that helps ...Show All

• SQL Server AdventureWorksDW database

  I can not find the databases and samples for SSIS that are mentioned in the tutorial on my disks, or DVDs. Please tell me where I may get them from Installing SQL Server copies the Samples off the CD, but doesn't install them. Start > All Programs > Microsoft SQL Server 2005 > Documentation and Tutorials > Samples > Microsoft SQL Server 2005 Samples to install. Greg. ...Show All

• Visual C# C# Function Library - Possible?

  I am new to C#, using VS Net 2003. As I make applications, I would like to add a library of oft used user defined functions; IsStringEmptyorNull(), IsStringNumeric(), etc. It seems that C# promotes class libraries rather than function libraries. I can put these functions into classes, but it seems clumsy; having to instantiate a class then call a method. Is there a way to make a function library so that I can just make an inline call like if (Is ...Show All

• Visual Studio Team System Cannot access project portal from remote computer

  I'm running TFS in single server mode. When I'm working local on the server everything works great. I can visit the portal and I can create new projects. But - when I try to visit a project site from a remote computer, I get this error in the browser: -------------------------------Start of message ----------------------------- The page cannot be displayed You have attempted to execute a CGI, ISAPI, or other executable program from a directory ...Show All

• Windows Forms problems with system.drawing

  I thought I was following the examples in help very closely, but no luck. Can anyone tell me why the following code does Nothing Dim bmp As Bitmap = New Bitmap("OcasoCamino.jpg") Dim gph As Graphics = Graphics.FromImage( Me .bmp) Private Sub frmMain_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim rect As New Rectangle(x:=24, y:=104, Width:=674, Height:=256) Dim p As ...Show All

• Visual Studio Team System Using Environment Variables in Team Build

  What is the syntax for using an Environment Variables in a Team Build script. I thought it would just be the same as a standard property, but its not working for me. I define an env variable on the build machine called WiXRoot, value of C:\WiX\2.0.3719 In my Team Build script I am using a WiX task which requires this value in the WixPath parameter < CompileMsi SourceFiles = " $(WiXSourceFiles) " OutputFile = " ...Show All

• .NET Development .NET Application crashes

  In the sample code , show below, we are merging many binary file to a single mp3 file. This process works fine for 4 times , but on the 5th time, the application crashes on br.Read without throwing any .net error. We have implemented try catch blocks also.It gives the system error &H80131315&  Dim fsInput As System.IO.FileStream Dim fsOutput As System.IO.FileStream Dim bw As BinaryWriter Dim br As Bi ...Show All

• Visual Studio 2008 (Pre-release) Warning msg box annoyance

  Hi guys, Please, limit the --------------------------- This is an unsupported version of Microsoft Visual C# 3.0.  As such many features may not work as expected. --------------------------- appearance to one time per install. It is very annoying Yes, however with a beta/ctp, then PSS can always tell what's going on by checking the VS version number in the "about" box.  However, if you change the C# language service, then VS's ve ...Show All

• Visual Studio Installing VS 2005 through vs_setup.msi

  Hi when I try to install VS 2005 throgh vs_setup.msi "Please run setup.exe for installation" Is there any way of installing this through vs_setup.msi. One more query we want to cutomise this setup by removing the some features(SQL Server Express edition)  from the msi. It will be great some one help me out in this issue since this is very urgent. Waiting for favorable reply. I replied on a separate thread. If you just install the ...Show All

• Visual Studio Team System Running more than 1 testlist

  Hi all, My vsmdi file contains 2 different testlists, each containing a different range of test methods. I specified both testlists in the TFSBuild.proj file like this: < MetaDataFile Include = " $(SolutionRoot)\AlfaPrint.Adam\AlfaPrint.Adam.vsmdi " > < TestList > AdamTestList </ TestList > < TestList > GraphicEngineTestList </ TestList > </ MetaDataFile > But only the GraphicEngi ...Show All