Answer Questions

• John Bailey Generate relational schema - old tables are always deleted and not recreated

  I want to use the top down modelling features and generate tables from the OLAP objects by generating relational schema. The problem: First time using the "generate relational schema" - the tables are created. Next time using this feature: new tables are generated, but all tables created in the past are lost. There is a warning, the schema can't be created, because there are user defined tables. I found a way to reset this status, if I open the code for a dimension and delete the section from <Source to /Source>: < Source xsi:type = "DataSourceViewBinding" dwd:design-time-name = "51a3fe82-65d2-402e-a846-d2b9689b177c" > < DataSourceViewID > LR OL ...Show All

• MadVax Upgrading DB Server to 2005 *after* the install?

  I had a SQL2000 DB Server with a simple database. I did an "in place" upgrade to SQL2005 expecting the DB Server and databases to upgrade. However, now when I run SQL Server Management Studio and enter the query:- SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') I get the answer:- 8.00.2039 SP4 Enterprise Edition Why didn't it upgrade And how do I upgrade it now I'm very confused! It is correct SQL Server 2000 Enterprise Edition cannot be upgraded to SQL Server Developer Edition. But you can upgrade it to SQL Server 2005 Enterprise Edition. Please check BOL for detailed information related to upgrading. You are correct for your options. But if machine ...Show All

• Simon Dahlbacka Can't Find ConfigEdit

  I installed the ConfigEdit XML editor mentioned in Kirk Haselden's great Integration Services book. But I can't use it unless I can find it! It's nowhere to be found in the Start menu or BIDS or right-click menus or inside projects. The book assumes you know where to go to open the editor. I'll be the first to eat crow if it's somehwere obvious. ConfigEdit installs to %ProgramFiles%\SSIS\Package Configurations Editor. I wouldn't call that obvious. Thanks jaegd, got it! Phil, the date of my SetupConfigEdit.msi is 12/27/2005, but I don't recall getting a prompt. It's possible I was surrounded by distractions at the time or I may have installed it and didn't h ...Show All

• hr0nix .Net CF 2.0 Error , "Can't find PInvoke DLL 'dbnetlib.dll'."

  I have an IPAQ 2795 and installed a program that emulates Enterprise Manager on a Windows Mobile Device called SEM v1.01 from Trianglepowers.com http://www.trianglepowers.com/ppc6700/Default.aspx I have installed the latest Net Compact Framework and service patches / updates I have installed MS SQL Mobile Edition I have installed Client CAB But I still get this error when I try to run the program. Can anyone suggest a solution Thanks HI, looking at the comments of people who downloaded it ( http://www.trianglepowers.com/ppc6700/Default.aspx ), they both say they get the same error, and it doesn't work Pete I contacted the developer. A new version of the progr ...Show All

• Raguvind System.Data.ConstraintException Visual Basic 2005 Express / SQL 2005 Express

  This problem only occurs after deployment, not when debugging. In the table I am having a problem with I have an ID field designated as the primary key with the identity increment set to 1 and the identity seed set to 1. There is no data in the table when deployed. I can add records to the datagridview control but when I try updating the dataset I get this error indicating that the ID field already has a value of 1 present. If I close the application and re-start it, the exception no longer occurrs when I update the dataset. I am including the code to update the tables incase something is wrong there. Any suggestions Private Sub UpdateMemberTable() Me .Validate() Me .TblMembersBindingSource.EndEdit() Me .TblMembersTable ...Show All

• gpugelni Usage of Association Rules

  Hello, I want to score my data by only the assoziation rules I filtered in Mining-Model-Viewer. Is this possible I recognized that MiningModel Predictionquery uses the generated Model (all rules). Is there any way to influence the model at generating time. Thanks a lot.   Hi, I specified the point to solve my problem but I did not understand why MS SQL Server didn't recognize the Association parameters I but in. It uses the Minimum_Probability I put in, but the Minimum_Importance i wrote didn't care it, it use the default value. I want to paste a screenshot here but it isn't possible. By the way I'm using the evaluation version, which should be same as the enterprise edition. Hope for a soon ans ...Show All

• Andrew D Server Collation

  Hi In the properties of the server, the general page, the property Server Collation is "Modern_Spanish_CI_AS". I need to know as I can change this property. I have developed applications in platforms with different languages on Windows and when doing a consultation towards this server, happens a conflict. I am using SQL 2005 Server Express Edition Please ask me to my e-mail: viejomicky10@yahoo.com or viejomicky10@hotmail.com Thanks and grettings hi, once installed, you can not easely modify the system databases collation, but you can set the user's databases collation at both database and even column level... you can do that, but please have a look at http://msdn2.microsoft ...Show All

• PaulBSteelerFan discrete domains in sql

  I have a sql-table. The domain of one of my columns a fix number of string values (like "blue", "green" and "yellow"). However, there is a big likelyhood that the domain will be expanded by more string values in the future (however, none of the existing string values will ever be discluded from the domain). How would I go about enforcing that all strings added to my column in my table is within my domain Should I use a check constraint, or create a domain, or sholud a create another table with the domain values and use a foreign key What would be best practise for my problem Any of the choices would work. The best choice will really depend on other things. Use the ta ...Show All

• Paul Thomas Can't connect to SQL Server 2005 Express from another machine

  I know there have been many posts made on this subject; however, despite the resources available, I have not been able to get this to work! I've spent time working on this here and there over the last couple of months only resulting in frustration. I am finally posting to solicit help for my situation to figure out what is wrong with my SQL Server or firewall configuration. Two machines connected to a router, one wireless, one wired. Both have SQL Server Express and the Management Studio tools installed. From either machine I can connect to its local SQL Server Express instance. I have enabled Shared Memory, Named Pipes, TCP/IP, and VIA in the SQL Server Configuration Manager. (BTW what is VIA ) I have added sqlsrvr.exe and sqlbro ...Show All

• anli31 reporting services paramters

  hi, i want to create a report. lets say the report is: exec sp_spaceused. i work with dataset working on master. if i want to create a list of my databases and choose dinamically each time my database - how do i connect the query: select * from sys.databases to my dataset. what i mean to say is that i want to choose from a combo box my database and each time the report is running it will run on the "exec sp_spaceused". thx, Tomer This should be helpful http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=16395&SiteID=1 ...Show All

• Agostino Marottoli Domain group logins failing on SQL 2k5 workgroup

  This question is regarding a brand new out-of-the-box SQL Server 2005 Workgroup Edition install. The old SQL Server 2000 server is working properly with regard to the issue we're having: We are using Windows Authentication, and have created SQL logins for about 40 different groups on our domain. We've given those logins the appropriate permissions on the databases they're supposed to be able to access. The SQL Server is not a domain controller, but is a member of the domain, and domain logins do work for Windows-login purposes on this box. The problem is that when users try to connect to the SQL server, they are denied access. An error 18456 is thrown, and logged in the Application event log stating "L ...Show All

• Abdullah.Ahmed Internal error 2337 while installing BCM and MSDE Server

  Can somebody help me I want to install Business Contact Manager a second time (I uninstalled it before) and while installing, there is an error (2337) What can I do David ...Show All

• Max Andrade Preferred index for a standard history/activity table design

  Imagine the following table: MyTableActivity -------------------- MyTableActivityId (pk, guid) MyTableId (fk, guid) MyUserId (fk, guid) ActivityTypeId (int, guid) ActivityDateTime (datetime) Comment (varchar(max)) This is pretty common, right One way or another, this is kind of an audit log of another table (referenced by MyTableId). My question is in regards to what would be the best index(es) to place on this table. The three fields in question are MyTableId, ActivityTypeId, and ActivityDateTime, as these are (at least in my system) far and away the most frequent search criteria. Users will either typically want: All rows for MyTableId, sorted by ActivityDateTime All rows for MyTableId and ActivityTypeId, sorted by ActivityDateTime The ...Show All

• robben07160 InvoiceNumber as a degenerated dimension in AS 2000?

  Hello, We have a couple of cubes in AS 2000 where the users would like to be able to search/view by #Invoicenumber and #POnumber. Instead of creating a separate Invoicedimension I would like to implement it as a 'degerated dimension' - just as a textfield in the facttable. Some questions: Does AS2000 support this Are there any special demands on the client tool to be able to support degenerated dimensions At the moment InvoiceNumber is defined as varchar(16), is that OK Looking forward to your responses and advices .... As far as I can recall this shouldnt be any problem. Degenerate dimensions are handled just like any other dimension by ssas so there are no problems with client tools using t ...Show All

• Evan Hennis Select Data based on Certain Time period

  Hello all, I am using SQL Server in a project where I want to fetch the records that were inserted after a time specified in my query. Suppose 10 records were inserted at 10:00 AM(morning) and 5 were inserted at 10:15 AM( 15 minutes later). I am running a query at 10:20 AM( 5 minutes after the second transaction). I need this query to be such that it selects the records inserted 10 minutes before. So it will show only the records inserted at and after 10:10 AM and willl not show those inserted at 10:00 AM. Please help me in making such a query. I am trying and I think that some Date & Time functions will help but still not able to achieve it. Thanks in advance Hi, SELECT * FROM SOMETable WHERE SomeDateColumn > ...Show All