Answer Questions

• Karaner BATCH Update ?

  Hi all, we need to update many single cells with individual MDX Update Statements. We're doing this with ADOMD now (C# Project) in a loop. In order to save roundtrips and put things in one transaction we considered using the <Batch> Element of XMLA. I could'nt find a example how to use this with MDX Commands. this doesnt work: <Batch> <Command> <Statement> UPDATE .. </Statement> </Command> <Command ...Show All

• IAOCHISON Manipulating and deploying report models

  All, we are reviewing the ad hoc report builder in SSRS 2005. This could be a big boon to our clients. But we have to be able to do some things first. First of all when we define our datasource view we need to be able to "filter" the available data in the view prior to being "delivered" to the report builder app the client gets to manipulate. We don't currently see a way to do this. But I'm working on it. I'm thinking we m ...Show All

• Asvin Ananthanarayan How to edit a custom property on an external metadata column

  I am using external metadata columns in a destination data component to match sharepoint fields to input columns.  I want to add a flag that the user can set to specify if a column is a lookup column (indicates that the component should look for a list item with the specified input column value, and do an update if the item already exists).  I added a custom boolean property to the medata column, but the property editor does not a ...Show All

• Trev How to define a group of dimensions

  Hi All, I have a task to reorganize database schema in AS2K5 , that looks like "multi-value dimesions" model in datawarehouse. Pls see the following example: before reorganize schema: There are 2 tables (Dim and Fact) with n-n relational relationship. Dim <--- DimFactBridge----> Fact after reorganize schema : Dim <---DimGroupBridge---->Dimgroup <-----Fact purpose to reorganize schema : save space for ...Show All

• vanWeyden Intermittent Failure of Interdatabase Service with SP-1 CTP

  In an SSB test project created from the T-SQL batch in Stuart Padley's Weblog (subtitled "SQL Server 2005 stuff I couldn't find anywhere else", http://blogs.msdn.com/stuartpa/archive/2005/07/25/443229.aspx ) I found strange inconsistencies with enquing messages between two databases on the same SQL Server 2005 Standard Edition SP-1 CTP March instance running under Windows Server 2003 SE SP-1: Sending a simple message from the In ...Show All

• Ben Chess horizontal ordering of column names

  Hi friends, When  I write: select * from table_name Is it possible to order the column names in alphabetical order in Sql Server (I don't want to order the values in columns, i want to order the column names in the select list.) with regards, Hello. I must admit that I can't really see good uses for this, but since it is something I have never done in SQL, it is fun. So I did it. There shoud be easier ways of doing it, but this wor ...Show All

• lcc.manuel The REAL Warehouse Sample V6 database

  Regarding the code/db from the REAL project that just got released, I have no problem attaching the "REAL Sample V6" database, but the "REAL Warehouse Sample V6" database requires ENTERPRISE edition, because the default copy uses Partitioning (i.e. the PT version, although the document stated that the multi-table (MT) version is the default). I only have the STANDARD edition of SQL 2005, is there a workaround Appreciate an ...Show All

• jsndgrss Import all xml-Files from a Folder into SQL

  Hello I'm just starting with SQL and BIDS. I have created a xml-Import to SQL Server which works without any problem. Now I like to import (daily) all xml-files of an appropriate Folder at once to the DB. The files will have different names each day. I could not find any help in the internet to solve this problem. Can someone give me an Idea how to import many xml-files out of the same folder to SQL Thanks & regards Chaepp ...Show All

• Olcay Reference Dimension causing long processing times

  I have a reference dimension that is linked to a regular dimension that is linked to the fact table. For some reason, when I process the database with some small sample data, it take about 5 minutes to process, where it should take 10 seconds. I am using a reference dimension because it is a child-parent hierarchy, and I don't think I can merge it into the regular dimension. My work-around is to just include the link to this reference dimension ...Show All

• Gabe J Exporting SQL Maintenance Plans

  I have taken a look at the new maintenance plan designer and have come up with a maintenance plan I would like to be able to deploy on an enterprise level.  Anyone know of a way I can export the plan to another SQL 2005 server - without directly pulling from the msdb system tables   I like the fact that you can script the output of most of the wizards, but the maintenance plan wizard does not appear to be one of them. Thanks, Matt ...Show All

• jimh12345 intallation of "MSSQL 2000 virtual server" on Windows Server2003

  Hello, i am trying to install mssql 2000 virtual server for failover clustering on windows server 2003. i have downloaded the evalution edition for mssql 2000. "the problem i am facing during installation that when i start installation, the virtual server option is disabled for computer name (on what computer mssql server is to install, as i want to install it on virtual ip)." could you someone help in this matter, "h ...Show All

• Darshana "Could not find schema information ..." error in XSD annotation

  When I open any annotated schema in VC# 2005 Express, I get the error: "Could not find schema information for the attribute 'urn:schemas-microsoft-com:mapping-schema:relation'." Am I missing a reference   MSXML4.0 and the SQL Client are installed on my workstation. An example of one of the annotated schemas I've tried is this one, from Andrew Conrad's MSDN article "A Survey of Microsoft SQL Server 2000 XML Features": < ...Show All

• Wakko2k SQL RS Custom Authentication and WSS

  Hi, I am trying to implement custom authentication as per the instructions in the following documents: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql2k/html/ufairs.asp http://www.devx.com/dotnet/Article/27133 But, I was able to make it work without Windows Sharepoint Services(WSS) but not with it. I was wondering that has anyone tried to extend the security of RS and make it work with WSS installed on the same machin ...Show All

• Rolf700 How can i secure my MDF file?

  If a user is a local admin of the box they can gain full access to the database via integrated security. They can create their own database and attach .MDF How can i secure the .MDF so that no one can gain access to it hi, you can distribute the backup file(Password protected) of that database, and then restore using query. you can programticaly restore the database using OSQL EXE available in tools folder of microsoft sql server ...Show All

• CARR215 IIS required for SQL Express Adv

  I'm trying to install SQL Express Adv and it warns me I need IIS to support certain features for Reports. Despite hours of searching through the MS website, I can not figure out what features those are to determine if I want put in IIS. Furthermore, I can not even figure out how to get IIS on my system. I need to do this for my laptop, which is XP Pro 2002 SP2. I also need to do this for my desktop, which is XP Home 2002 SP2. Neither of them ha ...Show All