Rob Reis's Q&A profile

• SQL Server Execute a number of tasks without executing a package - "Execute From Here"

  Hi guys, The ability to run a task in isolation (right-click on a task, select "Execute Task") is fantastic. But, what if I want to run a subset of all the tasks in a package My only option is to disable all the tasks that I don't want to execute and then execute the package. How about when right-clicking on a task there is an option "Execute from here" which runs a task and then all tasks subsequent to it. Execution could be halted through the use of breakpoints. What does anyone think Would that be useful Thanks Jamie Well, you have other options. You can muck with the precedence constraints that go before the portion that you ...Show All

• Visual C++ Strange error with _fileno

  We're in the process of converting from visual studio 98 to 2005 (yes, we were a bit behind the times). Most of the changes are now dealt with, but there's one weird one that we can't figure out - it looks like a bug in the compiler. Here's the error we get: v:\frame\utils\.\preftext.c(104) : warning C4996: '_fileno' was declared deprecated C:\MSDev05\VC\include\stdio.h(219) : see declaration of '_fileno' Message: 'The POSIX name for this item is deprecated. Instead, use the ISO C++ conformant name: _fileno. See online help for details.' v:\frame\utils\.\preftext.c(469) : warning C4996: '_fileno' was declared deprecated C:\MSDev ...Show All

• Visual Studio Team System Possible bug: Tools->Options->Database Tools->Database Connection->Instance option change doesn't affect until VS is restarted

  subj Nick, Thank you for the feedback, I think it may be one of the known issues for CTP. Anyway, I'll look into it. By the way, there is a way to submit a bug or a suggestion directly to the team (bypassing a forum) at http://connect.microsoft.com . Best Regards, ...Show All

• Visual Studio Team System Please give us better help files on the Version Control API

  I have been working on a POC that does a Get from the Version Control Repository. I have been heavily scouring the VS 2005 SDK help files, blogs and the Internet at large. I have found limited information on this API and the Help files are all but useless. An example of a help topic for the GetRequest.ItemSpec property is below. This gives me no indication of what this ItemSpec object is or does. Can someone at Microsoft please make it a priority to get us at least a good help file for this API. It would be even nicer if there were additional code samples so that we can see these API constructs in context. Visual Basic (Decla ...Show All

• Visual C# boolean expression evaluation

  Hi, is there any better way to determine whether the expression is true than putting it into the DataTable and perform Select Currently solving like this, but seems quite expensive to me: string var = "2" ; DataTable eval = new DataTable (); eval.Columns.Add( "var" , typeof ( string )); eval.Rows.Add( new object [1] {var}); string expr = ">1" ; return  (eval.Select( "var" + expr).Length > 0) Are you trying to create dynamic code You could juste convert them to integer return Int32.Parse("2") > Int32.Parse("1"); If you want dynamic code you can use th ...Show All

• SQL Server xp_getfiledetails support in SQL server 2005

  Hi, I have been using xp_getfiledetails in SQL server 2000 but it is not supporting in SQL server 2005. Do we any alternate way to get the file size details My goal is need to get the FLAT file size which I'm exporting from table. You will have to write your own SQLCLR TVF or SP to perform the OS file operations. You can also use xp_cmdshell and call any of the OS utilities to get the information. But it is encouraged to use SQLCLR for these purposes since you can restrict the operations to what the SQLCLR code performs. ...Show All

• Visual Basic Trapping Function keys (F2)

  How do i trap for function keys when inside a control (text box, inkedit)...KeyPressEventArgs only fires off for the ascii set... Thanks, Dan Hello. You just need to look at something like the KeyUp event for the control. Private Sub TextBox1_KeyUp( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyUp If e.KeyCode = Keys.F2 Then 'do something here 'you could reject the key as follows: e.Handled = False End If End Sub ...Show All

• Smart Device Development some question of datagrid in .netCF.

  I have three question of datagrid in .net compact framework. first, How do I freeze the first colum of a datagrid when I scroll HScrollBar of the datagrid Just like Excel do work second,How do I use AlternatingBackColor of DataGridTableStyle in datagrid in .net compact framework third, How do I specify each colum width of datagrid according the maximal length of the colum That's all. Can anyone help me Thank you very much. Thank you, Ilya Tumanov . I get a lot of help from you.Thanks. ...Show All

• SQL Server "Current day" MDX

  Hi, is there any "update" on how to do the "current day" as a set in MDX with SQL 2005 based on the actual system date If you don't want to base that on the system date is this still the "best practice" to introduce some "flags" in the time dimension to identifiy the actual day, last week, ... Just the way it was introduced with the BI Accelerator tool... Thanks, It's an interesting question... I can't actually remember how SSABI did its current time periods, but from what you say I guess it created sets which filtered on a member property value such as 'Is Current Day'. T ...Show All

• Windows Forms MonthCalendar control - formatting problem

  I'm using VS 2005 Beta 2 and I have a Windows form with a MonthCalendar control on it.  I have the control configured to show 1 row by 1 column, essentially a single month at a time.  When the application is executed, the dialog displays and the MonthCalendar control behaves as though it is to use as much space as possible to show as many rows and columns as possible.  Actually viewed as a 2 x 2 matrix.  What gives   Is this a known bug Thanks, Bob Do you have the MonthCalendar Anchored to multiple sides or Docked   The MonthCalendar will display as many months as possible based on it's size.  If you ...Show All

• Visual Studio VS.NET 2005 - Post install Error messages

  [05/04/05,22:28:40] Microsoft Visual Studio 2005 Standard Edition Beta 2 - ENU: [2] ERROR:Error 1331.Failed to correctly copy vcredist_IA64.exe file: CRC error. [05/04/05,22:28:41] Microsoft Visual Studio 2005 Standard Edition Beta 2 - ENU: [2] ERROR:Error 1331.Failed to correctly copy vcredist_x64.exe file: CRC error. ***EndOfSession*** Did anyone else encounter similar errors This doesn't seem to have affected the normal functioning of VS 2005 in any discernable way. Since it's just a couple of redists for 64-bit CPUs, it doesnt make a difference to me in any case. Just thought I'd share These errors can be safely ignored. The files ...Show All

• .NET Development Secure TCP with .net 2.0

  Hello I am running a .net remoting application and want to secure the tcp traffic between server and clients. Users connecting to the server should be authenticated and the traffic between server and clients should be encrypted. To make my problem a little bit more understandable I will post my current approaches. Servercode:             IDictionary properties = new Hashtable();             properties.Add("port", 8535);             properties.Add("secure", true);   & ...Show All

• Visual Studio Express Editions VB6 to 2005 Control Arrays

  Can someone please tell me a little bit more about Control Arrays after upgrading VB6 to 2005 There are 7 images which use the same click sequence, and they are all named Card. The following is a sample of the code: VB6: Private Sub Card_Click(Index As Integer) If Card(Index).Picture = Image2.Picture Then Safenum = Safenum + 100 Card(Index).Picture = Pile(1).Picture Call Nextmove Call Enemymove Exit Sub End If End Sub VB 2005 after conversion: Private Sub Card_Click( ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles Card.Click If Card(Index).Image.equals(Image2.Image) ...Show All

• SQL Server Execution of Package failed

  I am trying to design package which would copy all tables and stored procedures from one server to another. It used to be simple task in SQL 2000, there was wizard. However the new wizard does not work... I wrote SSIS package, but when I execute I get the following error: "Can not apply value null to property Login..." Any idea It seems to me that this new SQl2005 is not that simple to use like 2000. 2000 was a great product. I am considering to rollback to 2000. Very frustrated with the new one...          There should be more to the error message than that. Please can you copy the ...Show All

• .NET Development **Disconnec Wireless Networking**

  Hi This is very important that i know this... I have created a vbscript that detects the NIC's IP Address and if the IP address is withing the conditions - it stops the following services: Smart Card Service Wireless Zone Configuration Service Under the group policy set - user's cannot start services - so they cannot connect into a wireless network. PROBLEM: When the user logs into the network with a network cable its fine, my script works. But... If they take out the network cable, and re-insert it what happens - it assigns a DHCP address - or if they log on locally - then they insert the network cable - it picks up an IP and wirele ...Show All