Answer Questions

• Namshub performance and tunning

  hi. i have a new question.. how can i make my cube browsing faster since i processed like a million of records into my fact table.. browsing the cube has become really really slow... is there anything i can do to avoid this delay Mosha Pasumansky wrote: I don't know what logical processor is. Do you refer to hyperthreading Yes, I have 2 dual core Intel Xeon 2.66GHz Hyperthreaded Philippe Dear All, I'm having a problem with performance in SSAS 2005. This is the server specification: OLAP Server and ORACLE Data Warehouse Server (64 bit) : IBM xSeries 460, windows 2003 EE x64 SP1, SQL Server Analysis Services 2005 x64 SP1 + Hotfix, , ORACLE 10g R2, 8x Xeon 3 GHz, memo ...Show All

• IceAngel89 How to create a DTS package in 2005

  I am 100% new to SQL. I have used Access for ever. I need to know how to take a Access 2003 database and covert it over to SQL 2005. I have no idea how to complete this. I was told to do a DTS package but I do not see any options for this. Any help would be great! Thank you Thank you! :-) hi,      DTS is now known as SSIS pacakage      you can create a new database in sql management studio      after creating a new database. you can right click the database      and then  click on task. then clcik import data.       choose microsoft acce ...Show All

• Josh Kinder Adding Externall DLL functions written in Visual C++

  Hi,  I'm trying to add exernal functions defined by a third party in a dll. They developed the dll in Visual C++ and is provided as is, with very little additional info about the code.  The dll is tested and can be integrated into an application developed with VB.NET but no other experiences are available. I tried to add the functions to SQL Server 2005 Express edition but on attempting to CREATE the ASSEMBLY i get the following error: CREATE ASSEMBLY for assembly 'ThirdPartyDll' failed because assembly 'ThirdPartyDll' is malformed or not a pure .NET assembly. Unverifiable PE Header/native stub. No rows affected. (0 row(s) returned) @RETURN_VALUE = -6 Finished running [dbo].[ThirdPartyDl ...Show All

• ShivaanKeldon LEVEL_TYPE set to 0 in Levels Rowset

  When calling GetSchemaDataSet to return level information for a cube, the LEVEL_TYPE column returns 0 for some columns. Using Adventure Works. the [Date].[Calendar].[Calendar Year] level will have a level type of 20 however the [Date].[Fiscal].[Fiscal Year] level will have a level type of 0. Is there any way around this Thanks We are trying to provide a generic solution that automatically creates a Prev Year, Prev Month etc calculated measure for a user. So we are trying to cater for all cases and grab the correct level. Looks like it will work fine as long as the cubes are setup as you say, otherwise we may have to either bail out or trying matching the level caption. Thanks ...Show All

• S. Brennan My Query is broken and I don't know how to fix it...

  I am trying to set up a filtered paging ObjectDataSource for a gridvoew control. My code works, my query doesn't... This is OK: Get all rows of data: "SELECT UCO, country_code, country_name, enabled, concurrency FROM CountryCodes " Returns all records as expected This is OK: Getting rows of data with no Filter: "SELECT UCO, country_code, country_name, enabled, concurrency FROM (SELECT ROW_NUMBER() OVER (ORDER BY country_name ) As Row, UCO, country_code, country_name, enabled, concurrency FROM CountryCodes ) As TempRowTable WHERE Row >= 0 AND Row <= 10" Returns expected data This is OK: Making sure my WHERE filter works: "SELECT UCO, country_code, country_name, enabled, concurrency FROM CountryCode ...Show All

• ToN.x How to check whether an SSIS package is executing

  I have scheduled an SQL Job to run every 15 mins. This runs an SSIS package. But sometimes my package might execute for more than 15 mins. In this case, a second instance of the package would start. I don't want this to happen. So is there any way I can check whether the package is already running before I continue the execution of the same. Right now I am using a mutex to handle this problem. Are there any problems using the mutex and is there a better way to handle this Thanks in advance. Sumesh Hi Sumesh, I think you could use a scripting task and SMO to extract the current run status of the job: http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.agent.job.currentr ...Show All

• cuetumayu Turn Off ViewState Safe?

  Hi, Would turning off ViewState in Report Manager be safe Or at least is there a way to deactivate ViewState for viewing reports in Report Manager instead of all pages in the web site I'm not sure of the impact of deactivating this with the internals of the web application. I appreciate any help regarding this. Thanks. ViewState is turned on by default and could be turned off by changing the web.config file under ReportManager directory. < system.web > < pages validateRequest = " false " enableViewState = " false " /> However, since reportviewer control requires that ViewState be enabled, this won't do any good since user won't be able to view any reports from there wi ...Show All

• Aleniko29139 Database table

  Goodday. I have set up my database table with one columbe as data type set to Nvarchar (max) How many charectors will this allow me , and is there a seting where I can get the most charectors. And while I,m here , I,v noticed a data type called image. How do I get my image onto the form. When I drage my gridveiw onto the form , the image block does not come. Thanks in advance Rob HI Rob, Adding to what earlier said in thread i suggest to read a very Research made at MS for BLOB, and it is suggested not to store such images/docs in database but to store the path of it and handle its operation with front end tool http://research.microsoft.com/research/pubs/view.aspx msr_tr_id=MSR-TR-2006-45 Hemantgiri S. Go ...Show All

• Salman Maredia Can't uninstall or reinstall SQL Server 2005 Dev

  Long story short: Installed SQL Server 2005 Developers Edition along with Visual Studio 2005. Everything worked as it should. Then there was a problem installing .NET Framework 2.0 Security Update. Fixed that by uninstall and reinstall of .NET Framework 2.0. Now SQL Server does not work. So I figured uninstall/reinstall. Only problem is that it WILL NOT uninstall. I have tried to uninstall manually per KB article (9009967). That doesn't work either. The error info that I'm geting is: LinkID: 20476 Product Name: Microsoft SQL Server Product Version: 9.00.2047.00 Message source: setup.rll Message ID: 50000 EvtType: stateengine\resourcemodule.cpp@ScheduleActionAction@sqls::ResourceModule::LoadStringW@0x716 I ...Show All

• dsfffffffffffffffffffffffff Bug?

  When I have two connection managers in the DFT and OLEDB source and destination component. Associating the different conneciton managers to source and destination seem to go through fine with the code below, but the package generated does not have the connection manager associated with the destination. I get this error on the destionation on opening up the package in the designer. <Error> A connection Manager has not been assigned to the runtime connection (24) </Error> SourceOrDestinationComponent.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert .ToConnectionManager90(pkg.Connections[ConnMgrName]); However when I assign the ID using the code below it seem to work fine. The documentation do ...Show All

• nick5454 How to handle End User Custum Fields?

  I am writing an inventory / asset tracking application, backed by MSSQL 2005 and need to allow end users to add/remove custom fields to track. What is the best way to go about this I thought about modifying the table structure at run time, but quickly decided that was a terrible idea. How does say, Share Point Services track custom columns Thanks Joe You could modify the table structure, but I wouldn't encourage that particularly if different users can have different custom fields. There are two basic ways to do this. The first way is basic brute force by "supporting" n custom columns. You then have a table with n columns that are generally large varchar datatypes and a second table that c ...Show All

• Liran Russo Have a bet .... curious on input :)

  So I have a person who is adamant in tell me that SQL Server does not run on windows XP. Now, I have already done all the research on this (i.e. sql server 2000 product page / requirements) and know the answer, but they insist on asking the question, so here it is ..... 'Will SQL Server run on Windows XP' A simple YES or NO will suffice; however, if you want to explain the answer (if it requires one ;) ), please feel free. YES and NO . Depends on what version of SQL Server you want to install. MSDE/SQL Server Express work. Also is the Developer Edition of SQL Server. But with the Enterprise Edition I think you're out of luck... it won't install. Mike' ...Show All

• Edmaneiro Replace vb.asp with XML

  Sorry, I've been stuck in a SQL Server 2000 and vb6.asp world and a bit isolated. My app is web based. It's 99.9% Transact-SQL creating HTML output and .1% vb.asp. My VP.asp does two things: 1. Calls a stored proc and does a response.write. 2. On submit it captures form field values and calls a proc with the parameters and values. That's it. My question is can I replace vb.asp using native SQL Server XML My big question is the capture part. Security and firewall updates keep killing my vb.asp development environment and no support for vb6. Best Regards Mark The XML support per se in SQL Server 2005 does not. But you could either expose the functionality as a HTTP/SOAP webservice or use ADO.Net on t ...Show All

• mario.muja config page.header style in css

  Which tag should i add to config the page.header style in the css file ...Show All

• Ronald Schilf need help from MSFT guys

  Hi, I am creating a pie chart report from a cube . This report may contain unknown number of segments. Here is the thing; if more than 1 data slice is generated with a value less than 5% of the total, then a segment labelled 'other' will be generated, and data from all slices with value < 5% will be added to this 'Other' segment. Is it possible to implement this functionality in the report layout level with out writing a complex MDX query If this is not possible, can you give me a sample MDX query which implements similar issue(i.e. 'Other-ing' rule.) For your information, this feature can be easily implemented using a third pary software such as 'Dundas chart for Reporting Service'. However, my client don't want to buy this ...Show All