Answer Questions

• vijay1 Hierarchy Problem after processing - Help!

  Hi, I'm using AS2005 and have time dimension with hierarchy as follows: [yr_dt] --> [yr] --> [hyr] --> [qtr] --> [mon] --> [dt] Normally, it show full hierarchy when I browse the hierarchy : e.g. 2006 --> 1 half --> 1 quarter --> Jan --> 2006-01-01T00:00:00 However, after I change the data source view to include more data in specified data range and reprocess the cube, The hierarchy only shows [yr] nothing under [yr]. Only correct year is the last year (i.e. 2006). It show full hierarchy as above. May I know what's wrong with AS2005. Or is it a bug Any method to solve Thanks in advance Are your attributes unique i.e.   Year -> 2007 Quarters  Q1, 20 ...Show All

• Equis Reporting Services for SQL 2005 Standard

  How do you enable reporting services in SQL 2005 When i initially installed SQL 2005 i allowed everything to be installed, but now i do not see how to get into reporting services to get it started. I also look in the Surface Area Configuration Tool to see how to enable it but did not find anything. Can someone please help me Only the second line is there. I cannot find any Setup bootstrap directory Should i just try reinstalling Report Services I cannot reinstall the entire SQL 2005, because it host a database on the web. Will reinstalling report services affect anything else I cannot get to neither one. The first one is not available a ...Show All

• NytewolfAU2k7 ms sql 2005 delete record problem

  I'm facing problem when delete a record in the ms sql 2005 . The error message i got is stated below: No rows were deleted A problem occured attempting to delete row 1304. Error: .Net Sql Clint Data Provider Error Message: Possible index corruption detected. Run DBCC CHECKDB. Correct the errors and atempt to delete the row again or press ESC to cancel the changes. just certain record i can not delete and face this problem. i detach the database and attached in the ms sql 2000, and select the same record to delete. there is no problem at all. i wander is it ms sql 2005 bugs can anyone tell me how to fix it .. how to to use the DBCC CHECKDB thanks alot.... P/s : if i posted at the wrong section jus ...Show All

• RickKr select a tablename

  How can you get the tablename of the object you are selecting from to appear as a result of a query i.e. select tablename from table_'A' should return table_'A' I am creating a chronological list of activities using multiple tables and want to include the name of the table the record came from. Any help is appreciated. That's what I figured. Thanks for the verification. Yeah, agreed, You would just do: select 'tableName' as tableName, column1, column2 from tableName If you need this, and it is a reasonable need, I think... Hi, there is no way, you will have to use a static string to put this information in the resultsset. HTH, Jens K. Suessme ...Show All

• Albert_Khor Convert Date

  Hi ! I think I need your help... to convert the date (2006-09-09) to weekday, weeknumber, month number, month, year in OLE DB source editor ... created following sql, which is not working. How about using derived Column transformation editor SELECT DATENAME (WEEKDAY, YYYYMMDD) AS weekday, DATEPART(WEEK,YYYYMMDD) AS weeknumber, MONTH(YYYYMMDD) AS month_number, DATENAME(MM,YYYYMMDD)AS Month, YEAR(YYYYMMDD) AS year, DAY(YYYYMMDD) AS date FROM Purchase thank you so much... it seems very easy, but just don't get it right. using the columns 'year' and 'month', 'week' the function looks like this in derived transformation ... DATEPART( [year] [month] , date) or DATEPART( [year] [week] , date) but its red Double chek the destinat ...Show All

• davep1553 Select vs Stored Procedure

  I have code simililar to the following in a stored procedure: CREATE PROCEDURE GetGroupMembers ( @GroupID INT ) AS SELECT TMembers.MemberID, VCurrentMemberGroups.GroupID, THonorsMembers.HonorID FROM THonorsMembers LEFT OUTER JOIN TMembers ON THonorsMembers.MemberID= TMembers.MemberID LEFT OUTER JOIN VCurrentMemberGroups ON TMembers.MemberID= VCurrentMemberGroups.MemberID WHERE (VCurrentMemberGroups.GroupID = @intGroupID) AND TMembers.DeleteDate IS NULL ORDER BY TMembers.MemberID RETURN GO When I call this stored procedure in Query Analyzer, it takes two minutes to execute. The web pages that rely on it time out before that. If I copy just the select statement and substitute the group I'm working wi ...Show All

• JohnBurns007 ADO Connection Pooling Error: "The client was unable to reuse a session with ..."

  Hello, We are running SQL2K5 and have a Web server with a family of sites all sharing an identical connection string to enable ADO connection pooling between them. Today for about 20 minutes we had several (all ) connections from one site that uses a specific DB get a connection reuse error which showed in out SQL logs: DESCRIPTION: The client was unable to reuse a session with SPID #, which had been reset for conection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. We also have SQL Server slowdown and log in problems from other applications that seemed a symptom of this, or some third unknown cause. Note, the # means the ...Show All

• EvilOneSD Dynamic columns for Flat File destination?

  I have a database app, and we're implementing various data export features using SSIS. Basically, it's a couple of straight extracts of various recordsets/views, etc. to CSV (flat files) from our SQL Server 2005 database, so I'm creating an SSIS package for each of these datasets. So far, so good, but my problem comes here: My requirements call for users to select from a list of available columns the fields that they want to include in their exported file. Then, the package should run, but only output the columns specified by the user. Does anyone have any idea as to the best way to accomplish this To recap, at design time, I know which columns the users will have to choose from, but at run time, they will specify the columns t ...Show All

• Kamen Totals and Calculated members bug in SSAS 2005 (CTP3, SP2)

  I have created two calculated members in the Adventure Works cube: ---------------------------------------------- CREATE MEMBER CURRENTCUBE .[MEASURES].[ParallelPeriodSalesAggregate] AS Aggregate ( ParallelPeriod ([Date].[Calendar].[Calendar Year],1,[Date].[Calendar]), [Measures].[Internet Sales Amount]), FORMAT_STRING = "### ### ### ###" , NON_EMPTY_BEHAVIOR = { [Internet Sales Amount] }, VISIBLE = 1 ; CREATE MEMBER CURRENTCUBE .[MEASURES].[ParallelPeriodSalesSum] AS SUM ( ParallelPeriod ([Date].[Calendar].[Calendar Year],1,[Date].[Calendar]), [Measures].[Internet Sales Amount]), FORMAT_STRING = "### ### ### ###" , NON_EMPTY_BEHAVIOR = { [Internet Sales Amount] }, VISIBLE = 1 ...Show All

• Lovericky ssis in sql server express edition

  hi, can anybody tel me how i can install (any component to be instakked) ssis in sql server 2005 express edition it's lok like this edition doesn't support ssis! is' it true Thanks Sandipan Thnaks Mike Sandipan Hi Carlin, The security model did not change in SQL Server 2005. We did change the Service Account used by SQL Express from that used by MSDE, but the model is exactly the same. There is a set of DTS Design Components also available on the feature pack page, I've never installed these, but the description indicates they provided design functionality for DTS 2000 packages in SQL 2005. You are correct, you can not generate a canned SSIS package and then run it in Express. You must have the SSIS engine ...Show All

• Yelnik Error: Could not find stored procedure !!

  Hi, Error: Could not find stored procedure. I Installed the SQL Server SP2 and the error still occurs when ever I call the stored procedure from my windows app!!   Any Help what's the name of SP you want to call Now try: exec ThisMonthRecords and post the results In design window its : GetMonthRecord;1 in code window its: GetMonthRecord_1 I tried to rename it to : GetMonthRecord the same error occurs !! Would you mind running this query and posting the results so that we can get some more information related to the object: select uid, left ([na ...Show All

• General Fault Visual Studio Configure Sync Settings dialog

  I saw a powerpoint slide with a Configure Sync Settings dialog in visual studio. I am unable to find this dialog in visual studio team system. Can someone tell me how to get to this Configure sync settings dialog The Configure Web Synchronization Wizard for setting up the virtual directory in IIS and the NTFS file permissions for data replication between SQL Server and SQL Mobile is at the following location on the hard drive: %Program File%\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\ConnWiz30.exe More information about the Wizard is at the link: http://msdn2.microsoft.com/en-us/library/ms171862.aspx If this is not what you are looking for can you give some more information about the required feature. ...Show All

• jmurray_mi Permissions to Reporting Services

  I have been looking at forums trying to resolve my problem and now my brain hurts. I really need help with this and no one seems to have a definitive answer. When launch Reporting Services, the page is blank and the settings options are missing. Even though I am logged on to the server with a local admin account. I have tried taking off annonymous access but when I do this I just get the page can not be displayed. Also when connecting to ReportingServices through the Management Studio I get the following message: The permissions granted to user 'servername\username' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source) The permissions granted to user 'Servername\username' ar ...Show All

• Grant Holliday SQL Reporting Services WS - check user input

  Hi, What is the best way of ensuring that users of a report entere data in all the provided input boxes I have written a vb function that checks the above requirement – but when I deploy my report and use a Reporting Services WS to retrieve the data the function no longer works. Any ideas any body Thanks Then you probably would need to built a custom web site before calling the Reporting Services. That customization is not supported in Reporting Services. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- What about setting the "Allow NULL Values" and "Allow Blank Values" to disable T ...Show All

• JustStudent SQL Server 2000 sp4 crashed with EXCEPTION_ACCESS_VIOLATION

  Hey, The DB had been humming along for months and then it crashed with with "Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION". How do I go about reading the dump to identify the root cause Thanks, Bill Coulter Typically you would need to work with product support to get resolution for these. If you look at the SQLDUMP*.TXT file in the errorlog directory, it may contain the query that was running and give you a clue as to what was going on at the time. ...Show All