Answer Questions

• Adhamz Will Work for Help SQL 2k5 SP1 Installation issue (log attached)

  The upgrade to SQL 2k5 SP1 fails to upgraede the Database Services. Attached is the log. Will work for help. 05/24/2006 16:19:47.500 ================================================================================ 05/24/2006 16:19:47.500 Hotfix package launched 05/24/2006 16:19:53.687 Product discovery successfully completed during the install process for MSSQLSERVER 05/24/2006 16:19:53.687 SP Level check successfully completed during the ...Show All

• John Ericson174499 Session MDX scripts and assignments

  In SSAS 2005 if a MDX script is saved in the default cube script it is possible to assign values to a specified set: SCOPE <set>; THIS = desired value; END SCOPE; In order to add/remove this assignment programmatically the script has to be injected in a cube using AMO. The assigments applied are visible to every user browsing the cube. I'm trying to obtain similar results using a session and ADOMD.NET. I would not like to update server ...Show All

• SW Skeen BCPing results from sproc that uses temp tables

  I create the following stored procedure: USE Northwind GO CREATE PROCEDURE mgr_Proc AS SET NOCOUNT ON SELECT * INTO #Temp1 FROM Northwind.dbo.Region SELECT * FROM #Temp1 DROP TABLE #Temp1 SET NOCOUNT OFF GO If I run the stored procedure in Query Analyzer with: EXEC mgr_Proc it works fine.  However if I try to use BCP to get the same results: bcp "EXEC Northwind.dbo.mgr_Proc" queryout C:\Test.txt -w -Sserver10 -T -t\t I get a ...Show All

• abbarron using EXEC to execute a formula stored in a string

  Hopefully someone will have run into this before...  Basically, I have a table with a column that stores mathematical formulas in string format.  When my UDF is executed, it needs to select an appropriate formula from this table and evaluate it using values that are stored in local variables.  Look at the example below: Suppose I have a string named @vcFormula that contains the following: "@dVar1 + @dVar2 / @dVar2" ...Show All

• easot Restricting Access to Management Folder under SQL Server 2000

  Hi I have a SQL Server 2000 Server with several Databases owned by different users. Currently all DBO’s seem to be able to access the Management Folder and this is not ideal as they can create all sorts of tasks which can affect server performance. Is there any way to restrict Access to the Management Folder so only the SA can access it. Thanks G, Hi Thank you for your reply. I would still l ...Show All

• Colin Desmond Implementing message queue in SQL Server 2000

  I am implementing a message queue system in SQL Server 2000. My queue table looks something like this: [MessageId] [uniqueidentifier] NOT NULL, [MessageType] [uniqueidentifier] NOT NULL, [Status] [tinyint] NOT NULL, [SubmittedTime] [datetime] NOT NULL, [StartTime] [datetime] NOT NULL, [DispatchedTime] [datetime] NULL, [CompletedTime] [datetime] NULL, [MessageData] [image] NULL This is how I retrieve the next message for processing: SELE ...Show All

• cmccoll_MS how to access a cube and its dimensions in a cube

  Imports Microsoft.AnalysisServices.AdomdClient Imports System.Data Imports Microsoft.AnalysisServices.AdomdClient.Dimension Imports Microsoft.AnalysisServices.AdomdClient.CubeDef Imports System.Object Imports System.Diagnostics.Debug Imports System.Data.OleDb Partial Class _Default Inherits System.Web.UI.Page Public Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Bu ...Show All

• kthiagar Problem migrating NonEmptyCrossJoin query to AS2005

  Hi, In AS2000 we were using following query as a basis for product report: select {[Measures].[Stock], [Measures].[Sales Qty YTD], [Measures].[Sales Qty LW]} on columns, NonEmptyCrossJoin([Hierarchy].[Sub Category].Members, [SKU].[SKU Name].Members, [Supplier].[Short Name].Members) on rows from eSalesActStock where [DOp Calendar].[OpYear].[2006].[08.February].[Week 32] It was used to show all products either on stock, or sold this year or both. ...Show All

• popsdawg Metadata driven SSIS

    I am looking for some pointers on Metadata driven SSIS.   Specifically, how to automate creation of a large number of packages in SSIS using metadata.   I am looking at this as a solution to deploy multiple packages on multiple servers. Any other ideas on this would be highly appreciated.   Thanks   Vishal Verma While I cannot confirm Suresh is correct (and in fact this ...Show All

• Rosalba Embedding literals in RDL that will come through in HTML

  I am trying to create some reports that when rendered in HTML are supposed to have some interactivity built into them.  I understand that there aren't any facilities in RDL itself that would help facilitate this process for me, but is there any way to embed some literal strings that will come through in the HTML The items I'm trying to finesse through are <script> blocks, checkboxes, and <object> tags.  When I use the desi ...Show All

• michhes Visibility of a matrix column base on parameter selection

  Hi, I have a matrix, with 1 row group and 1 column group and 4 static columns, is there a way to hide the static columns base on the selection of a multi-value parameter Like creating a group for the 4 static columns Is that possible This is an urgent matter, any help would be very much appreciated. Thanks, Cheng Hi Robert, Thanks for your reply. I've tried to add the dummy dynamic group, ...Show All

• francois974 Maintenance plan job unable to send Mail Alert

  Our configuration : SQL Server 2005 June CTP Enterprise Edition version : 9.00.1187.07 OS : Windows 2003   The Problem: After configuring Database Mail account and profile, maintenance plan or job generated with the maintenance plan Wizard is unable to send mail.   The SQL Agent error log contains those messages pointing on a bad profile name.   Error Messages [264] An attempt was made to send an email when no email session has be ...Show All

• AdrianMorris Separate date and time datatypes - come on guys!

  Oh for crying out loud, how come there aren't separate date and time datatypes in SQL 2005!   I know for a fact that this feature has been requested for YEARS!!!!  Thanks for giving me the YAGNI feature of renaming my menu items in SQL Management Studio.  I guess that was somehow a higher priority than a time datatype. WOW - I was pretty sure I wasn't the only one which wanted ...Show All

• Jaxom The post titled "SQL Server and RMS Data Access" was moved to Database Engine

  This post was moved to more appropriate forum. ...Show All

• Americo Table Headers Not Repeating on Each New Page

  I want the table header to repeat on each new page. So I set the RepeatOnNewPage property of the table header to true and it seems to work in my dev environment. When I roll it out to our test environment, the table header repeats on the 2nd page, but not on the 3rd page, which happens to be the last page. It's the same exact RDL in the two environments, but the dev SSRS seems to do what I want, but the test SSRS does not. What gives Is ther ...Show All