Dub's Q&A profile

• SQL Server How to view permissions of user-defined database roles in Management Studio?

  As part of our security project, I've done the following when logged in as 'sa': Created database roles 'dbrole1' within dbAccount Created login and user 'user1' and added user to be a member of 'dbrole1' Granted execute permissions on sp1 and sp2 to 'dbrole1' However, I didn't see the above permissions listed in SQL Server Management Studio - Database - Security - Roles - Database Roles - 'dbrole1' properties - securables A ...Show All

• Smart Device Development program crash for unknown reason - help!!

  Hi! i created a vb app with a C++ dll and made no changes to the dll but added another form to the vb app. the form does nothing except display a few images and text (a temporary help file). the application itself is a recorder and player that has been working for some time now. after adding the 4th form and deploying to the device, my recorder caused the app to hang and my player caused it to crash. this never happened before and i didnt make a ...Show All

• Visual Studio Team System Refresh on the TeamFoundationServer object?

  Is there a way to refresh TeamFoundationServer objects Basically, if I store a TeamFoundationServer object in my class, and the state of the server changes in another application, how can I force the object to update and be consistent with the server I am seeing behavior between applications that if I add a query in one application, it will not refresh in the second application until I get a new TFS object in the second application. As soon ...Show All

• Windows Forms Sql Server 2000 Notification Services

  Does anyone have an example of setting up a notification service using the SQL 2k Notification Services namespace  I have only found one article on this topic (besides MSN). Any help provided will be appreciated. Thanks, Jason I knew I had&n ...Show All

• Visual Studio Installing Visual C# .NET 2003

  I'm attempting to install Visual C# .NET 2003 on my laptop.  When the setup comes up, there's a four step process.  The first step is getting system prerequisites installed.  I got that part done successfully, and the next step is to install Visual Studio .NET 2003.  I select that option on the start-up menu, and I get a message tell me to "Please go to the Control Panel to install and configure system components."  Can ...Show All

• Microsoft ISV Community Center Forums Read data from excel through VB.NET

  Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection ...Show All

• SQL Server Grouping in List Control

  Hi, I am new with RS2000. I am working on a Reporting application. I have some Application names on X-axis of a bar chart say they are 90 in number. I want to group this chart in a list control in such a way that in each portion the chart must contain 15 application names if suppose there are 90 application names. Add a (detail) group to the list with the following grouping expression: =Int((RowNumber(Nothing)-1)/15) This should ...Show All

• Windows Forms SqlClientPermission

  OK.....I have been searching and haven't found much helpful info on this topic.  I am hosting a winform (user control) on a website.  The form makes a call to a stored procedure...:     Public Function getxxxxx() as dataset      ...Show All

• Visual Studio Team System How can I recover my view of the active counters for a Load Test?

  Maybe this is just showing my ignorance of the VS UI but I perform a LoadTest and in the Load Test Monitor I can see a graph of the counters for the test but on the left hand side I only get a summary pane. I used to have a list of counters that I could view and add to the graph but I cannot find that view any longer. How can I get the list of active counters to display in the Load Test Monitor so that I can add counters to the displayed graphs ...Show All

• .NET Development CLR assembly error

  Hi All,  I have a WebServices, which is working fine, but i need to expose this webservices as a COM+ object (Enterprise Services) and my codes should reference this COM+ instead of the web services (existing), to use the methods inside it.  When i tried to create a sample COM+ object and try to add reference to this object, the error i get is 'Type Library was exported from a CLR assembly and cannot be re imported as a CLR assemb ...Show All

• Architecture General best practices for .NET development

  Hello, I'm an ex Java developer now working for a young and fairly naive company that is largely .NET oriented. I, and really the company as a whole, feel very much "thrown into the thick of things" and I'm positive there are better methods and techniques to accomplish my goals. I just find myself often with general questions about .NET and writing .NET applications. Ideal versioning techniques, sharing libraries we have written ...Show All

• SQL Server Unable to connect to Analysis Services as a client

  Hi, I got SQL SERVER 2005 SP1 installed on a server and is running fine. I've installed BI studio on a client computer and I can access the database engine. On the client computer, while deloying my cube I get the following error : the project could not be deployed on the server "server_name\instance_name" due to connectivity problems. Verify that the server is running I've checked the project properties and in the deployment section ...Show All

• Visual J# Error Configuring Web Site

  I am using Visual Studio 2005 Beta 2 - I have completed Soup-to-Nuts 1 thru 9 doing them in Visual J# and have had to create all added code and files that appear from one lab to the next, not to mention the problems with the differences in ADO .Net with datasets and table adapters anyway I have go thru that, now Lab 10 deals with Web applications so I decided to revist the Lab "Creating ASP.NET Web Applications with J# - Part 1" I ...Show All

• .NET Development Concurrency violation when updating twice

  I have a parent row that I create, which will have a number of child rows related to it. There is a status field in the parent row that I give a value of "UnderConstruction" (which is an enum with a value of zero) so that, while I'm creating the child rows, the parent row will not be processed by another method that looks for new rows to process. After populating the rest of the parent row, I do a .Update on its SQLDataAdapter, which will ...Show All

• Visual Studio Express Editions I need help installing Starter kits!!!!!!

  Hi, i tried installing a starter kit. and when i get to stage 2 of the installation i get errors on everything thats installing. All the errors read: Installation stopped because the directory for the ProjectType value did not exist. The project type is invalid for your installation of Visual Studio. Please can you help me, I need the starter kit so i can create my band website Sorry I should have asked what edition of Visual S ...Show All