Answer Questions

• Ryan Garaygay Calculating number of subscriptions in time

  Hi all, I'm new to SQL AS and MDX in general but I'm trying to build the following and maybe you guys can help me. I have a snowflake database with a table containing subscription. Each subscription has a date/time at which it starts and a date/time at which it is terminated: subscription: id start_date end_date .... 100 10-jul-2005 17:00 10-aug-2005 11:00 ... 101 11-jun-2005 17:00 12-dec-2006 18:00 ... 102 1-may-2005 17:00 17-jan-2007 13:00 ... 103 10-apr-2005 17:00 10-sep-2005 15:00 ... And there is a dimension-table called datetime: id year month .... 10-jul-2005 17:00 2005 06 ... 10-jul-2005 18:00 ...Show All

• Lesego SQL 2005 Encryption - Symmetric Keys

  I have a question about the storage of symmetric keys in SQL Server 2005 due to the fact that I have read two conflicting statements on this. In Laurentiu's blog located at http://blogs.msdn.com/lcris/archive/2005/10/14/481434.aspx , in regards to preventing symmetric key loss he makes the statement that "...Because the keys are stored in the database, they will be saved with the database....". But in the white paper Improving Data Security by Using SQL Server 2005 , which is located at http://www.microsoft.com/technet/itshowcase/content/sqldatsec.mspx , in regards to symmetric keys the statement is made "... Note: The symmetric key is not stored in the database. Only the encrypted values of the symmetric key are stor ...Show All

• billy_bhuj MSDE & SQL Express use?

  I know this may have been asked in the past, and I've tried to search the forum, but didn't find any clear responses. The question is about MSDE and SQL Express being "Free". Can MSDE or SQL Server express be used for the backend DB for an application for a private (for profit) company A COTS that we are planning to puchase can work with either commercial version of SQL server or MSDE / Express. Any input would be appreciated. Thank you, Hi, I don’t know what COTS means, but they are both free for use. You can use them within your applications. There are limitations on the free versions which you might encounter in the future. But its quite easy to "migrate" from the free ve ...Show All

• llorrac Can't install SQL Express

  It fails because it can't find sqlncli.msi. I looked in the temp directory and it was there Log excerpt: User policy value 'SearchOrder' is 'nmu' MSI (s) (B4:A4) [20:53:04:843]: User policy value 'DisableMedia' is 0 MSI (s) (B4:A4) [20:53:04:843]: Machine policy value 'AllowLockdownMedia' is 0 MSI (s) (B4:A4) [20:53:04:843]: SOURCEMGMT: Media enabled only if package is safe. MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Looking for sourcelist for product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E} MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Adding {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}; to potential sourcelist list (pcode;disk;relpath). MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Now checking product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E} MSI (s ...Show All

• koad changing "header rows to skip" property in flat file connection during runtime

  Hi all I have a flat file.I am trying to set the value for the property " HeaderRowsToSkip " during runtime.I have set an expression for this in my "flat file connection manager". But this is not working.The connection manager is not able to take the value during runtime . My expression is as follows: DataRowsToSkip : @[user:: Var] where " Var " is my variable which gets the value from the rowcount component and trying to set it back to the "HeaderRowsToskip" property. I ve even tried setting the value to the " HeaderRowsToSkip " property in the expression builder. Its not working.... Can anyone help me out in solving this Thanks in advance Regards Suganya ...Show All

• jomunoz Problem extracting data from multiple list boxes

  I have a report that has a header section with three detail sections.  The header section contains information pertinent to a person and a situation.  The detail sections each contain information pertinent to the situation and person in the header section.  I have been able to format the data correctly but I am unable to have the unique information per person extracted for the three detail section.  I am using data from four stored procedures, one for the header information and three for each detail section.  sample detail data: sit1desc                        date     &n ...Show All

• Josue Perez Mix and Match Rows

  In the trading (stock market) industry there is a practice of rolling up (merging) multiple trades into a single trade in an effort to save on ticket charges. The way this is done is performing a SUM() on the quantities and calculating an average price. (Average price is the SUM(Qty * Price) / SUM(Qty). So, given : Qty     Price 20      $5 20      $10 You get: 40      $7.5           -- 20 + 20 and SUM(20 * $5, 20 * $10) / SUM(20 + 20) Here is my dilema: If given a set of trades, I need to loop through them and check every combination to determine which one matches the expected ...Show All

• Mike Brown How to recover from mdf file (SQL Server 2000)

  Hi, My database corrupted because when I was running an update query, there is a power failure. After the computer booted, I cannot open the database anymore, it just not responding. Then I stop the sql server service, and tried to rename the .mdf and .ldf. After that it worked normally, but I need the data from the corrupted mdf file, I tried to attach the database but it just hanged. I even tried to attach without the .ldf file but it didn't work either, so I concluded that the problem is with the mdf file. Is there any way to recover my data Thanks in advance Regards, Edwin Can you rename the mdf,ldf files to their original names and attach them to your SQL Server (with all SQL Servic ...Show All

• DaniMaia Installing Client Tools

  I recently installed an evaluation copy of SQL Server (Enterprise x64 edition). What's the proper way to load the management and analytical tools onto client machines There are 2 separate problems: 1. The 64 bit program only comes with 64 bit tools. (Should I just download the 32 bit evaluation copy Will the tools expire in 180 days on all the client machines ) 2. What are the licensing rules Surely I am allowed to load client tools (but not the server itself) onto client devices. Is that right Thanks! Refer to this http://support.microsoft.com/kb/257716 page that clears about licensing policy on client tools, though it is for SQL 2000 all the information is still applicable to SQL 2005 in this case. I ...Show All

• project2n5e0o1 Format Text?????

  If I have a paragraph of text in a text box, but I only want to bold a couple words...how do I do that Unfortunately this is not currently supported directly. You can cobble together multiple textboxes, or try an external solution like OfficeWriter. ...Show All

• ratslav change data format in stored procedure

  Hi All, My scenario is that I want to change the default SQL server format in my stored procedure more preferably only during the course of stored procedure execution (not permanent changes does any one have idea that how will I able to achieve this simple task... regards, Anas You can use the CONVERT function for this. As a common approach Date formatting should be done on the client and only on the server if you have no client application or the client application does not support it. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Abhishek_SE report viewer and reporting services security

  i have a web application in studio 2005 using the report viewer control. i have my own security model implemented on my web pages for clients [1..n] each of the [1..n] clients should be able to view reports of their order history. i have the report viewer set up in url mode. the question is that when i have drill downs in my final reports, a user with some tech knowledge, would be able to obtain the url to my sql server running reporting services. the sql server will not be given a port 80 acess. how do i go about displaying reports without any savvy user being able to locate the server locations/credentials i donot want to create windows account for each [1..n] clients as this is ever growing ...Show All

• JoshNewbury kiran

  I don't get the code of sqldatareader for connection with datagrid Coudl you explain this in more details HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- True, that helps and fyi http://www.datadirect.com/developer/net/sqlserver_code/index.ssp ...Show All

• MarketMaker Calculated Measure will not deploy

  I have a calculated measure which simply tries to generate a Margin Percentage. This is very simply one Measure divided by another. The problem is that when I try to deploy this measure with a Parent Hierarchy of measures it will not deploy I get the error Errors and Warnings from Response MdxScript(OPWDW) (7, 8) The 'Measures' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified. Strangly I have managed to get it to deploy once but then the build fails with the same error. I am not sure why this happens as I have done nothing different from what I would normally do and the Measures dimension does only have one hierarchy. Found the answer Change ...Show All

• Naolin "Open Table" NOT WORKING. Can someone HELP!

  In my instance of "sql server 2005" I right click on a table and select "Open Table" then I get the error message "Object reference not set to..." Then has been happening since I installed I have tryed searching groups and posting to get a solution. I have load the adventure works data base and get the same error when performing "open table". Can someone from MS please respond. Also if Open Table works can you edit the data directly in the results pane Have you tried to attempt from another client's machine against this server Also test and try using SP2 on SQL 2005, if it is not a SQL 2005 instance then make sure to have latest service pack on SQL 2000 too. ...Show All