pbairoleto's Q&A profile

• SQL Server How do I use Management Studio to set up permissions on an Application Role?

  Hi, How do I use Management Studio to set up permissions on an Application Role In AdventureWorks there are two Application Roles, role1 and User. The User AppRole has taken over the ownership of the schemas db_datareader and db_datarwriter. Seems rather odd, is this significant for other uses of the database role1 is more like what (I think) I am trying to do. AppRole role1 has it's own schema called, role1. What do I have to do in Management Studio to view the permissions that have been set up on AppRole role1 and Schema role1 Similarly, if I create my own AppRole role2, and schema role2, what do I do via Management Studio to set permissions so that the Windows app that connects can have SELECT on say, Table HumanResource ...Show All

• SQL Server Best approach for creating SQL Server 2005 reports to run against SQL 2000 database engine

  We have a client who is running SQL Server 2000. They have Business Objects reports. We want to create those same reports using SQL Reporting Services and get rid of Business Objects. The trick is, we'd prefer to create them in SQL Server 2005 with VS 2005, so that we have the reports created with the newest version rather than having to use the older, less functional version to create them. What are our options here Can we create the reports in 2005 and somehow run the reports against a 2000 database without making our client have to install a SQL Server 2005 instance Or will we need to create the reports in SQL Server 2000 Are there other combinations that would work where we can still create them in 2005 but run against 2000 I'm sure t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Need a Mentor

  Hey I was wondering if anyone would be able to help me make a game with XNA I want to make just a simple little top down move car around game. But I can't figure out how to start (I did the tutorials) So I was hoping one of you fine gentlmen and women would be able to help me on msn or aim or somthing That way its live instead of continually posting back and forth on the forums. Thanks Very Much James   You will find that the guys here are very helpful and will be able to help when you have problems. if you do want to talk you can contact me though my site ( www.virtualrealm.com.au ), and I might be able to start you off. ...Show All

• .NET Development Are there another choice for ExecuteNonQuery?

  Are there anohter choice in Visual Basic 2000 instead for executeNonQuery. For the moment I use this command in while-loop. The problem is that it seems the executeNonQuery only run one time in the while-loop, even it suppose run many times if the the while-loop runs more then on time. you can try this way For IdLoop = 1 To DepartLoop MessageBox.Show(IdLoop) myCommand = New SqlCommand() myCommand.Connection = connDatagrid myCommand.CommandText = "update vnstelefon set idnr = idnr + 1" + " where idnr = " + TextBoxIDnr.Text.ToString + " and orginal = '" + ComboBoxDepart.SelectedItem + "'" myCommand.ExecuteNonQuery() myCommand.Dispose() Next IdLoop ...Show All

• Visual Studio 2008 (Pre-release) PeerChannel PNRP LinkLocal IPv6

  That's a lot of topics for one subject line, but then I have a lot of questions. :) I notice that when I use a net.p2p address with PeerChannel that it uses the Global cloud. If I want to register a mesh as LinkLocal only, is this possible with WCF If not, then it seems a possible solution (depending on the application) would be to publish a global cloud name that only a local subnet would be likely to derive. Not being an IPv6 guru myself, is there something I can use on a given link that every member of the link would agree upon without first having communicated with each other Perhaps a custom resolver would be a better solution Finally, is it possible to use a secure PNRP name with the PeerChannel or does it always prepend &qu ...Show All

• Visual Basic panel in array of panels not showing up on form

  why isn't Panel(1) showing up on Form1 thank you. -greg Public Class Form1 Dim Panel(4) As System.Windows.Forms.Panel Private Sub Buttons_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button.Click Panel(1) = New System.Windows.Forms.Panel Panel(2) = New System.Windows.Forms.Panel Panel(1).Location = New System.Drawing.Point(38, 179) Panel(1).Name = "PanelTopLeft" Panel(1).Size = New System.Drawing.Size(53, 60) Panel(1).Location = New System.Drawing.Point(200, 103) Panel(1).BackColor = Color.AliceBlue Panel(1).Visible = True Panel(1).Refresh() Me.Refresh() End Sub End Class Thank you thank you ...Show All

• SQL Server Convert tick-by-tick stock price time series data grouped as high, low, open and close prices

  I am working on a stock price analysis project. Stock prices are stored in SQL Server as tick by tick data (that means in a high frequency) and need to be grouped by minutes in order to display them as as high, low, open and close prices in a candlestick or similar chart. The fields in the table are: Time (for every stock price tick) Price (stock price) Symbol (of the stock) A sample time series would look like this: 11:45:01 $22.11 MSFT 11:45:02 $22.10 MSFT 11:45:04 $22.25 MSFT ... ... ... 11:45:58 $22.45 MSFT 11:46:03 $22.22 MSFT 11:46:08 $22.25 MSFT ... ... ... 11:46:59 $22.45 MSFT The result of the SQL query should be: Symbol Time Open High Low Close ...Show All

• Visual Studio 2008 (Pre-release) The project type is not supported by this installation?

  VS2005 Team Suite RTM with SP1 Beta - XP SP2 - latest patches Hi, I have been learning XAML at the intro level. I had an old version of dotnetfx3 and wpf templates and I could create a project and run it. Yesterday I removed the old templates and the old framework with a removal tool and installed the RTM framework and new templates. However now I cannot open create a new project. The error message I am receiving is: "The project file c:\documents and settings\renee\localsettings\temp\4t4baj4.dyv\temp\WindowsApplication1 cannot be opened." The project type is not supported by this installation. I have not installed the extensions. I never have. I don't have enough disk space on the current system. What ...Show All

• .NET Development Print problem

  Hai, Im wrking on AJAX and Reportviewer.Im Having a webpage with a UpdatePanel,Button and a ReportViewer within Updatepanel.Whenever i click on Button, report gets loaded in updatePanel. Report gets Loaded Successfuly in Updatepanel.But whenever i click on PrintButton of reportviewer (Which is Builtin within in reportviewer control),Im Unable to Get Print-Dialog .Im not able to Print report..... Whenever i remove the UpdatePanel ,Im able to Print report .(thru report viewer) Is it not possible to Print whenever i try to keep Reportviewer in Updatepanel. Can any one plz tel me a solution for this............it is very Urgent ............ Thank you in advance............ With regards, Mahender 9989302525..... ______________ ...Show All

• Windows Forms multiselection in a datagrid

  Hi! I would like to know how can i select multiple rows in a datagrid I can select an entire row but i can't do a multiple select. I have another question,how can i add a checkbox on the header of my datagrid I want my application do allow one or more rows selection. When the selections done, the user have to check the checkbox to allow another event to happen. Thanks a lot!!! you can add checkbox  column to datagrid.There is an example of adding a tablestyle to a datagrid here . ...Show All

• SQL Server Free disk space in a cluster

  Hi, is there a way to restrict the result of xp_fixeddrives only to those drives the SQL Server cluster group has a dependency on Or, to say more generally, how can one find out the free disk space available for remote clustered SQL Server using only TSQL Thanks a lot. ...Show All

• Smart Device Development VS2005, CF2.0, C++, Platform selection

  My development environment is Visual Studio 2005 Enterprise. I have a C++ application containing both managed and unmanaged code. I've successfully compiled it for the Win32 platform. It executes correctly in that environment. The next step is to install it on a CE 5.0 using the Compact Framework (2.0, sp1 installed.) I cannot figure out how to switch VS from the Win32 platform to any other platform without losing the C compiler switches that enable it to use managed code. My process: 1. Using wizard, create a new solution/project for C++, Console Application (which is the model I want to use.) 2. I immediately "Build". All is well. It says "Hello world." 3. I select Configuration Manager, and choos ...Show All

• .NET Development Xlink - How to use xlink in every browser ?

  Hello, I must develop a site in pure XML. I carried out my first pages and I encountered some problems to create links between the pages. I used Xlink for my links, the simple version (http://www.w3.org/TR/xlink/). The links function correctly under Firefox 1.5, but impossible to make them function with Internet Explorer 6 or Opera 9. As that did not function for these navigators, I tried to implement another recommendation of the W3C, events XML (http://www.w3.org/TR/xml-events/). But here still, I did not succeed in obtaining functional links. The code is not interpreted as it should in Javascript. Here the code which I used: example.xml < xml version="1.0" encoding="ISO-8859-1" > < xml-stylesheet ...Show All

• Visual Studio Tools for Office Still in need for help...

  Hi, I've tried everything: I tried to uninstall the AVG antivirus, then I tried to reinstall Office...to no attempt! Nothing works anymore! But I believe I've found the error...instead of starting within VSTO, I've made a simple form containing all the buttons that my plugin had got, assigning the same methods it got...and I tried to start it, in order to test the single function... But even this doesn't work, because I receive a FileNotFoundException when I try to create my controller which the plugin used to query in order to get the methods...the message is: Retrieving the COM class factory for the component with CLSID {..} failed due to the following error: 8007007e. So, it's possible that the antivirus has messed up something within C ...Show All

• Visual C# class design: protected fields

  I have two questions: 1.) Why am I not supposed to have protected fields in a class 2.) consider the following example: public class A { private int field; public int Field { get { // do some extra work here return field; } set { this.field = value; // do some extra work here } } } public class B : A { public B(int field) { // set the base.field here without doing the // extra work // of the set acessor } } If I do not expose the field as protected I would need to introduce protected SetField() and GetField() Mehtods for each field that avoid doing the extra work in the Public Property acessors What would be a good design for such a scenario Well I suppose you're right. I guess I took what you said to mean ...Show All