Answer Questions

• WV John Semi-additive measures and date filters

  While testing against a very small cube, we've noticed that a query in the BIDS browser that uses a date filter with semi-additive measures (either LastNonEmpty or AverageofChildren) runs very slowly or never returns at all. When the same measures are used with the same date hierarchy as rows, the query response is very fast. Any other dimension can be used in the filter without this issue. The semi-additive measures work correctly in either case. We have the lastest hotfix ( 2153) applied to Enterprise Edition. Our customer browser applications shows the same behaviour as OWC in BIDS. Anyone have any ideas on why this doesn't work See the latest hotfix at http://forums.microsoft.com/MSDN/Sho ...Show All

• Matthew_D Windows integrated authentication - Domain controller

  If my SQL Server authentication is windows integrated authentication, whenever my application makes a connection to SQL server does it contact the windows active directory domain controller to authenticate the windows user account How does windows integrated authentication work in the background SQL Server will contact the DC to retrieve additional information about the Windows account. Thanks Laurentiu Hi Satya, The article was really informative. Just wanted to get my understanding validated. While using windows integrated authentication, SQL Server will contact domain controller which ever may be the authentication method, NTLM or Kerberos. My scenario is I will be connecting to my ...Show All

• AndersBank Report page size when printing

  I use SQL Server 2005 Reporting Services. The clients use Internet Explorer 6 or higher on Windows XP. When i access a report by ReportServer URL, the report viewer show me this report with my default parameters selected. If i choose "PDF" format and i click "Export", my report is perfect on printing. My problem is the button print of the ReportViewer page, if i click on it, the printed report is very too large (on two page). I presume that some settings are wrong in my report, the maximum width of the content never exceed 31 cm, i want the report in LandScape. There are my settings for this report : InteractiveSize : 11in; 8,5in Margins : 1,5cm; 1,5cm; 1,5cm; 1,5cm PageSize : 35cm; 25cm W ...Show All

• MeasleScar Show Monthly,Quarterly, and YTD revenue

  Hi All Experts, I need to show a result of a revenues total for Monthly,Quarterly, and YTD of a given sales person by a given period. e.g Period : 7-1-2006 to 8-1-2006 Sales Person Monthy Quarter YTD SalesPerson1 $1999 $10000 $100000 SalesPerson2 $1999 $10000 $100000 How can i do that Thanks in advance. It shouldn't be any worse than any other method. The calendar table is very small, so the join to it should not be very costly. Then it is just a matter of grouping. If you have too much data like this, then I would probably suggest going to an olap solution using Analysis Services, though I wouldn't know how to manually write that code in MDX :) hey i ...Show All

• Swapna.B. Vertical Database Design

  What kind of luck have you guys had with vertical database design I'm working with a front end developer who wishes to use a vertical design for Items and item attributes, as the client appears to have a firm requirement that new attributes can be added at any time. the developer has what I am begining to think of as "magic code" for importing the data into the tables. He's apparently going to write this in .NET, and plans for it to know the data type (varchar, etc.) when importing it - and also allow for the script to dynamically add attributes. THis sounds fun, however, the more stuff we get, the worse the database will perform, I'm thinking - only it will be exponentially slower than a conventional design. In addi ...Show All

• SomeGuyOnAComputer Suitable Administrators Guide

  Hello Our company will be rolling out a new business system in the near future. This will run on SQL Server 2005. I have prior experience of SQL 2000 and I'm looking to purchase some suitable literature to get me up to speed with 2005. I need something that will quickly show me best practices for implementation, backup and high availability etc. Can anyone suggest a suitable administrators companion I've had a quick look an Amazon and there seem to be plenty, but before I buy I'd like some advice from those in the field if possible. Many thanks in advance of your help and advice. Kind regards Danny There are a lot out there, as you mentioned. I've used the "pocket guides" in the pas ...Show All

• Behrooz PB ADOCE and SQL Mobile

  I have an old application running on Pocket PC 2003 which accesses a SQL CE database using ADOCE 3.1 Is there an easy way to upgrade to SQL Mobile Specifically, is there an OLEDB provider that I can install on the handheld whose connection string will work with ADOCE I have tried installing SQL Mobile and using this string (Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source = \Northwind2005.sdf) but ADOCE returns error saying it can't find provider. I know that there is a desktop dll, sqlceoledb30. Is there one for Pocket PC 2003 and can I use it for my purposes Thanks Ed Santosusso ...Show All

• Freddo Dynamic dimenssion security

  I am trying to pass the username to a vb function in the allowed members set of a dimenssion. For some reason it is not getting to the function. All of the other parameters are being received as I am logging them in the event log. Any ideas on why it looks like the username is not being picked up at all would be great. Thanks in advance. Chris Hi Michael, Thanks for the reply. I have since found the problem. It seems accoring to this article http://support.microsoft.com/kb/913667 that we needed to run sp1 and the hotfixes. It is now passing the correct username :) Chris Chris, I'm assuming you are using the UserName() function Can you post the MDX ex ...Show All

• Melissa H. SQL 2000 on Win2k3 Enterprise?

  I am attempting to install MS SQL 2000 SP2 on a Windows Server 2003 Enterprise SP1 box. The only installer I can find on the disc is in the MSDE directory and when I run it it immediately gives me this error: "This installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package." I have tried copying the install files to my local hard drive for install, I have checked the version of my Windows Installer (3.1.4000.1840). I have the SP4 updates ready to go once it's installed, but I just cannot get past that point. I know that the same software version has been installed on other Windows 2 ...Show All

• ashk1860 Inserting on Partitioned View

  Hello, I'm trying to insert on a partitioned view and I get this error: INSERT INTO dbo.TREP_NOVEDADES ( NMSEC_NOVEDAD, CDCONCEPTO, CDTIPO_VALOR, CDPRECIO, CDTIP_HECT_DTO_PAG, FEGENERACION, FEPAGO_COBRO, CDMETODO_DISTRIBUC, CDTIPO_DCTO_PAGO, VRDESCUENTO_PAGO, SNTERCERO, CDCLASE_NOVEDAD, CDENTIDAD, CDESTADO, CDCAUSA, NMSEC_PREFIJO, SNPAGO_CAJA, SNVAL_PROPOR_PESO, CDTIP_HECT_DISTRIB, CDMONEDA, CDCOMPANIA, NMSEC_NOVEDAD_PADR, SNGENERADA, POEMBARGO, CDTERCERO, CDCIA_TERCERO, NMSEM_GENERACION, NMANO_GENERACION, NMPER_GENERACION, NMSEM_PAGOC ...Show All

• edonoho Installting sqlserver 2005 on the client machine for windows application

  Hi I developed a windows application in Visual studio 2005 and the database is sqlexpress. I wanted my application to run on another system.For that i have installed sqlexpress 2005 on that machine.But that machine doesn't show me any enterprise manager or query manager for sqlserver. Is there any solution for this. Thanks SQL Server Express does not come with EM or Query Analyzer. These two components have been merged into the SQL Server Managment Studio. The SQL Server Management Studio Express (which actually is a stripped of SQL Server Managment Studio (aka SSMS)) can be downloaded separately from Microsoft or is already included in the Express Advanced Edition (which actually includes some other cool features like Reporting S ...Show All

• Dan Heile Getting a file name from Query Analyzer

  Hi all, im trying to write a stored procedure that will basically browse a folder and get me the first file that it sees. Is there any way that I can do this in TSQL or using CLR in C# I was thinking something along the lines of using the dos dir command and triyng to pipe it into a variable, not sure how to go about doing this. Any suggestions dir /b ...gives me the bare file names, but it lists all the files in the folder, any way that i can just get the first file ( i dont really care what file). This might help out: http://stevekass.com/blog/wp-content/Folders/sql/TextDriver.htm You can use TOP 1 to get just one file name. Steve Kass Drew University http://www.stevekass.com YoungEngineer@discussions.mic ...Show All

• Y-SW CTP version and release version

  we have a backup of a database from a release version with version number 9.00.1399 and we wanted to restore it to a server with version number (9.00.1116) CTP release. we were issued a version incopatibility message. is it possible to backup from a 9.00.1399 release with a backup file compatible for a CTP release, is there an available option during backup thanks! CTP versions are no longer supported. You should be using the released version of the product. Ideally, you should be at SP1, as we fixed quite a few bugs there. Backup is a physical operation. If the structure of the database pages has changed in any way, we have no way to do the conversion during restore. For moving up, we have the logic in the startup code to re ...Show All

• nils49 Move table from one filegroup to another?

  Hi guys, I'm in middle of database re-development as part of performance enhancement, I have re-group the tables to optimize query IO and created corresponding filegroups to house the data. Is there a way (or code) to move each table to their respective filegroups At the moment all the tables are on Primary filegroup. I have group the table into 6 section each to with the view to move each section into one of the 6 filegroups - each filegroup on different diskdrive I have looked at alter table command but can't find anything to allow me accoplished this task. Any ideas please thanks. Thanks for your suggestion Dave. i have actually gone this route by creating a new database, recreat ...Show All

• avalancheseah Unix shell Script and Macros are Available in SSIS ?

  Hi all , i am preaparing POC Document for SSIS and also compare with already created Job in Oracle Using Data Stage Server. The follwing List tasks are we can do in Data Stage Sever. " 1. Unix Shell scripts can be called before/after the job runs. 2. Programming can be done through: a. Routines b. Macros c. Subroutines d. Functions e. Expressions 3. Programming can be done in Mainframe jobs and COBOL code and JCL files can be generated. 4. The DataStage Reporting Tool is flexible and allows you to generate reports at various levels within a project, for example, entire job, single stage, set of stages, etc. " The above Task will we do in SSIS Pacakge or not pls any one give me the correct ...Show All