Blicos's Q&A profile

• SQL Server Retrieve info (alerts, Custom Error Messages etc) from off line master and msdb databases

  Hi, Well, we have spent a happy weekend building a new server as our old one had a terminal hardware crash, and repeatedly rebooted. All OK as the user databases were on a SAN, so we just pointed the new server at the san, attached the user DBs and off we went.... We also use alerts extensively to run jobs. We are now in the situation where the old server will come up, but SQL server will not run as the system DBs are on the SAN. I need to get the error messages and alert details off of the old MDF files. Any ideas as to how I can query these databases I cannot attach the master/msdb DB to another server under another name as it giv ...Show All

• .NET Development Cross Database Form Parameters

  Hi, The new database controls work well by permitting the ConnectionString provider name to be toggled based on the database, e.g. providerName="System.Data.SqlClient" or providerName="System.Data.OracleClient". Grids still work, selecting the data from the new database providing tables have the same names and the queries are generic SQL. Unfortunately when you start using query parameters, the parameter names appear to be tied to the database used: :parameter for Oracle and parameter for SQL Server What is the way around this Does there exist a cross database parameter format, or do we have to at runtime scan and replac ...Show All

• SQL Server Could anyone attach the AdventureWorksDW to their SQL Server database engine?

  Hi, all here, I got a problem when trying to attach the AdventureWorksDW sample database to the SQL Server database engine. Error occured as: could not find row in sysindexes for database ID 21, object ID 1, index ID 1, Run DBCC CHECKTABLE on sysindexes . The sample database was downloaded from http://www.microsoft.com/downloads/details.aspx FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en . So could anyone help me to solve this problem tho thanks a lot for any guidance and help. Hi Hellen, Try isntall from scripts.. look this URL on BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/7de6ceb0-be7a-43 ...Show All

• Software Development for Windows Vista Windows 98 operating system is not working with AMD Athlon processor with ASUS mother board

  I am using AMD Athlon processor(64 bit) with compatible ASUS motherboard . I am started installing windows 98 second edition , installation is successfull. After the OS installation is over, i started installing Mother drivers from AGP card till Audio drivers. While doing the Video drivers for SIS chip support, installation was successfull. But after rebooting Windows 98 logo's display and then only small clock with questioned in frequency. I don't know, whether the problem with the motherboard or the OS. Then i check with other system with similar configuration, same problem was arrived. I would like to know, whether it is compatability p ...Show All

• SQL Server AS 2005 Business Intelligence Wizard - rerunning to add time calculations

  In Analysis Services 2005, once you’ve used the Business Intelligence Wizard in the BI Development Studio to add time calculations to a cube, how do you come back later and add additional standard time calculations based on the named calculation that was already created in the cube’s data source view by the prior run of the Wizard I'm running SP1 on Standard Edition.  I'm also using the code (below) that's recommended as a workaround but still get the same problem.  NAs are displayed when I try to browse the data for this measure / calculation combo.  All I've done is put the code into my calculations script on A ...Show All

• Visual Studio Express Editions Default Browser

  How do you get the default browser to open with a url without using the webbrowser control. You used to be able to do it in vb6. Or how do you get the webbrowser control in visual studio 2005 beta to show anything I put in webbrowser1.navigate( http://msn.com ) for instance and it shows a page that is an error page saying it cant find the server. But IE starts fine out side of Visual Studio and finds the server all the time. You can launch the browser (or any other external application) using the Shell command. The Navigate method of the WebBrowser control takes a string as an argument - if you add quotes (" http://msn.com ") it sh ...Show All

• Visual Basic need help???

  hi! i'm new to vb.net from vb6. i have two form ( form 1 & form2 ) both contains textbox1. for vb6 my code look like this; form2.textbox1.text = form1.textbox1.text but it didn't work with vb.net...any help thanks, mac Hello, i've tried this code and it works... Dim frm2 As New Form2 frm2.TextBox1.Text = Me .TextBox1.Text frm2.Show() Me .Hide() thanks, mac ...Show All

• Windows Forms loading treeview from a DataBase

  Hi, I am trying to load my items from Database to a Treeview but i have faild My table contains id, parentId, nodeName like this: (1 , 1 RootNode) (2 , 2 , ParentNode) (3, 2 , Child_for_2) (4, 4 , AnotherParent) (5 , 2 , anotherChild_for_2) (6 , 4 , Child_for_4) My problem is ,, I can not read it to my Treeveiw ( need code). ...Show All

• Windows Forms How to make the mouse click...

  How can i make the mouse click automatic,  example:  if(num5 == num 6)  {  //Mouse click  }  Thx in advance  Note: This is C# and windows form. Hi everyone...in the future, I'd ask that you all please use the <<b>code</b>><<b>/code</b>> tags in the future when posting code so it is formatted nicer.  Thanks!  :)  ...Show All

• SQL Server Using Custom Classes

  Hi ! Currently we have over 500 reports working with reportserver. We're planning to add on our report hyperlink to some pages of our web application. What i want is to have a classe with a function that will return a string for the action to do on the "Jump to URL" function. The reason why i need to use a classe is because if we change the name of a page we dont want to modify all the report one by one. Also we have some client that prefer to not have link in their report so i want to be able to disable this quickly. This function will allow me to do all that. So using Visual studio i've done a classe and i've put the .d ...Show All

• Windows Forms Disappearing Label Control

  Hello Everyone! I have a databound label control on a form with the text property set to an empty string. I know where the label is supposed to be on the form, however, no matter how many times I click in the general area, I can never seem to select the label. Does anybody know an alternate way to select or highlight a control on a form without having to click on it Thanks in advance for any help! Tony You can select it using the Properties window. There's a combobox there where you can select any control on the Form or the Form itself. If you don't see the properties window, make sure it's checked under the View menu ...Show All

• Windows Forms Query/Databinding question

  This is a 2 part question as it were so i will start with my query question. I am trying to make a generic query. My query on my table adapter is: SELECT MIN( ) FROM Client WHERE = AND = I ended up changing the WHERE clause so that it would be: WHERE ClientID = AND Status = This cleared up a few errors. I am now having a problem with the Select clause. It will work if i put an actual column instead of a in. It will not accept the passed parameter which in this case is a string. I am trying to develop a few of these querys to make it a bit easier on myself. If there is no way to do a query like this, i will then have to code 80+ seperate qu ...Show All

• Windows Forms Custom HostDesigner Implementation

  .NET 1.1 Ok, I got a custom host designer implementation. I have run into an issue. I have a form with controls in it, I save the form as a dll and I use it as a template in my host designer. When I load it up, and when the code hits the designer(intialize) bit then all the controls seem to hit the designerhost.add() routine and they all get added to the designer. When all is done, I see the buttons at the bottom, but whats the problem is that they are unselectable, I can select them and see the property browser change and I can move them via the property browser, but I can not move them around on the screen via the mouse and it never puts g ...Show All

• .NET Development Open a web site

  I'm have a problem with a hyperlink that I create a run-time. I'm displaying records from a database search one field is the clients web url. I can create the link fine, but when you click the link the server try to find the page on the current server. This is the code I'm using to create the link "<a href ='<%# container.dataitem("internet")%>'><%# container.dataitem("internet")%>". The link on the status bar look like this http://localhost/doc/www.domain.com/ . Thank for any help. Jeff It looks like a simple HTML issue.  Here's the difference. Look in the status bar when you link o ...Show All

• Visual Studio Express Editions ListBox.SelectedIndex

  I have a listbox with it's selection mode set to multiextended. What I'm doing is catching the indexchanged event and displaying an image in a picturebox control. The problem I'm coming across is when multiple items are selected in the listbox. It seems that when the index is changed, even with multiple indices selected, the selectedindex contains the smallest index (i.e. if I select item at index 0 and then select item at index 5, selectedindex contains index 0). I know that there is also a selectedindices method, but I'm coming across the problem of finding out which was the last selected index. Basically, I would like my picturebox contro ...Show All