Answer Questions

• Rahul Singla Dynamic Column Name - Hard Problem...

  Ok, here is my problem, lets say i have the following three tables Product_Group_Master ProductGroupId Size_Groups SizeGroupCode SizeCode1 SizeCode2 SizeCode3 SizeCode4 SizeCode5 Product_Group_Inventory ProductGroupId Inventory1 Inventory2 Inventory3 Inventory4 Inventory5 Individuale_Products ProductId ProductGroupId SizeGroupCode SizeCode Ok, now that you understant the table layout... i need get a list of ProductId's with there respective inventory count So what i need to do is select all the product id's from the "Individuale_Products" table, and the based apon there "SizeGroupCode", and "SizeCode"... I need to look up in the "Size_Groups" table... on the row that ...Show All

• Kai123 Best Practice for detecting Feature Pack components?

  I'm responsible for the install of an application whose next version will be using the 2005 SMO objects. I've already located the feature pack page and discovered what MSI's need to be installed. What we would like to do is in the install of our application, detect if the required 3 modules have been installed yet, so that we can prevent our install from continuning if any are not present. Does Microsoft have any preferred way to accomplish this I know how to use the Windows Installer Engine objets to querey on various properties. In fact I do this for one of our installs where I querey for related products based on the UpgradeCode, then use the resulting ProductCodes on the ProductInfo method to get the VersionString. Can I do a si ...Show All

• Bagles1 Performance of Encryption algorithms

  I am in the stage of design for an application that uses SQL server 2005. We intended to encrypt some sensitve data using the encryption features in SQL server 2005. we will use symmetric key encryption. The question here is which symmetric encryption algorithm has the best performance how much does the key size affect the perfromance the data to be encrypted will be some lines of text equal to a word document. any ideas Hi Muhammad, We don't have explicit numbers for the performance of different algorithms/key lengths yet but from what we have seen there is no significant difference. The biggest performance impact is how the data is stored (i.e. storing encrypted data across very many rows in lots of columns and then selecting ...Show All

• Daniel Segerdahl conditional display

  To simplify, I have a report with sections A,B, and C. Section A is always displayed. Section B is only displayed when the subject is Male. Section C is only displayed when the subject is Female. I want section B or C to directly follow section A. I have been using the hidden property to do this, but it is hard to maintain the report as I have placed these two sections on top of each other on the Layout tab. Is there a way to make either section B or C directly follow section A without having them overlap in the Layout tab The sections contain data pertinent only to Males or Females. I have considered making separate reports, but the gender sections only make up about 10% of the report. Because of this I ...Show All

• Vish_All No of Aggregations Vs % of Performance gain

  Hi, For performance optimizing my cubes, I used the aggregation design wizard to create aggregations. The only thing that I am not able to understand is: The number of aggregations and the percentage of performance gain (as shown in the design wizard) keep varying, when i change the AggregationUsage properties of the attributes of the dimensions in the cube. Here is a set of rules for setting the AggregationUsage property, that I had read from a blog on the net: 1. Attributes that are not displayed = none 2. Attributes that are not used in any hierarchy = none 3. Extensively used attributes = Full 4. All other attributes = Unrestricted I first set the Month attribute, Key attribute of the date dim as Full. (not sure if thi ...Show All

• eldiener Custom Data Flow Task throwing error when run from command prompt

  Hi, I developed a custom data flow task in .net 2.0 using Visual Studio 2005. I installed it into GAC using GACUTIL and also copied it into the pipeline directory. This task runs absolutely fine when I run it on my local machine both in BIDS and using the script in windows 2000 environment. However, when I deployed this package into a windows 2003 server, the package fails at the custom task level. I checked the GAC in windows\assembly directory and it is present. Also I copied the file into the PipeLine directory and verified that I copied it into the correct pipeline directory by checking the registry. The version of the assembly is still Debug. I looked up documentation in MSDN but there is very little information about the error ...Show All

• Chadrico Property DefaultSchema is not available for Database [DatabaseName] in SSMS

  I've been researching the notification message [Property DefaultSchema is not available for Database [DatabaseName]]. This message is generated when I try to create a new table object using SSMS. I am logging into the SQL Server using an NT Authenticated Login which is mapped to an Active Directory Resource Group. I have found the following information specific to Default Schema's in SQL Server 2005. First, by design, you cannot assign a Default Schema to an NT Authenticate Login that is mapped to a Windows Group. This is noted in the CREATE USER (Transact SQL) BOL topic - http://msdn2.microsoft.com/en-us/library/ms173463.aspx "DEFAULT_SCHEMA cannot be specified when you are creating a user mapped to a Windows group, a cer ...Show All

• thewalrus Database Restore, Error 3154 and

  Hi all, I am trying to restore and SQL 2000 database into a new SQL 2005 database. I performed by SQL 2000 backup and created a blank database FERS_Production in SQL 2005. FERS_Production was the original name of the database in the SQL 2000 instance. I have tried giving the new database the same name as the original and a different name to the original database (Below is the scripted T-SQL that I get from the DB Admin tool RESTORE DATABASE [Fers_Production] FILE = N 'FERS_Production_dat' , FILE = N 'FERS_Production_log' FROM DISK = N 'D:\Microsoft SQL Server (2000)\MSSQL\Backup\Fers_Production\Fers_Production_db_200607270206.BAK' WITH FILE = 1 , NOUNLOAD , REPLACE , STATS = 10 GO When I ru ...Show All

• Hanspeter Benefits of using SQL over XML

  Hi, I have a question relating to XML and SQL. My company currently runs a website which allows its clients to log in, view their accounts and transaction history online. The website is totally read only with the exception of changing passwords. The data is taken from our back office system overnight which runs an oracle 8i database (we cannot like our website to the database due to the agreement we have in place with our software supplier). The data is written to a CSV file which is then converted into XML. The XML file is saved to the webserver and is referenced by the website. The structure of the website has a relationship where the Client has a Manager who can see their clients accounts, a Branch level that can see all of th ...Show All

• IraMaster Can't access instance of local webserver

  Hi, I've installed SQL Server 2005 Express Edition, SQL Server Management Studio Express using Windows Authentification and IIS 5. The problem occurs when I try to access the default address of my local computer to test my installation. I've tried with both http://localhost and http://127.0.0.1 . The system requires a password despite I don't use password for my Windows Authentification. Does IIS always demands a password regardless my settings for Windows Authentification or Best regards Windows Authentication / passing the credentials can be truned on using the Tools / Options -> Advanced -> Enable WIndows AUthentication. But if you enabled Anonymous Authentication right now and it doe ...Show All

• kubaw Microsoft.Jet.OLEDB.4.0" has not been registered

  I'm trying to import an access database into a sql express database (32 bit system) and get the following error Msg 7403, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. my script is as follows SELECT * FROM OPENDATASOURCE ( 'Microsoft.Jet.OLEDB.4.0' , 'Data Source="k:\armycwy.mdb"; User ID=Admin;Password=' )... CWAM_ROSTER Anyone got an idea what is wrong TIA Kevin hi kevin, pleas try downloading and installing the latest driver found on this site http://msdn.microsoft.com/data/mdac/downloads/default.aspx Joey   I noticed you men ...Show All

• John.Doe date parmeter converts into drop down

  I am working in SSRS 2005. I have three parameters on the reports Parmeter 1 is Date filter which is drop down and values are MTD,QTD,YTD... 2nd and 3rd parameters are fromdate and todate which are datetime parameters. When user select let's say MTD from parameter1 then i have Stored procedure which populate the fromdate paramter with 1st date of the month and, todate populate the todays's date. The problem i am facing is the moment these date parameters get populated it converts into drop down. i want these date parameters should be still datetime so user can select the date. The value i am passing to these parameters are datetime type( Now() ) .Still the date parameters controls are showing as dropdown. I don't know how to hand ...Show All

• Smarttles int vs smalldatetime?

  Both are four bytes, are there any reasons to choose an int for a PK over the smalldatetime Mhmm, thats a strange question. Accroding to your business need it is always preferable to use a natural key. If the smalldatetime (with storing a date as a PK) is a natural key for you you will have to consider that it is only 3ms in precision. If you need a numeric PK you should choose INT (or any better fitting numeric value). HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Thanks, yeah - I know, strange question. I am trying to optimize for space since I have several billion records, and the field is currently a datetime (8 bytes). Since I don't need that prec ...Show All

• Luc Pettett How to make Application.LoadPackage() and Package.Execute() to run asynchroniously?

  Hi, I am trying to execute a SSIS package programmatically. When a user drops a file in a shared folder, we execute the package based on that file. I am using SqlServer.DTs.Runtime.Application.LoadPackage() and SqlServer.DTs.Runtime.Package.Execute() functions each time to do this. The problem is, when, say two people drop a file, the second one will not execute untill the first one is completed. I also tried only calling LoadPackage() a single time, and then storing the instance and calling Execute() in a different thread on each file drop; although the blocking still occurs. I assume the Package object is the one doing the blocking then behind the scenes. Is there any built in functionality to make these functions (Application.LoadPackag ...Show All

• Jive Dadson Errors in the metadata manager

  Hello, I'm trying to process a cube and i'm getting the following error message. I'm not working in Analysis Services Project 4, i created another project. I deleted Analysis Services Project 4 and every project i try to execute i get this error message. "Error 1 File system error: Error opening file; \\ \C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the TBLE~MC cube, from the file, '\\ \C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml'. File system error: The following error occurred while writing to the file ...Show All