Syl20's Q&A profile

• SQL Server SQL Server 2005 System Table (View?) Map

  Is there an estimate on the availability of the System Map for SQL2005 If it is already out there, would someone be so kind as to tell me how to get it Thanks, DO A poster that shows most of the SQL Server 2005 system views (catalog view and dynamic management views) and their relationships will be available in the December issue of SQL Server Magazine. Regards, ...Show All

• Visual Studio Team System MSN Messenger integration?

  Hi, I have seen several demos from Microsoft events where when a work item is changed, a build produced or an item checked in a MSN message is sent to a team member as well as an email. Can anyone point me to some sample code for this please. Also code for sending messages via Office communicator would be most welcome. Many thanks, David You can use the MSN Alerts service, to publish notifications to users that have opted into receiving via IM, e-mail and mobile based on the users presence and routing rules. You publish new notifications to the service via RSS.  You can sign-up or find out more http://signup.alerts.msn.com ...Show All

• SQL Server Transfer SQL Server Objects Task

  I need to transfer a table from a 2005 DB to a 2000 DB. The table names are different in the two databases, but the schemas are identical. I could not see any way to do that. Am I missing something simple Is there a property that I can set through an expression how about an open datasource from sql2k and then do a "select into" -------------------------------------------------------------------------------------------- OPENDATASOURCE Provides ad hoc connection information as part of a four-part object name without using a linked server name. This example accesses data from a table on another instance o ...Show All

• Windows Forms DataGridView Detail Row Saving

  Code snip: Me .BindingSourceDrivers.DataSource = MyDataSet.Tables( "Drivers" ) Me .BindingNavigatorDrivers.BindingSource = Me .BindingSourceDrivers Me .DataGridViewDrivers.DataSource = Me .BindingSourceDrivers MyDataSet.Relations.Add( "DriverToCars" , MyDataSet.Tables( "Drivers" ).Columns( "ID" ), MyDataSet.Tables( "DriverCars" ).Columns( "DriverID" ), True ) Me .DataGridViewDriverCars.DataSource = Me .BindingSourceDrivers Me .DataGridViewDriverCars.DataMember = "DriverToCars" Chris, Did you get an answer to this I'm having a very similar problem ...Show All

• Visual Studio Tools for Office Caller / Sender

  Dears, I'm trying to retrieve the information of "calling cell" of a UDF in Excel, but I can't use, for example Application.Caller.Address, in C# code now. What's the equivalent code of Application.Caller (I tried Excel.Range r ca = (Excel.Range)Application.get_caller(1) in C# but it show an error that conversion of Int32 to Excel.Range failed) I want to get the original cell value & formula for a custom UDF in VSTO in the Worksheet_Calculate event handler. (Unlike Worksheet_Change, no Target nor reference to calling cell in Calculate handler base on my understanding) Thanks, You are correct ...Show All

• SQL Server Data Sources and Connection Managers

  Greetings my SSIS friends This is probably a silly question but what exactly is the purpose of creating Data Sources when it is possible to set up individual connection managers Thanks for your help in advance. If you want to reuse connection managers across different packages, you can create data sources and choose new or existing data connections. ...Show All

• Audio and Video Development Cineform HD

  Cineform HD is a video format which plays under Windows Media----want to know if Windows DRM can be used on top of this propreitary encoding technology Hello Ravi, Media Foundation is the new multimedia platform that we are shipping in Vista . It consists of the new audio and video pipeline, Protected Media Path, and DXVA 2.0. This forum has been created to answer questions pertaining only to Media Foundation. It looks like your question isnt related to Media Foundation.    We have started documenting about Media Foundation on MSDN and you can learn more about it here: http://windowssdk.msdn.microsof ...Show All

• Visual Studio Team System FXCOP to run before check in

  I have my requirement is this. I need to get FXCOP to run before the developer can check his file in I want this to be a automated process. i.e i dont want to add FXCOP as a external command. But instaed when user tries to check in the file the FXCOP should rin and check the code only then the CHEK IN shud happen Is there a way where we cawn do that thanks in advance bobby Hi Bobby, this feature exists in Visual Studio Team System in combination with Visual Studio Team Foundation Server. Here you can add a "Code Analysis Policy" which disallows checkins when FxCop ...Show All

• Visual Basic VB2005 and webbrowser control

  Hi, I am trying to use the webbrowser control as a list view for viewing files on the disque. My main purpose is to use build-in fonctionnalities like thumnails view withaout having to write code (reinvent the wheel). It works great but I don't know how to programatically control the way the browser display files. I mean, how to control the "view" property (list, details, thumnails, etc) of the web browser. I also would like to remove that menu pannel on the left. Can anyone help me Thanks, Patrick I think that the WebControls in Access and VB 2005 are not the same at all, because in my WebControl, the docum ...Show All

• Software Development for Windows Vista Will 5270 be available for other MSDN subscriptions?

  I'm an MSDN professional subscriber, and it looks for now that Universal accounts are the only ones with access to the new 5270 build.  Will it be released for the rest of us soon Thanks, Dan It just got posted...Now everyone promise me that you will wait 44 minutes to download it...43 mins.... ...Show All

• SQL Server Preview Error

  Hi all, I am all the time receiving this arror message: TITLE: Microsoft Report Designer ------------------------------ A connection cannot be made to the database. Set and test the connection string. ------------------------------ ADDITIONAL INFORMATION: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) What should i do Thanks Hi, you are trying to logon with your datasource object as a SQL Server login, but your SQL Server doesn’t accept mixed (this includes SQL Server as well as Windows) authentication. So either switch your server ...Show All

• Visual Studio Express Editions Problems with controls Position

  Hi I am new with VB Express. & for .NET Environment. Please Leave this post if it is silly. I tried to place three buttons in the form. I Placed it, compiled it and ran the form, and it worked properly. After I tried adding another button in the form. I rearranged the buttons to a new location. saved, compiled and when executed, the three was still on the old location , and the new button in the new position. I tried re arranging the again and again . but still the three buttons were on the old location only and the new button in the new location. I also tried to accomodate the new button with the three button itself. I ...Show All

• SQL Server ISNULL ( ) support in SQL Server mobile?

  Is ISNULL ( check_expression , replacement_value ) supported in SQL Server 2005 Mobile edition. If not, then why the following statement executes without any error: -  " select ISNULL(a,12) as test from tableA " Where 'a' is int column. However, even though i do not get an error, it doesn't behaves as expected. I mean the result which i get is : - a. If the column is not null, the value in 'Test' (resultset) is False. b. If the column is null, the value in 'Test' (resultset) is true. The expected result was that the Null values would get replaced with the specified replacement value. The Questions are: -  1. Is ISNULL( )  su ...Show All

• Windows Forms Building projects not running

  Hello, I can't get any of my compiled programs to display data into the forms WITHOUT using the debugger. I don't know at what point this happened. Using Visual Studio Express 2005. Anyone know what I am talking about ...Show All

• Windows Forms Deploy .NET Framework with application?

  Sorry if this question is really basic, but my team has just decided to do a .net windows forms application (we have been asp.net for about 1 year).  I was wondering if it is possible to distribute the .net framework along with our application when we go to install it in our enterprise.  Thanks. I've been distributing software fo ...Show All