Skyruner2's Q&A profile

• SQL Server Permissions Issue Logging into Mgt Studio

  I am unable to log into SSRS from Mgt Studio and receive a permissions error when I go to http://ServerName/reportserver in IE. When loging into Mgt Studio I've entered the following for the server name: ServerName ServerName\Insance http://ServerName/reportserver The first two methods return an error "server cannot be found". The third allows me to login but when I click on "Home" I receive: TITLE: Microsoft SQL Server Ma ...Show All

• SQL Server duplicit values in primary key constrain

  Hi How it is possible find duplicit values in primary key contrain Until now I seen two databases which crashed on bad index paging and dbcc chedb with full repair report error on repairing primary key with duplicit values. I am really shocked about it. How it is possible Or what I can do to prevent it Thank you Michal This is not a normal situation and something is wrong. To get an answer you are asking for ...Show All

• Visual Studio Tools for Office Need to Disable the Click Event of Save Option.

  Hi, Need is as below in VSTO:- When user clicks the Save button then my Custom Event should Fire, instead of the Default Event. I got success in calling my Custom Event as below:- ----------------------------------------------------------------- public StringBuilder GetInternalMenus(Office.CommandBarPopup objPopupControl) { StringBuilder strBuilder = new StringBuilder(); Office.CommandBarButton objButton = null; foreach (Office.Comm ...Show All

• SQL Server SQL Replication

  I have an end-user question about what replication solutions are available in SQL 2005 for the following configuration. We are looking for a replication option that will allow instant replication of changes made to the database at a remote office with a WAN connection. This is a manufacturing operation and the aplication in use requires those changes to be instantly replicated to the primary SQL server located in the data center. The vendor tha ...Show All

• Visual Basic Special Directories

  Is there a way to find the path to a users start menu (in order to install shortcuts). I tried special directories but I couldn't find it. Thank you. The following will get you the user start menu Function ReturnUserStartMenu() As String Dim DirInfo As System.IO.DirectoryInfo = System.IO.Directory.GetParent(My.Computer.FileSystem.SpecialDirectories.Programs) Return DirInfo.FullName End Function This is using My.Computer ...Show All

• Visual Studio Express Editions Can Visual Basic 2005 read and write to an excel xls file?

  Can Visual Basic 2005 read and write to an excel xls file   Can it do it without an addin or is there an addin/snippet available   thanks scott It most certainly can, has to be able to really since you script excel with VBA. Read these articles http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_xl2003_ta/html/odc_XLxmlhowto_.asp http://support.microsoft.com/default.aspx scid=kb;en-us;2 ...Show All

• SQL Server Very strange problem about "predict probility" in Microsoft Clustering algorithm

  Hi, all here, I found a very strange problem in my data case using Microsoft Clustering algorithm. The problem is: while with the increasing  of the population percentage to 100 % , the target polulation is up to 100% as well ( in my data case) , however the predict probability decreased to 0% !  What dose the 0% predict probability means here So, what is the problem then Any guidance is much appreciated. Thanks a lot ...Show All

• SQL Server Passing Variables

  I am having a hard time passing variables from the control flow to the data flow process.  The project starts off with a Execute SQL Task.  This task does a select from the sysdatabases table in the master db which creates a list of databases that will be queried for info.  That is stored in a info is stored in a package variable (user::varDBName) that is used to enumerate a For Each Loop and everything is good till this point.&n ...Show All

• SQL Server green-bar for list

  green-bar (altrnating background color) can be done in table, I can find a solution for matrix, but how about a list Thanks This doesn't seem to work in the scenario I have List containing: textboxes, table the above line of code, when placed in the list.backgroundcolor gives the following (have also included rownumber ) 2 white 4 white 6 white etc.. this is because it appear to be taking into account the detail (table) level So, instead o ...Show All

• Visual Studio Added project reference not reflected

  Hi. I'm just new with the automation features of .Net. I'm making a class library project that would generate a Solution with 3 class library project and a UI project (windows or web). I used the DTE2 and Solution2 objects to accomplish this. I am now in the process of adding the project references to each respective projects (Config Layer referenced to DAL, Config and Dal referenced in BL, Config and BL referenced to UI). The problem now is wh ...Show All

• SQL Server Debugging a script component task???

  How to debug a Script Component task For instance, I’ve got a Input0_ProcessInputRow procedure and I’d like to see what happen when compiler reach this line: dFecha = Left(Row.Column19, 4) & "-" & Mid(Row.Column19, 5, 2) & "-" & Right(Row.Column19, 2) I’ve put a toogle breakpoint there and then saved but when I run the package to ignore at all. This topic has been ...Show All

• Software Development for Windows Vista HandleExternalEvent Problem

  Sorry no response so I'm posting again. the senario is as such: - I have a generalized event for all workflows in my system say 'GeneralEvent' - inherited from this 'GeneralEvent' I have a child event say 'ForwardEvent' - in my workflow I define a HandleExternalEvent activity and set it to accept 'GeneralEvent' - from my application if I send a 'ForwardEvent' to this workflow I receive an unable to deliver exception FYI : I presume in the runt ...Show All

• Visual C++ Example C: Getting and Setting Certificates Properties

  I am trying to compile the example C program from the MSDN Library about: Getting and Setting Certificates Properties and it appears the next error: c:\archivos de programa\microsoft visual studio 8\vc\platform sdk\include\servprov.h(93) : error C2872: 'IServiceProvider' : ambiguous symbol could be 'c:\archivos de programa\microsoft visual studio 8\vc\platform sdk\include\servprov.h(48) : System::IServiceProvider IServiceProvider' ...Show All

• Windows Forms Viewing a word doc within a Windows Forms Application

  I would like to display a word document within my windows form application. Currently I am using the IE activeX control and passing it the word doc location. There must be a more elegant solution. Yes there is a lot of code I left out of the post...  I only posted the code relevent to obtaing the underlyi ...Show All

• Visual Studio Express Editions Error .exe is missing question

  I'm geting the error messege "Video Studio cannot start debugging because the debug target 'C:\\documents and settings\name\local setings\application data\temporary projects\ConsoleApplication1\bin\debug\consoleapplication1.exe is missing. Please build the project and retry or set the outpath and assembly name properties appropiately to point at the direct location for the target assembly." when i try to run a simple hello world progra ...Show All