rsd_za's Q&A profile

• SQL Server Domain groups disabled by default. how to enable them by default?

  Hello, I notticed that to add a domain global group to a role, you first have to enable this type of object. Also, I did convert a few cubes from 2000. I have a lot of domain groups associated with a lot of roles, the problem here is that the membership shows a UID instead of the group name because the group object is disabled. 1) How could I have the domain group object enabled by default in a new cube 2) How could I have te domain ...Show All

• Visual Studio Exclude from Source Control

  In VS 2005/VSS 0.0d The option to Exclude xxxx from Source Control is not available to me for any files in a web site project. Which would be desirable as for example the web.config I use is not the same as for other team members, and also for dll references in the bin folder of the web project. Exclude from source control is not supported for web projects. Dll references in bin folder should be a ...Show All

• SQL Server How to get a handle of my queries

  Does anyone knows of a tool that will help me manage my queries I have 100's of them and all scattered. On my PC at home, some of them on my laptop, some of them at work, some in memory sticks. Then, when I need them I can't find the one I'm looking for so I end up writing the query again. Any ideas Hi, snippets are small chunks of code which will help you to avoide to code recurrent code chunks which you wi ...Show All

• SQL Server Error 3013

  I have a database maintenance plan job that failed with the following error on sql server 2000 Executed as user: HACIEXXWVNDA\MH-GAGI-WEB01$. Operation on device '\\.\Tape0' exceeded retry count. [SQLSTATE 42000] (Error 3230) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed. Does anyone know why this happened Any help is appreciated. Thanks Hi .. I'm getting the same error; please ...Show All

• .NET Development Obtaining a COM object via it's Guid in C#

  Is there an equivalent of CoCreateInstance() in C# That is, I want to create a COM object - but I won't know it's guid until runtime. I assume I can create a com object and then use the DispatchWrapper class to access it. t.i.a. Can someone provide a converted vb code to the above Thanks ...Show All

• .NET Development Binding a dropdown listbox

  Im trying to bind a dropdown listbox with a table in SQL Server 7.0. Whenerver i use this code , i get value: "System.Data.Common.dbDataRecord". Following is my code : Sub  Page_Load() Dim strSqlCities as String = "Select city from city"   Dim strConnection as String = "server=Maxood;database=watal;user id=sa;password=;"        Dim objConn as New SqlConnection(strConnection)   Dim Cmd as New Sql ...Show All

• Visual Basic Exception handling doesn't catch errors

  I seem to be missing a fundamental point regarding exception handling. My understanding is that when an error occurs, it can be caught by Catch without abnormally terminating the program. Mine will always abnormally terminate when an error occurs. An example is below. When the connection fails to open, the application breaks instead of executing the Catch block. Why Try cnSQL.Open() xMainMenu.ShowDialog() Me .Close() cnSQL.Clos ...Show All

• Visual Studio Tools for Office Unit testing VSTO solutions

  Hi, I am having great trouble unit testing the classes that I include in my VSTO 2005 Word document solution. For days I have been trying to work this out, but without any success. The main issue being that I need to get access to a valid Microsoft.Office.Tools.Word.Document instance when I start from outside of Word. For example, I could have a class like this: public class MyUtilityClass { public string SomeUtilityMethod(Microsoft.Off ...Show All

• Visual Basic [VB6] TEXT FILE PROBLEM..HELP ME

  Hello all, I want to know how to append my data into text file(C:\). My problem is when I append a data into text file, The data are appended in bottom of the Notepad text file. I want most recent appened data will be added into top of the file. My code follows, Dim s As String s = RsP.Fields("birthday") & vbTab & RsP.Fields("SEX") & vbTab& RsP.Fields("Weddate") & vbTab & RsP.Fields("spouse") & ...Show All

• SQL Server Returns Nothing, But Executes Fine

  SELECT tblWatchInstance.WatchID,tblWatchBrands.Description,tblWatches.Serial_Number,tblWatches.OwnerFName,tblWatches.OwnerLName, tblClients.Name FROM tblWatchInstance INNER JOIN tblWatches ON tblWatchInstance.Watch_Key = tblWatches.WATCH_KEY INNER JOIN tblWatchColors ON tblWatches.COLOR_KEY = tblWatchColors.COLOR_KEY INNER JOIN tblWatchBrands ON tblWatches.BRAND_KEY = tblWatchBrands.BRAND_KEY INNER JOIN tblWatchTypes ON tblWatches.WATCHTYPE_KEY ...Show All

• Software Development for Windows Vista changing process access levels/rights

  Hey, I'm trying to find some good information (articles, samples, whatever) on changing the access rights of a process. I believe the API methods include, OpenProcess, GetKernelObjectSecurity, GetSecurityDescriptorDacl, GetAclInformation, SetKernelObjectSecurity, etc. I am trying to disable some rights in a process like PROCESS_TERMINATE though I am having trouble finding some good information. Thanks all Luke ...Show All

• SQL Server Delete subreport at runtime?

  Is it possible to delete a subreport from a main form at run time I am trying to find a work around for the inability to conditionaly format a page break. I have a main form that has 10 subforms. Some of the subforms won't have any data (depending on the parameter values). When I export the main form to excel each subform needs to be in it's own excel tab. Obviously, I don't want a tab if there is no data. Any suggestions ...Show All

• Windows Forms Help listbox

  I have listbox with mulitiselect set to true; When I iterate to the selected items I need the selected item to be place in a textbox. foreach ( string lsStr in listBox1.SelectedItems) { message1.Add(lsStr.ToString()); } for ( int i = 0; i < message1.Count; ) { string message2 = System. Convert .ToString(message1 + ","); textBox1.Text = message2; } what im doing wrong, ...Show All

• Visual Studio 2008 (Pre-release) IIS Hosted Services and Dependency Injection Principle

  How would one supply the dependencies to a service when hosting in IIS For example, in the case of self-hosting, I supply a connection string or a business component to the constructor of the service. But how would I do that when the ASP.Net is responsible for creating my service instance Code sample (that won't work with IIS hosting): public class MyService : IMyService { private BusinessComponent _bc; public MyService( BusinessCompon ...Show All

• Visual Studio Team System XML report doesnot show excluded and absent messages.

  Hi all, I have an FxCop project with certain active, excluded and absent messages but while I save the report, the excluded and absent messages are not saved in the XML. Only active message are saved. The option in project default for excluded and absent messages are checked still the report doesnot contain excluded and active messages. I want all the messages in the report. Please anybody help me in solving the problem.Thanks in advance. ...Show All