Answer Questions

• Lawrence 007 Using Cube Views as a data source to build Mining Model

  Hi all, I am new to SQL Server 2005 Analysis Services and would like to use the OLAP Cubes as a datasource to build Mining Model . However i would like to use a particular view of the OLAP cube that i have generated to be used as the datasource for the mining model . I find that i am not able to save the Cube View while browsing the OLAP cube in Business Intelligence Studio. Is there a way i can acheive this requirement. Any ideas regarding this will be really appreciated. Thanks & Regards, Satya Yes, your cube is based on your data source view. Once you edit the data source view for your cube, you will be able to browse your cube on the way edit your cube structure based on your data source view thus being able ...Show All

• marksidell execution of Stored procedure has become extremely slow

  Hello, i am having a bizarre problem with the execution of a stored procedure on SQL server. up to now, the execution time was taking maximum ten minutes and then suddenly since a few days ago, it takes more than 40 minutes, without exception!! i have tried to diagnose this problem with some tools that are provided out there such as executing a stored procedure called "proc track_waitstats" from which i learned that the “max degree of parallelism”. needed to be set (i set it to 3, it used to be zero. there are 4 processors). after rerunning the diagnosis, my SQL server seemed very happy with wait times. zero wait time for almost everything, but my stored procedure is still running as slow. what is going on how come it was running so much f ...Show All

• barbbayne How to get Remote Backup

  Is there any way that i can get backup from other(Remote) location on LAN Thanks   You can use Transact-SQL to do this using UNC naming, like this: RESTORE DATABASE [my_database] FROM DISK = N'\\LanServer\MSSQL\BACKUP\my_database_backup.bak' WITH FILE = 1, NOUNLOAD, STATS = 10 GO Sir i can use SMO on computer where sql server installed, but when i access sqlserver from other computer (from my client application which i have developed using C#) then i get an exception. Thanks   Hi, you already did this in your other post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1194939&SiteID=1 BackupDeviceItem bkpDevice = new BackupDeviceItem(openBackupDialog.FileName, De ...Show All

• Richard_Wolf 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

• MrBrilliant Replication Error

  I found a problem in replication which we have 3 tables, namely tab A, tab B and tab C replication will apply on tab A and tab B and there is a trigger on tab A and tab B, whenever insert/update on tab A it fires trigger to update tab b whenever insert/update on tab B it fires trigger to update tab C And I found the replication error from tab A on updating tab C. If I manually insert the row, it works fine..... Any advise Thanks in advance! Sorry, I am confused. It looks like there is no issue. Is the trigger, when insert/update table B, table C will be inserted with rows,defined by yourself or generated by replication Also, table A is on publisher side, are table B and C on subscriber side Wha ...Show All

• George Waters Sharing Dimensions

  I'm trying to share a few dimensions between two cubes so when I'm on the cube wizard building the second cube, I don't check the shared dimensions as new dimensions, but I select them afterwards when the wizard asks me to choose the shared dimensions. Until here, everything shoul be just fine, but when the wizard finishes I can't see the shared dimensions on my cube... do I have to build the same dimension twice with a diferent name (eg. DimCustomer - DimCustomer1) that's what I ended up doing... after creating the cube, I added the shared dimensions manually since the wizard didn't do it for me. But I still think is something I'm doing wrong. Maybe I need to declare those dimensions that they will be ...Show All

• spot9969 SQL Everywhere - Utter Dissapointment!

  On the surface, SQL Everywhere seems like a great way to reuse code from an enterprise app using SQL Server in a SMB or home office app needing a more But in experimenting, I have been utterly dissapointed in SQL Everywhere. Key reasons for my dissapointment are the inability to write Database Independent codeusing System.Data.Common . There are instructions for doing this in the MSDN. But do they only apply to non Microsoft Databases I have the following grievances. Are these things that Microsoft plans to fix, or do they plan to leave SQL Everywhere as an inferior product 1. Limitations of query language are not well documented nor understood. SQL Everywhere uses a "subset of Transact-SQL syntax". I have not seen it do ...Show All

• Vladimir Sapronov Limit number of rows returned

  I am developing a top 20 report. How do I limit the report to only return up to 20 rows (detail lines, no groups) Thanks Hello, Use Dyamic Queries like ="Select top " & Parameters!t.value & " pub_id,pub_name from dbo.publishers where city=ISnull(@City,City)" & order by & Parameters!col.Value To populate the Col Parameter where the user is going enter the sorting Column.Use the Query like this Select a.name from syscolumns a join sysobjects b on a.id=b.id and b.xtype='U' and b.name='WBHierarchy' --tablename I did not try ,Hope it will work Here i have given the top rows selection also as parameter Pls reply,if it is working. Thank you, R ...Show All

• billqu SQL2005 SSIS - won't allow text delimiters

  W2k3 server, SQL 2005. @@version = Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) I'm trying to set up my first SSIS package to import a flat file to a database table. The connection manager will not allow a text qualifier. My data is comma delimited, with doublequotes around each field. If I enter " as the text qualifier, then I get the error "The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding text qualifiers in data. Parsing columns that contain data with text qualifiers will fail at run time." The data in Columns view shows as just one column rather than multiple columns. If I leave the text ...Show All

• sud Using openrowset (bulk...) with Variable in Filespec

  Hello, to accelerate loading xml data from many files into a table using openrowset (bulk...) I want to use a variable in the file specification and increment it within a loop similar to this: declare @datnam varchar(100); DECLARE @MyCounter int; SET @MyCounter = 1; set @datnam = 'c:\XML_Daten\POS_LOG_200608_'+ltrim(str(@MyCounter))+'.xml'; INSERT INTO GK_TO_KFH_ADAPTER_XML_NS (LOC_ID, MSG_CONTENT) SELECT @MyCounter, MSG_CONTENT FROM ( SELECT * FROM OPENROWSET (BULK @datnam, SINGLE_CLOB) AS MSG_CONTENT) AS R(MSG_CONTENT) But I got the following error: Msg 102, Level 15, State 1, Line 8 Incorrect syntax near '@datnam'. Is there a way to this in that manner Or is the bcp utility an alternative Regards Peter ...Show All

• Evan Mulawski RetainDays property of Backup statement

  According to SQL Server 2005 Books Online, the RetainDays property specifies the number of days that must elapse before a backup set can be overwritten. I do not quite understand the implication of this property. Say, if I set RetainDays = 1, is it mean the backup set from yesterday MAY BE overwritten If it is 'may be', how does SQL Server determines whether to overwrite or not I tried RetainDays = 1 to backup a dummy database, but my test.bak keeps growing, the old files do not seem to be overwritten. Besides, what is the implication of accepting the default RetainDays = 0 Just to confirm my understanding. To instruct SQL Server to overwrite EXPIRED backup set, I need to: 1. Use INIT, NOSKIP 2. all bac ...Show All

• Samoyed How to do QTD and MTD in MDX ?

  I want to use the setup as used in the "A different approach to to Time Calculations" http://www.obs3.com/A%20Different%20Approach%20to%20Time%20Calculations%20in%20SSAS.pdf But i still need Month to date and Quarter to date, as sepperate members in the Time calculation dimension (i know i can use the periods to date). As with the other members in the dimension this shall apply to every meassure that might be in the cube. Can someone give an example of how to do it in MDX I advise you to use AS built-in Time Intelligence Wizard. It uses Time calculation attribute rather than Time calculation dimension, but the expressions for MTD and YTD will be the same. The YTD looks li ...Show All

• Eric Best Error installing SQL Express 2005 SP1 on XP Home/SP2

  As the subject says, I am getting an error installing SQL Express 2005 SP1 on XP Home/SP2. I have never had a previous version of SQL server installed. I have never had Visual Studio installed. I have tried extracting the setup files and running from a different directory. I have tried installing the advanced package as well with the same results. When I run the setup, the Client and support files are successfully installed. It then goes on to the system analysis, where I get one warning about my hardware but I have checked the help file and my system appears to meet the system requirements. After I click Next from this window is where I get the error, " Error writing to file: Access is denied. . Verify that you have access to that di ...Show All

• Ben Taylor I forgot my SA password for my instance of SQL 2000

  Hi all, I have SQL 2000 and I forgot my SA password and cannot login as administrator using windows authentication. Is there any way to reset SA password "Mixed Mode" authentication is enabled. If I change authentication mode in register to Windows only and then after restarting SQL change it back to Mixed, will it reset SA password to "null" Thanks in advance. Try sp_password NULL,NULL,'sa' Assuming you never created password at the first place. parameter 1 is Old password, parameters 2 is new password, parameter 3 is user. Just in addition to Glenns post and your qustion: It won’t reset the password to null wit ...Show All

• patio87 Datamining or OLAP cubes or just plain old relational sprocs

  Hi, I have a hi-level design question that I was hoping someone could help out with. I have a requirement to come up with a processing engine which takes into account mulitple sets of rules or filters, such as follows: Rule1: Find all claims which have one of these diag codes (D1, D2, D3), which also have one of these procedure codes (P1, P2, P3), and belong to one of these divisions (V1, V2, V3) Rule2: Find all claims which have one of these diag codes (D7, D8, D9), which also have one of these procedure codes (P3, P4, P5), and belong to one of these LOBs (V4, V5, V6) Rule3: Run Rule1 and Rule2; Find all claims which are common in both Rule1 and Rule2 Rule4: Rule Rule1 and Rule2; Find all claims in Rule1 which are NOT in ...Show All