Will Riley's Q&A profile

• SQL Server SQL Server 2005 Service Pack 2 -- Now Available

  SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides. SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx SQL Server 2005 Service Pack 2 blogs: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx Thanks, Sam Lester (MSFT) How does one move from SQL Server 2005 SP2 CTP ( Community Technology Preview) to SP2 RTM (Released To Market) version that was released this week Do I need to uninstall CTP and then apply RTM version or I can apply RTM over CTP ...Show All

• Smart Device Development PDA windows Form

  I need to develop a project which allow to control all the form flowing. Which mean my PDA can handle 2 or more same form at the same time, in my menu bar i can choose to activated the form. My problem is i do not know how to control the form while 2 or more SAME form open and store it into the menu bar. For example Dim NewFrm as frmOrder NewFrm = New frmOrder ' First Form 'Then open the second Form NewFrm = New frmOrder ' Second Form In what method i can create a form in a child so that i can call Either FirstForm or Secod form Ya....I have store it using an array. then i wanna add into the menuitem, when user click on the menuitem the form will show up. Now my problem is, ...Show All

• Software Development for Windows Vista Registry entries for TimeZoneInformation are no longer correct

  The registry values for the current time zone in Vista appear to be incorrect (or no longer supported). We rely on being able to get the name of the currently selected time zone from the registry, but it appears to be incorrect in the RC1 and RC2 builds of Vista. The registry key on 2003R2 is: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation "StandardName"="Pacific Standard Time" "DaylightName"="Pacific Daylight Time" The two values here are not working correctly with Vista (we rely on StandardName). The registry key on Vista is: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation "StandardName"="@tzre ...Show All

• Visual Studio Team System Whether to start using Database Professional now or wait until production release?

  Ok, I used Database Professional at TechEd and can't wait to start using it at work. However, I'm concerned about using a CTP version since it's not even beta yet. Here's my situtation... We drastically need version control of our database because it is shear chaos right now. I have no choice but to implement a solution next week. I'm planning on scripting out the entire SQL 2000 database into scripts and put in Team Foundation Server. Then, I was going to purchase Sww SQL Deploy that can automatically run all scripts in a directory to automate our deployment to dev and qa databases. I've used a similiar method for Oracle and know others that have taken this basic approach as well. The major disadvantage to this approach is that I'm goi ...Show All

• SQL Server custom sorting dimension values

  Hi, This one seems like a weird problem to me. Lets say I have a dimension which has only 5 values: High,Low,Medium,VeryHigh,VeryLow. When i browse this dimension, I want it to be custom sorted so that I always get them in the below order: VeryLow, Low,Medium,High,VeryHigh Is there any way to accomplish this I can arrange them in this order in the VS 2005 browser ide, but can i persist my custom arrangement Thanks If you're using AS 2005, you could create an attribute to order the 5 members by. If the dimension source table is in SQL Server, you could add a named calculation for the attribute, like: case dimvalue when ' VeryLow' then 1 when ' Low' then 2 when 'Medium ' then 3 when 'High ' then 4 ...Show All

• Visual Studio Express Editions Decimal point

  Hi there i have a problem with my little calculator project, i did everything but i got stuck at the decimal place, What i want the calculator to do is to give out an error when a user try to put in morethan one decimal point eg. 12.30.30 or 12..30. can somebody help me please. regards Marcus here is my code Private Sub btnOne_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOne.Click If tbCal.Text = Nothing Then MsgBox( "Must have a TOTAL to calculate change" ) Else tbcalculate.Text = tbcalculate.Text & btnOne.Text tbChange.Clear() End If End Sub Private Sub btnTwo_Click( ByVal sender As System.Object, ByVal e As Sys ...Show All

• Visual Studio 2008 (Pre-release) Binding to Custom Property

  How do I bind to a custom property More specifically, I'm trying to bind the Fill color of a Path to a property of the Window. The Window property is defined in the CS file. I'm not sure whether it should be a Brush or a string at this point... Seems simple enough, but this doesn't work: < Path Fill = " {Binding ElementName=myWindow, Path=fillColor} " Data = " F1 M 53.795410,18.108398....Z " /> I found some samples and set up a dependency property like you suggested. The default value in the Metadata doesn't take affect. I've tried also tried changing HighlightColor at runtime, but the background color of the grid isn't affected. namespace TestBinding { public ...Show All

• Windows Forms how can i get the value between " " commas ?

  how can i get the middle values of " " "REM16704","PTC","OL","xxxxxxxxx","1135020002","303675","Buy","200300",".0 in this function we can get the middle vlaues but in this function when i send (") inverted commas i get no value thanks ------------- Private Function GetMiddle( ByVal text As String , ByVal str1 As String , Optional ByVal str2 As String = "") As String () Dim temp As Integer Dim ret(2) As String If str2 = "" Then str2 = str1 End If Dim index1, index2 As Integer index1 = text.IndexOf(str1) index2 = text.IndexOf(str2, ind ...Show All

• System Center SSCP running on Windows Vista

  I'm running Vista Ultimate RC1 (build 5600) and SSCP won't install. Any way to get it to install or is there an expected time when we can load SSCP on Vista I had this exact same problem. Internal Error 2738" is a vbscript runtime error. From "Start" -> "Accessories" right click on "Command Prompt" and select "Run as administrator" command prompt. Type: "regsvr32 vbscript.dll", this will fix this problem. This should be resolved by the time that SCCP2007 goes RTM. ...Show All

• Visual C# repeating code

  I have about 40 picture boxes arranged in a table of 4X10 (also named to show their location when the first row is 0 ie. the box in fifth row and third column will be called pictureBox53). I want to put images on them according to an array (of 10 on 4) without having to write the code every time for each picturebox. I need something like: for ( int i = 0; i < 10; i++) { for ( int b = 0; i < 4; i++) { PictureBox <i (the variable><b the variable>=pictureBox01 FromChildHandle array; } } Make an picturebox array field on your form (either jagged or multi-dimensional will do), then store references to your picture boxes in those arrays in either your form con ...Show All

• SQL Server dts parameter

  I am running the DTS as follows, SET @CMD = 'dtsrun /S '+@server+' /U '+@user+' /P '+@pass+' /N '+@dtsn+' /A MyBinaryID:19 = '+@MyBinaryID EXECUTE master..xp_cmdshell @CMD This does not return all the data correctly. MyBinaryID is a Binary(8) field, any idea how should I pass MyBinaryID and define what type of parameter in the DTS ...Show All

• Visual Studio Registering a Debugger Visualizer for byte[]

  Greetings, I'm trying to make a debugger visualizer for byte[] but I can't access it while debugging, I only see the default visualization, and that combo-button to select the visualizer doesn't appear. I'm installing the assembly in C:\Documents and Settings\<username>\My Documents\Visual Studio 2005\Visualizers. What am I doing wrong Here is the code: using System.Text; using System.Diagnostics; using Microsoft.VisualStudio.DebuggerVisualizers;   [assembly: DebuggerVisualizer ( typeof ( ByteArrayVisualizer ), Target= typeof ( byte []), Description = "byte[] Visualizer" )]   public class ByteArrayVisualizer : DialogDebuggerVisualizer { protected override void Show( IDialogVisualizerService ...Show All

• Windows Live Developer Forums MetaWeBlog, Update weBlog style

  Hi, I have an implementation of the metaweblog API for a own blogengine. And I have a question regardning how Live writer gets the blog styles. 1. When the dummy post is created, what page does live writer request. The Blog page, the viewblogpostpae (permalink) 2. What elements must the page contain, any specific CSS class names etc /P ...Show All

• Visual Studio can't open (include) iostream.h in Visual Studio 2005

  Hi, i have a problem with Visual Studio 2005. I want to include the iostream.h, but the compiler told me the error-message (fatal error C1083), that the file couldn't opened. No such file or directory. Can anyone help me I don't have deleted any file in the install-folder. cout (and most of the stuff that comes from the standard headers) is declared in the std namespace so you need to either write std::cout << "Hello World !" << std::endl; or add using namespace std; after the #include <iostream> like in: #include <iostream> using namespace std; int main() { cout << "Hello World !" << endl; } ...Show All

• Visual C# key up event

  I have a basic key up event so when you hit enter on the keyboard it will send the data to a remote server, but everytime you hit enter there is a beep the code runs fine but how do I stop the beep thanks one thing to note is this only happends when the enter key is pressed but the if I break the code at if(e.KeyCode == Keys.Enter) the sound happends before this... ...Show All