Missing Properties???

SQL Server Analysis Services

Index ‹ SQL Server

- Previous
  - 1
    - Can i host a SQL2005 EE DB on SQL2000 engine ? The SQL team just released a Database Publishing Wizard that might meet your needs. The wizard makes it easy to script out your development database, even directly from VS. You can then run the script on your hosted site to recreate the database and the data. You should be able to run the script on both 2005 and 2000 systems. You can find a tutorial on using the wizard in this blog post along with a link to where you can download the wizard. Mike Tag: Missing Properties???
  - 2
    - Incorrect processing order for views While this is not a fix for your problem it might help you out for a while. You can schedule a script to run before the snapshot is extracted onto the subscriber. In the script you could create your troublesome view. That way it will automatically create the view everytime someone is added. Not the solution but maybe a workaround. Martin Tag: Missing Properties???
  - 3
    - Unable to read local eventlog (the parameter is incorrect) We have a tracking bug for this and is planned to get fixed in the next public release. Thanks, Gops Dwarak This posting is provided "AS IS" with no warranties, and confers no rights Tag: Missing Properties???
  - 4
    - Database Blobs & Performance if you don’t select the image / binary column there should be no performance issue. Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Missing Properties???
  - 5
    - How to extract domain name from an email address?? Close, but that still includes .com Code Snippet declare @email varchar(50), @domain varchar(50) set @email = 'johndoe@whatever.com' set @domain = substring(@email, charindex('@', @email)+1, charindex('.', @email) - (charindex('@', @email) + 1)) print @domain Chris Tag: Missing Properties???
  - 6
    - problem connecting Remote Analysis service 2005 from vb.net 2005 Specifying server name in the connect method throws error "A connection cannot be made. Ensure that the server is running." i verfied surface area configuration for Allowing remote connection everything is ok, but still i am not able to connect to server. is there any other way to process the server cube from the client machine Tag: Missing Properties???
  - 7
    - select inside update query? Is it possible for me to do something like update table1 SET var1=something,var2=something2 from table1 (SELECT * from table2) as newtable where newtable.field1=acondition Tag: Missing Properties???
  - 8
    - SSAS processing Just a guess... if you have multiple databases, changing the connection manager won't cause the Analysis Services Processing Task to target a different database because the database ID is hardcoded in the XMLA that's saved when you configure that task. https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=251934 As for troubleshooting, I would echo Darren's suggestions. Tag: Missing Properties???
  - 9
    - Schema (owner) Names Not Visible In Shapes On Diagram Moved to SQL Server Forums. Tag: Missing Properties???
  - 10
    - Select Statement Problem? You have a table that has not been 'normalized', and as you can easily determine, it will often be difficult to work with. You would be far better off to have only one Telephone number column -adding as many rows per individual as needed. For the purposes of your 'exam', here is one suggested solution: SET NOCOUNT ON DECLARE @MyTable table ( RowID int IDENTITY, [Name] varchar(20), Telephone1 varchar(20), Telephone2 varchar(20) ) INSERT INTO @MyTable VALUES ( 'ian', '1234567', '7654321' ) INSERT INTO @MyTable VALUES ( 'Sean', '1111111', '2222222' ) SELECT [Name], Telephone = Telephone1 FROM @MyTable UNION SELECT [Name], Telephone2 FROM @MyTable Name Telephone -------------------- -------------------- ian 1234567 ian 7654321 Sean 1111111 Sean 2222222 Tag: Missing Properties???
  - 11
    - MS SQL2005 express ed + SSIS installation problem I have tried to find any of these severs in msdn2 and nothing found. Where I can download developer or enterprise edition from strange.. Tag: Missing Properties???
  - 12
    - Problem in MDX query for calculating total sales. thanku very much Irina .It wrked exactly the way i wanted !! Tag: Missing Properties???
  - 13
    - help enabling FTS in multiple database Also, Could you please tell us: 1. how much RAM does the box have 2. Are there other SQL instances active on the box 3. Under the Memory Performance Object under PerfMon what is the Available Mbytes that you see during the problem period 4. Does the following command on th database also fail: USE <db name> EXEC sp_fulltext_database 'enable' Thanks. Tag: Missing Properties???
  - 14
    - Dervied Column - Expression? Is there a way to put SQL queries in a user variable I am just trying to figure out, whats the best way to do this Can someone please advise. Thanks. Tag: Missing Properties???
  - 15
    - How Do I Hide Internet Explorer Menu and Tool Bar I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site. Tag: Missing Properties???
  - 16
    - The INSERT statement conflicted with the FOREIGN KEY constraint FK_source_destination. Thanks Arnie. You are absolutely right. The users table must be populated first. I have done as you advised - I have flipped the constraints, removing it from the "users" table and putting it on the child tables (editprofile, userphotos, and precedence). I ran the INSERT statements again. The users table was successfully populated and then I got the following errors: ERRORS: Code Snippet (1 row(s) affected) Msg 547, Level 16, State 0, Line 22 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_precedence_users". The conflict occurred in database "MyDB", table "dbo.users", column 'userid'. The statement has been terminated. Msg 547, Level 16, State 0, Line 25 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_userphotos_users". The conflict occurred in database "MyDB", table "dbo.users", column 'userid'. The statement has been terminated. Msg 547, Level 16, State 0, Line 28 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_editprofile_users". The conflict occurred in database "MyDB", table "dbo.users", column 'userid'. The statement has been terminated. DBO.USERS: Code Snippet CREATE TABLE [dbo].[users]( [userid] [int] IDENTITY(1,1) NOT NULL, [lastname] [varchar](50) NULL, [firstname] [varchar](50) NULL, [email] [varchar](50) NOT NULL, [alternateemail] [varchar](50) NULL, [password] [varchar](50) NOT NULL, [role] [char](50) NOT NULL, [securityquestion] [varchar](50) NOT NULL, [securityanswer] [varchar](50) NOT NULL, [zipcode] [int] NOT NULL, [birthmonth] [tinyint] NOT NULL, [birthday] [tinyint] NOT NULL, [birthyear] [int] NOT NULL, [gender] [char](10) NULL, [city] [varchar](50) NULL, [state] [varchar](50) NULL, [country] [varchar](50) NULL, [registerdate] [datetime] NOT NULL, [editdate] [datetime] NULL, [confirmed] [bit] NULL CONSTRAINT [DF__Users__confirmed__4CC05EF3] DEFAULT ((0)), CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED ( [userid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_email] UNIQUE NONCLUSTERED ( [email] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO DBO.EDITPROFILE Code Snippet CREATE TABLE [dbo].[editprofile]( [editprofileid] [int] IDENTITY(1,1) NOT NULL, [headline] [varchar](50) NULL, [aboutme] [text] NULL, [userid] [int] NOT NULL, [date] [datetime] NOT NULL, [interests] [text] NULL, CONSTRAINT [PK_EditProfile] PRIMARY KEY CLUSTERED ( [date] ASC, [userid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] Tag: Missing Properties???
- Next
  - 1
    - SQL Restore Rights Hi Mike, Thanks for the quick response on that. I'll take a look at that BOL and see what I can come up with. Again, thanks for the quick help Brad Tag: Missing Properties???
  - 2
    - Multiple masks in a For Each File Loop container I like that plan, scb2376. Tag: Missing Properties???
  - 3
    - stored procedures compilation What version Are you sure they are not being reused Select * from master..syscacheobjects where sql like '%proc_name%' where usecounts = 1 will tell you if they are not. Tag: Missing Properties???
  - 4
    - Permissions for creating views Moved to Security Tag: Missing Properties???
  - 5
    - Cant install SQL Server 2005 on vista.. which edition of Vista u have I think the problem is with the edition of Vista.. it looks like SQL SErver 2005 EE is not supported... Madhu Tag: Missing Properties???
  - 6
    - GENERATE(): Is there an alternative? I have the following MDX using the above example as a template WITH SET MYROWS AS FILTER ( NONEMPTY ( ([Machine].[Machine Name].[Machine Name], [Patch].[Patch Name].[Patch Name]) * [Date].[Date]. MEMBERS ) AS MYSET, NOT (MYSET. CURRENT . ITEM (0) IS MYSET. ITEM ( RANK (MYSET. CURRENT , MYSET)). ITEM (0)) ) SELECT [Measures].[Patch Applied] ON 0, MYROWS ON 1 FROM [MyCube] Notice the tuple (Machine Name, Patch Name) The results of the above query are quite different from the similar query below where the tuple order is reversed. WITH SET MYROWS AS FILTER ( NONEMPTY ( ([Patch].[Patch Name].[Patch Name], [Machine].[Machine Name].[Machine Name]) * [Date].[Date]. MEMBERS ) AS MYSET, NOT (MYSET. CURRENT . ITEM (0) IS MYSET. ITEM ( RANK (MYSET. CURRENT , MYSET)). ITEM (0)) ) SELECT [Measures].[Patch Applied] ON 0, MYROWS ON 1 FROM [MyCube] Unfortunately, neither result from the above queries is desired. Anyone have a suggestion on how to modify the FILTER's search condition to work with a tuple Tag: Missing Properties???
  - 7
    - Activation procedure design I've been experimenting with Service Broker and was surprised at one aspect of the design: the interface to Activation stored procedures. I would have expected the queue to be a parameted passed to the procedure rather than having to hard code the queue query into the SP. In a system with lots of queues it seems plausible that the same activation procedure might want to be used with several queues. Any comments David. Tag: Missing Properties???
  - 8
    - Replacement for Access Forms As Madhu indicated, you can continue using Access for the Application and 'forms' while at the same time storing the data in SQL Server. In the Access documentation, look up and read about 'Access Data Projects' (ADP). Tag: Missing Properties???
  - 9
    - Setting Maximum Memory Arnie, I agree that 15 times 1024 is 15360, as soon as I enter any number in the field it changes back to the original number. Any ideas on that Tag: Missing Properties???
  - 10
    - SQL CE top/limit, unable to find WORKABLE solution that sounds interesting Erik thanks, but i'm not sure how i could substitute that for TOP as well as the WHERE queries, as each keyword has a unique field id which doesn't change according to parent id maybe i'd be better off implementing that as well as i'm fresh out of luck on this. do you know if TOP will be implemented in the near future Tag: Missing Properties???
  - 11
    - sql server 2005 Hi , i'm a C# developer. I want to upgrade this hotel app. i made from using access to SQL server. I got SQL server express 2005 and the management studio . Now i've been looking for a proper book for a whole lot of time. The last book i reviewed was Programming Microsoft SQL server 2005 . It says : "We assume you have basic, working knowledge of .NET programming in C# on the client and Transact-SQL (T-SQL) on the server. On the tools side, we assume you are familiar with the prior generation of SQL Server and .NET toolsspecifically, SQL Server Enterprise Manager, SQL Query Analyze r, and Visual Stdio .NET 2002 or 2003." ARRRG ! I'm good at C# , and ADO.NET , (datasets , adapters etc) , but i have no idea of what SQL server is all about. I 've never run any older version and never used any of thier dbs I know simple sql query statements like "SELECT * FROM <sometable> Where <somecondition> ". Oh and i have VS.NET 05 pro. I need a book that covers : installing a db on a pc , and mantaining it programatically via C# Adding tables , rows columns again , programatically working with relationships. Tag: Missing Properties???
  - 12
    - Merge Join - Output of Lookup as sorted field? In the merge join transformation, it will join on the originally specified join keys, which would be incorrect for me. So I'm not sure how this would be correct Tag: Missing Properties???
  - 13
    - Config and Connection String dgrm44 wrote: I want to store my connection string in a configuration file, however when I create the config file the connection string password is not stored. I can manually edit my config file and add the password to my connection string but I am sure that BIDS has a better solution. What is the best practice for storing connection string passwords in my SSIS Configuration files Nope. You've got it figured out. BIDS doesn't store passwords. Tag: Missing Properties???
  - 14
    - Standard Edition Limits and Partitioning by Multiple Cubes Hello Edward. I am on my way of reading the book that you have participated in. I have a question on this problem but also related to history in the cube/dw. If I do a full process of a dimension in a cube with several partions, do I have to do a full process of each partition In this scenario I will have both SCD I and SCD II attributes for history. I will bet on that I will have to process all partitions as well. Is this true Kind regards Thomas Ivarsson Tag: Missing Properties???
  - 15
    - New features of Reporting Service in SQL 2008 Forgive me, but what is BOL I'm trying to find answers to this as well. Thanks! Michael Tag: Missing Properties???
  - 16
    - expressions based on subtotals Thanks for the feedback, I'll give it a try I'm actually trying to create report to emulate growth over period(OLAP) for an Informix datasource I want to see the difference of the yearly subtotals Still exploring options Tag: Missing Properties???

paulbihs

Has anyone tried to open a cube into Business Intelligence Studio and the properties for the database vanished (project menu, properties)

How do you get them back

Top

Re: Missing Properties???

paulbihs

still haven't figured this one out

Top

Re: Missing Properties???

Darren Gosbell

What property are you looking for

In project mode there is only the database name property, but if you are working in online mode even this does not appear to be available. But the description, account settings and translations properties are all available under the "edit database" option in both modes.

Top