Answer Questions

• Randy VanDeMaat Disk Quorum Full

  Dear All, I've the quorum disk of my cluster on win2003 full and I cannot use The cluster administrator because the Service Cluster cannot going up. Obviously the shared disk (included Quorum) and MSDTC are not visible and I'm wondering if is possible to solve the problem without rebuild the cluster. Thank you to everybody Information thanks to Elden Christensen: You need to start ...Show All

• Timpany VBA IsError function in MDX with SQL Server 2005

  In SQL Server 2000 Analysis Services, we use the VBA IsError function to determine if a generated member name actually exists in the cube. See the following example... StrToMember ( Iif ( ISERROR ( StrToValue ( "[Start Date].[Month].[" + Format(Now(), "mmm yyyy" ) + "]" )), [Start Date].[Month]. Members . Item ([Start Date].[Month]. Members . Count -3). UniqueName , MemberToStr ( StrToMember ( "[Start Date].[Month].[" + Format( ...Show All

• Bayram0980 Unable to retrieve data from AdventureWoks

  Hi all, I have one question. It looks easy, but, I couldn't figure out the problem. I download and attach the AdventureWorksDB and AdventureWorksDW sample databases. I run the following query to test its functionality. use adventureworks go select * from production.location go and it gives me an error messeges which says: Msg 208, Level 16, State 1, Line 1 Invalid object name 'production.location'. Similar type of query is executed ...Show All

• d_harry45 Top Instruccion

  As I have tested the top instruccion doesn’t exist I sqlmobile isn’t it How I could load in my dataset for example the 20 next registers of the last register I have load in my dataset previusly Thank for your Help. Ok Darren thanks for your help You are correct - the TOP function is not supported in SQL Mobile. You will have to keep counters in your code a ...Show All

• sunshine2005 how to clean all messages of a queue ?

      How to clean all messages of a queue     Online books says it can be done as below:         RECEIVE * FROM ExpenseQueue      But it only delete a row every time,and I found all the three statement only delete a row:         RECEIVE * FROM ExpenseQueue          RECEIVE TOP(1) *&n ...Show All

• willajo can i directly use a variable on this?

  on the PARAMETER SOURCE box (figure 1), can i use a variable and not a particular control what i tried is i put the variable into a control and select CONTROL on the PARAMETER SOURCE. that works but i guess there's a way i can directly access the variable using this wizard. pls tell me. thanks figure1 >> www.geocities.com/fbi_file01/figure1.jpg ...Show All

• Arjuna_M Changing Column size/type with Derived Column

  I have a number of date columns that are parsed as DT_WSTR (6) and I have written a Derived Column converting them into DT_DATE via this (found on the forums) type expression: (DT_DATE)(SUBSTRING(Date,6,2) + "-" + SUBSTRING(Date,8,2) + "-" + SUBSTRING(Date,1,5)) But I really want to replace the current column, not create a new one. If I use "replace" the data is forced to be a DT_WSTR (6), and I get a truncation error at run-time. Simeon ...Show All

• Kannan.Perumal Need help with XSLT - control characters not working

  I am writing an XSLT that will format events for HTML email distribution. One of the event data properties is defined as nvarchar(max). This column contains text formatted with CRs. I need to replace the CRs with <br/> for HTML email. I use the following snippet. <xsl:template match="notification"> <p> <xsl:call-template name="line-breaks"> <xsl:with-param name="text" select=" ...Show All

• Monkan Random Expressions

  In my data flow task I have written a script component source that generates rows with random column values. It works well, but is there another simpler way of solving this First I thought of a solution using derived columns, but there is no support for random functions in the expression builder in the derived column transformation editor. So, question #2... Why doen't the expression builder support random functionality Thanks for all replies! ...Show All

• Aaron Skonnard Internet explorer script error

  When trying to configure task scheduler on my mcafee virus scan i get the error notice: keyset does not exist The specific error is 0x80090016 It also says General page initialisation failed. An error has occurred attempting to retrieve task account onfo. You may continue editing task object but will be unable to change task account info. Does anyone have a solution so I can schedule automatic updates for my virus scanner ...Show All

• Girts Kra Notiification Services Tutorial

  Can any one provide me with Tutorials for beginners http://msdn2.microsoft.com/en-us/library/ms172483.aspx Hope, it helps SSNS comes with a pretty good walkthrough in BOL. I'd start there if I were you. ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/bcbd3083-ac41-44ce-a1b1-aa779c102c89.htm Also, both Shyam's book and my book step the reader through developing instances/applications in a bit more detail than BOL. HT ...Show All

• AMMPCP Foreach + XML Task = System.OutOfMemoryException

  I have a Foreach container looping through a list of xml files. Inside the foreach there is an XML task that uses and XSLT to write an output file. If I run my process on an individual xml file, it works fine. Once I introduce the foreach the process fails on the second file with a System.OutOfMemoryException. The XML files are anywhere between 20MB and 150MB, but again, individually it appears able to process fine, only in the context of the fo ...Show All

• hanadyt42 Building Intelligent applications using SQL Server 2005 Data Mining

  Hello, Are there any samples on Building Intelligent applications using SQL Server 2005 Data Mining uisng Visual Basic.NET, including step-by-step guides   Most of them are in C#.  Besides, the June 2005 CTP does not have tutorials on the said topic. Thanks. We don't have sample code specifically in VB.NET but the object models are exactly the same in all .NET languages so the code should be readily portable. If you encounte ...Show All

• Batool 2005 CTP Connection error

  When I try to connect to the 2005 CTP SQL server in any of the VBexpress software packages I get the gfollowing error user instance login flag not supported in this version of SQL I am not sure what to check or what I may have missed in the SQL server setup   All versions(SKUs) are part of CTP. But if you are convinced that you are not connecting to express then this is the problem you need to remove the U ...Show All

• tianyuan MSSQLService (MSDE) Not Re-Configured correctly

  Hi all, I have a question regarding restarting MS SQL Service under a different user, in other words, re-starting MSSQLService as a "Log on as" user instead of "Local System" account. By default MSSQLService starts as a local system account. Now my problem is, that I install MSDE 2000 for my application. And I install it as a seperate instance with name "MyInstance". So after Install my service is called MSSQL$MyInstance. so my process basicall ...Show All