Answer Questions

• thereisnomike Problem with dynamic security and dependent dimension (SSAS 2k5)

  Hi all, I try to implement dynamic security and I have a problem with a dependent dimension. What I want: Each user is responsible for one or more branches of the company, so each user should see the data the branches, she is responsible for. What I get: Error: Das Branch-Attribut in der DIM_ZWST-Dimension weist einen ungultigen Sicherheitsausdruck fur eine generierte Dimension auf. (sorry, it's german) It means: The Branch-attribute of the DIM_ZWST-dimension has an invalid security expression for a generated dimension. This is my setup: SSAS 2k5 Dimensions: DIM_USERS with attributes Name, Loginname (this is NT user name and should correspond to the MDX UserName()-function) DIM_ZWST: These are th ...Show All

• Kumar Venkat Loading images into SQL server express 2005 tables

  Im new to SQL server express 2005 and im having issues loading images into my tables. can anyone show me how to achieve this Thanks Matt Thanks for the help Ramu Here is Sample table structure: Create Table EmployeeProfile ( EmpId int, EmpName varchar(50) not null, EmpPhoto varbinary(max) not null ) Go User following to to insert image: Insert EmployeeProfile (EmpId, EmpName, EmpPhoto) Select 1001, 'Vadivel', BulkColumn from Openrowset( Bulk 'C:\Blue Lace 16.bmp', Single_Blob) as EmployeePicture Moving the thread to the sql express groups. ...Show All

• ManojS And/or filter field not enabled in the group filter tab

  Howdy, I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND. PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current us ...Show All

• Ravindra Patil Object reference not set to an instance of an object

  I have built using RS2000 service pack 1. I can view the report within visual studio. When the report gets depolyed, the first page is displayed perfectly. When I go to view the remaining pages I get the following error. Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Object reference not set to an instance of an object. The other interesting thing is that the report exports perfectly to both Excel and PDF. To date the only viable solution is completely rebuild the report. Same report. Same layout works fine once it's rebuilt. An ...Show All

• pdns SQL Server 2005 Data Encryption Issues

  I read a couple of articles related to encryption topic in this forum and I feel that's really helpful I don't know if anyone has some knoeledge about the encryption issues in replication and clustering environment. I read some documents from Microsoft web site that explains how to move an encrypted database from its original server to another new server instance. That cause a lot manual works, if the database master key has been encrypted by the original service master key and you still want to enjoy the auto-open feature in the new environment. As we know the Microsoft SQL Server 2005 has a hierarchy encryption key structure and its top level service master key is really service oriented. For what kind of mechanism or set up, Microsoft ...Show All

• luisarvayo Comparing table structures.

  Hi all, Could anyone let me know if there are any Scripts available for comparing the schema differences between two SQL server databases Thanks DBAnalyst Please send it Jens, Thanks a lot. I once made a script for that, feel free to contact me if I should send it over. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• mwindham Predicate or key word all in uppercase?

  Hi, What is the dowside of not using all uppercase for predicates and key words I cannot find to see a problem beside adhering to a clean coding convention. After all I already have color coding so what would be the uppercase for Same question for the semicolon ; at the end of a sql block. Is that real necessary not to get in trouble sometime down the road or is it a non-issue. I find like I am now a C# guys if I use these ; Just curious, I find tedious to switch from all upper case to normal case all the time. And not forget to type the ; Thanks, Philippe Our deprecation policy is fairly strict right now in the sense that we make announcement first in version N, then warning in version ...Show All

• tylerdn Regarding MSsubscription_agents table...

  Hi,            I am using transactional replication with updatable subscriptions. I am not able to apply the snapsnot after doing schema changes. The subscriber throws the error Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. This error is thrown on the below query... select * from MSsubscription_articlecolumns where artid = 4 and agent_id = ( select id from MSsubscription_agents where update_mode > 0 and UPPER ( publisher ) = UPPER ( N 'Servername' ) and publisher_db = N 'TestTransUpdate2' and publication = N 'Test_TransUpdate2' ) The table MSsubs ...Show All

• Drezard Execution 'wccc0s552po43i45n10vgmrq' cannot be found

  have developed a couple of simple parameterised reports in SQL Server 2005 Enterprise Reporting Services for my current project. I am now trying to use Visual Studio 2005 and the ReportView control to hook into these remote reports from an application. I have run into an error and am unable to resolve it: · Execution 'wccc0s552po43i45n10vgmrq' cannot be found I have trawled the Internet and a chapter in "Microsoft SQL Server 2005 Reporting Services" with no joy. Has anyone seen this before. I'm sure it will be something simple that I have overlooked. I'm posting a little 'thanx' to Timk74. I also had this problem. It worked fine in my development environment, but in production, my report viewer ( ...Show All

• Asiye Execute Package Task always fails.

  I have a package (i.e. child package) which runs itself perfectly fine without displaying any error. However when I embeded this package inside another package (i.e. parent package) using Execute Package Task. The task always fails. It seems strange enough. The child package has two variables that need to be passed in from parent package. Can any expert here please help out Thanks. - Steve Here is what I did to fix it ... i delete the troubled child package completely, and rewrote it from the sratch. And it started to work. Just as a reminder: Please note that the old trouble child package contains some copy-and-pasted tasks (and connections) from parent package. I often use copy-and-paste to develop ...Show All

• AlanKohl compare data on Replication Server

  I need to compare data on two replication server I want to make a Stored Procedures for it Do I use LINKED SERVER to link the server together How do i get the name of the server on the Replication to compare the between two server. This will be used on more than one Replication Server It should auto get the name of the server to compare without the user input ...Show All

• wshs How to list all table without a primary key within SQL Server 2005 database?

  Hi, All, Would please any expert give me any advice and guidance for how can we list all tables without any primary key within a SQL Server 2005 database Thanks a lot in advance for that. With best regards, Yours sincerelyd, Hi, Daniel, thanks a lot. With best regards, Yours sincerely, Hi, Asvin, Thanks a lot for your kind guidance. With best regards, Yours sincerely, Switch to the database you want to analyse and run this script: select sys.schemas . name as [Schema] , sys.tables . name as [Table] from sys.tables left outer join sys.schemas on sys.schemas . schema_id = sys.tables . schema_id where sys.tables . object_id not in ( sele ...Show All

• xavito Creating Reports Using SQL QUERY ANALYZER

  I am a student of the University of Phoenix. In My SQL class I was unsuccessful in creating a report using basic SQL commands using the SQL Query Analyzer version 8.00.760. I am using a version of Microsoft SQL Server 2000 Sold to me by the college. The Disk 1 said SQL Server 2000 Developer Edition. Disk 2 said SQL Server 2000 service pack 3a. The Third Disk Says SQL Server 2000 Reporting Services. Since I am learning SQL on this platform I wanted to create reports using the SQL Query Analyzer. So how do I create reports using Basic Commands. This is what I have so far. CREATE TABLE ACCOUNTS ( Account_Number INT NOT NULL PRIMARY KEY, Long_Description VarChar(500) NOT NULL, Short_Description VarChar(500)NOT NULL, Balance Money NU ...Show All

• fhunter Report server database security question

  I am currently the only Reportbuilder / Contentmanager / Publisher and admin in the Report server database. I am using windows authentication when creating subscriptions and saving them in this database. Some of the reports that i create have very sencitive information. What risks and procautions do i need to assess if i want to add another reportbuilder / content manager that can manage subscriptions The main thing is I do not want the other builder and content manager to see my report information. is it just meta data that it holds or do i need to worrie about the data also if so what do others do to block them from viewing other peoples data Summery : I just want them to see data that is relevent to their work and not mine. Is th ...Show All

• Zafar Ullah Make a Common Color Palette

  What would be the best approach for having all the reports share a color palette. What i want to achieve is that when we want to change for example the color of our column header i somewhere change a value and all reports are modified. That somewhere might be a config file, a sql table, a registerentry, .... I know i could change all rdl files but that's nog a approach i want to develop. Kinds Regards Btw, you may find the following article useful: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/MoreSSRSCharts.asp It also contains an example about using custom color palettes. -- Robert Sorry, never checked the <expression> possibility. I mean, ...Show All