LIMITs on MIRROR with SQL Server SE

Hi folks. I'm trying to clear up some licensing confusion I"ve come across. First, if I use MIRROR on SS SE I am limited to a single REDO thread and Sycn mode. I see that on the Web. Will the singel REDO thread hurt the ability for the Secondary to keep up? Any one done any tests?

My confusion comes from a document that came across my desk a long time ago that showed that if you use MIRROR on SQL Server SE you are limited to 4 processors for the entire cluster. So if you wanted a balanced failover you would have to have two 2-ways in essence. Is this true? Is it not longer true? I can't seem to find any mention of this....did someone give me bad advice? Help! Thanks.

Licensing will not hurt any performance, only the number of transactions will have the recovery of REDO and UNDO process during the recovery.

|||In standard edition you wont get parallel redo and database snapshots features in the case of database mirroring.

Limited User Rights

Hi All,
How can I give the user view rights only?How can I give the user view rights only?I wouldn't grant them any other permissions.

-PatP|||I agree. But what command do I use to do that?|||I wouldn't grant them any other permissions.

-PatP

Don't you mean you would add the to the db_datareader database role?|||Make them members of the db_datareader and db_denydatawriter roles.

Limited user

I'd like to create a limited user on SQL Server 2005 to minimize any possible problems with my ASP.NET 2.0 website. My question is how limited can I make that user? What exactly does it need to be able to do?

(In case it makes a difference, my site utilizes membership, profiles, and roles, as well as some custom tables and stored procedures that I created.)

Thanks in advance for any advice! :-)

I usually create a SQL Server login that only has Execute permission on the stored procedures that are needed to run the site. That way, they have no other permissions as far as SQL Server is concerned, which means that you are largely protected against SQL Injection through the stored procedures, and also by the fact that the user has no permissions to do anything but fire the stored procedures you allow them to execute.

There is no SQL in the app itself. It's restricted purely to stored procs.

|||

Thanks for the reply! Are there specific stored procedures that a typical user must have execute permission for or do they need to have permission to execute all of them? I'm really concerned about security so I'd like to keep things as limited as possible without removing functionality or causing errors.

|||

Since you are only likely to create stored procs in response to the needs of the site, the user will need execute permission on all of them. If you create a stored proc that returns data to the page but don't give the user permssions on it, your site will fail.

DO NOT grant the user blanket EXECUTE. Grant execute on each proc individually eg

CREATE PROCEDURE MyProc

AS
BEGIN
SELECT field 1 FROM table1
END
GO
Grant Execute On MyProc to MyUser
GO

You can almost think of it as the Page is the user. The page needs to be able to call certain procs in order to display/insert/edit data. So you give it permission to run the procs.

limited resultset without SP

I have a search query on my page. However, since the resultset may be very large, I want to retreive only those results that are currently shown on the gridview page.
Often a user won't browse through more than a couple of pages, so it's b-*** to send all the records to the client.
I know that with a sp you can define that you want to retrieve the first or second x records, but I want to do this with SQL...is that possible?You could put a TOP 100 or something in your search query and page them at the client side or if you want to use SQL to do the paging, you'd be doing the search over and over again for each page. You *could* get a few duplicate records. since, I am assuming you'd do a top 10 or 20 from the query to show them on the page and when you do the search again, you are starting fresh and there isnt an easy way to remember the previous search. unles you store the result set you first got into some table (you could put the spid in one column) and use the spid to get the next result set. Obviously you'd have to worry about cleaning up the table periodically in such a case.

Limited Remote Login db access

I have connected my desktop and laptop computer at home, on my desktop I have a series of db's under my default named instance <computername>/sqlexpress and I have created access logins using windows auth. When I connect to the desktop from the laptop using tcp:<computername>\sqlexpress\userid I can only see the system db's...I am trying to view adventure works, which I can see on the desktop fine using the same login...any ideas?

Thanks,

Rob

Do you have a domain controller and home network?

If not, then you must create use SQL logins -you cannot use Windows authentication without an Active Directory (domain controller).

|||

I don't even know what those things mean.

How would I go about doing this with SQL logins?

Rob

|||

I suggest you follow the steps under "To configure AdventureWorks to work with Web server controls" on the following page from the Books Online.

http://msdn2.microsoft.com/en-us/library/ms310325(vs.80).aspx

Hopefully this helps,

John

|||

So I read over the link provided...

I have completed the first part and added it to the server. I can access the database on my desktop machine, when I login from the laptop however (using the same windows login) I can't access to database...do I need to also add something to make it accessible remotely? I don't really understand what "configure AdventureWorks to work with Web server controls
" means..

Rob

|||

These resources might help.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||

I have done this...as I stated before I can connect fine its just that I can't see anything other than system db's...I imagine I'm missing something stupid, like perhaps I didn't configure the login correctly?

Rob

|||

The login needs to be provided permission to access the databases.

Add the login to the appropriate database role.

|||

Ok first...I am running XP home on both the desktop and laptop...and the logins are windows auth.

if I want full access from the remote connection, where do I change the role of the login? is it in the login menu or the databases menu?

Rob

|||

Look back at the first response given to your problem.

Windows authentication will not work in your situation -you do not have a domain controller.

You will need to establish SQL Logins in each server, and assign permissions accordingly.

Look in Books Online about creating SQL Logins.

Limited Remote Login access

Hello all,

I'm very new to this so excuse my naiveity...I have connected my desktop and laptop computer at home, on my desktop I have a series of db's under my default named instance <computername>/sqlexpress and I have created access logins using windows auth. When I connect to the desktop from the laptop using tcp:<computername>\sqlexpress\userid I can only see the systemdb's...I am trying to view adventure works, just to see how this remote connection stuff works...any ideas?

Thanks,

Rob

See my response to your post in the 'Data Access' forum.

Limited Query Builder in sql2005 sms

Can any body point me in the right direction before i pull all my hair out, (not much left).

Moving from sql 2000 to 2005, yes very pretty, but all i want 2do is quickly query a table, like u could in 2000 by right click the table name and select Query, my experiance of 2005 has been very frustrating, why remove useful features, not impressed.

anyway

Is it possible to invoke, from within the sql2005 sms, the Query Builder that is used in the Report Designer as this builder has 100% more functionality than the cut down version that comes standard in the very expensive sql2005 sms.

Any ideas?

Cheers

First, let me respond to clarify a 'mis-statement':

the very expensive sql2005 sms

SSMS is suprisingly enough, included with SQL Server. It is NOT sold separately, there is not a ''price' for SSMS.

Now, if you wish to use the query builder function, similar to the Access/Excel/SQL 2000 Query Builder, it is still available.

Unfortunately, it doesn't have a dedicated menu entry. Hopefully, that will be corrected in a future release.

To use the query builder functionality, follow these steps (grumble if you want, but these are the steps...):

Right-click on a table, select [Open Table] The table will open in Grid format. If it is a large table, it could take some time, so you may wish to click on the 'Red' stop button in the bottom of the data pane. Then, in the toolbar, on the left, will be icons for the Diagram, Criteria, and SQL panes. Choose the ones you desire. Then, when your query is constructed, click on the [Execute SQL] button (the red exclamation mark).|||

Thank you for your condesending reply, nice to see you didnt actualy answer my question. in fact after a bit of browsing on and off this site this same limitation towards productivity has been brought up many times without being recified, as far back as 2005, your instructions are typical of the vacuum packed training many "experts" seem to excel in. if i opend a table for query like you suggest, a table that could have over 500,000,000 records in it, good use of server resources that, once ive managed to cancel the request, after about 10 clicks i could get a visual query editor of sorts, but i can only open that table once, very useful, we also get a "change type" button thats never active, start typing "insert into <tablename>" into the sql pain and the columns change in the criteria pain like as you would get if the could select "change type". As ive said previously these limitations were highlight by other users as far back a s2005, we still seem to be waiting for a decent interface.

As a paying customer, when i buy software, i receive, if im lucky, a cd to install, this cd installs the software I've purchased, usually, as far as im conserned the software that gets installed is what ive paid for, it dosent tell me this bit is free, or that bit is free, so give the, its free, what do u expect attitude. The problems ive experianced after purchasing this expensive product seems to have been shared by many within this forum, without be rectified. but not to worry it will all be sorted in the next version that us punters will have to pay up for again.

nice touch about the shoes, but when i buy a new pair of shoes, i pay decent money for them, because i can, and i get a pair that are as comfortable as my old ones, they have been Well designed and tested propely and are fit for purpose. glad i dont wear m$ shoes.

thanks again for you help and suggestions, your a credit to your profession! in my opinion.

|||The product can always can be as good as the responses from the field are. Microsoft introduced the http://connect.microsoft.com portal where customer can suggest new features and put up bugs which they encountered. These sites are monitored by the product teams, in fact they are doing periodic rounds to discuss effort for changes and impact on the product for bringing updates / feature in Serverice Releases / Service Packs. Feel free to post a connect suggestion and you will see that it will be picked up and answered soon.

Jens K. Suessmeyer

http://www.sqlserver2005.de

LIMITED PIE CHART LEGEND ?

Hi,
I have a problem with Reporting services pie chart legend which is
limited in character
Does it exists a solution to write more text on pie charts legend ?
Thx !Hi rebeupaname,
Depending upon what you're after, you could either:
1) drop a textbox onto the chart and position it near the legend to add
supplemental info, or
2) use an expression for the series label to change the text inside of
the legend
Does this help?
Matt A
Reporting Services Newsletter at www.reportarchitex.com
rebeuapaname@.hotmail.com wrote:
> Hi,
> I have a problem with Reporting services pie chart legend which is
> limited in character
> Does it exists a solution to write more text on pie charts legend ?
> Thx !|||Thank you vert much, i have resolved the problem
But another limitation of PIE CHARTS make me loose time :
I'am looking for a maner to GROUP little values of a graph in one
categorie called "OTHER". For example all value under 1% will be
grouped in the "OTHER" category
Do you understand what i want to say ?
Thx

limited permissions on test server for developers

I want to give developers limited permissions on a test sql server 2005
database. Basically they should be able to add columns to a table or
modify a columns datatype.
Create table and view definition have been granted to the developer
accounts (along with insert/update/delete), but they receive the
following error when trying to modify a table schema:
table dbo.ppir is set to read only, user doesn't have enough rights on
this table.
I am fairly new to sql server, but I did do some searching to find an
answer. I would prefer not to give them db owner permissions if
possible.
Thanks,
Andyandy wrote:
> I want to give developers limited permissions on a test sql server 2005
> database. Basically they should be able to add columns to a table or
> modify a columns datatype.
>
You could add the accounts to the "db_ddladmin" role on the database.
Regards,
lucm|||Hi Andy
They will need ALTER TABLE permission on the given table. See ALTER TABLE in
books online for more.
John
"andy" wrote:
> I want to give developers limited permissions on a test sql server 2005
> database. Basically they should be able to add columns to a table or
> modify a columns datatype.
> Create table and view definition have been granted to the developer
> accounts (along with insert/update/delete), but they receive the
> following error when trying to modify a table schema:
> table dbo.ppir is set to read only, user doesn't have enough rights on
> this table.
> I am fairly new to sql server, but I did do some searching to find an
> answer. I would prefer not to give them db owner permissions if
> possible.
> Thanks,
> Andy
>|||This worked. Thanks for the help
Andy
On Nov 16, 12:45 pm, "lucm" <l...@.iqato.com> wrote:
> andy wrote:
> > I want to give developers limited permissions on a test sql server 2005
> > database. Basically they should be able to add columns to a table or
> > modify a columns datatype.You could add the accounts to the "db_ddladmin" role on the database.
> Regards,
> lucm

limited permissions on test server for developers

I want to give developers limited permissions on a test sql server 2005
database. Basically they should be able to add columns to a table or
modify a columns datatype.
Create table and view definition have been granted to the developer
accounts (along with insert/update/delete), but they receive the
following error when trying to modify a table schema:
table dbo.ppir is set to read only, user doesn't have enough rights on
this table.
I am fairly new to sql server, but I did do some searching to find an
answer. I would prefer not to give them db owner permissions if
possible.
Thanks,
Andy
andy wrote:
> I want to give developers limited permissions on a test sql server 2005
> database. Basically they should be able to add columns to a table or
> modify a columns datatype.
>
You could add the accounts to the "db_ddladmin" role on the database.
Regards,
lucm
|||Hi Andy
They will need ALTER TABLE permission on the given table. See ALTER TABLE in
books online for more.
John
"andy" wrote:

> I want to give developers limited permissions on a test sql server 2005
> database. Basically they should be able to add columns to a table or
> modify a columns datatype.
> Create table and view definition have been granted to the developer
> accounts (along with insert/update/delete), but they receive the
> following error when trying to modify a table schema:
> table dbo.ppir is set to read only, user doesn't have enough rights on
> this table.
> I am fairly new to sql server, but I did do some searching to find an
> answer. I would prefer not to give them db owner permissions if
> possible.
> Thanks,
> Andy
>
|||This worked. Thanks for the help
Andy
On Nov 16, 12:45 pm, "lucm" <l...@.iqato.com> wrote:
> andy wrote:
> Regards,
> lucm

limited permissions on test server for developers

I want to give developers limited permissions on a test sql server 2005
database. Basically they should be able to add columns to a table or
modify a columns datatype.
Create table and view definition have been granted to the developer
accounts (along with insert/update/delete), but they receive the
following error when trying to modify a table schema:
table dbo.ppir is set to read only, user doesn't have enough rights on
this table.
I am fairly new to sql server, but I did do some searching to find an
answer. I would prefer not to give them db owner permissions if
possible.
Thanks,
Andyandy wrote:
> I want to give developers limited permissions on a test sql server 2005
> database. Basically they should be able to add columns to a table or
> modify a columns datatype.
>
You could add the accounts to the "db_ddladmin" role on the database.
Regards,
lucm|||Hi Andy
They will need ALTER TABLE permission on the given table. See ALTER TABLE in
books online for more.
John
"andy" wrote:

> I want to give developers limited permissions on a test sql server 2005
> database. Basically they should be able to add columns to a table or
> modify a columns datatype.
> Create table and view definition have been granted to the developer
> accounts (along with insert/update/delete), but they receive the
> following error when trying to modify a table schema:
> table dbo.ppir is set to read only, user doesn't have enough rights on
> this table.
> I am fairly new to sql server, but I did do some searching to find an
> answer. I would prefer not to give them db owner permissions if
> possible.
> Thanks,
> Andy
>|||This worked. Thanks for the help
Andy
On Nov 16, 12:45 pm, "lucm" <l...@.iqato.com> wrote:
> andy wrote:
> Regards,
> lucm

limited number of connections to SQLMobile?

Using System.Data.SqlClient is there a limit to the number of connections an application can have to a SQLMobile dB?

If you have a look at the url below, it says "A device can only have a small number of connections to an instance of SQL Server at any time"

Does this mean 2, or 8 or what?
Should a app try to use only 1 connection throughout, or can we get away with 2-3?
Is this the same on WM5.0/PPP2003?

Any advice in this area much appreciated!

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_sqlclient_705.asp

p.s. I'm not interested in connection pooling!

Connections to SQL Mobile have little in common with connections to SQL Server. First, the managed provider for SQL Mobile is System.Data.SqlServerCe, which is a different creature than the SqlClient you refer to in your post (which is used to connect to an instance of SQL Server).

Yes, you can have multiple connections to a SQL Mobile database. System.Data.SqlServerCe does not support pooling or encryption of connection strings however.

I am not aware of a limit to the number of SqlCeConnections you can have open against a single SQL Moble database, but if there is one it is more than a dozen as I have done benchmarking with more than this.

Darren

Limited number of assemblies available in Visual Studio SQL Server Projects

Hi,

When starting a SQL Server Project in Visual Studio, there are a very limited number of assemblies available to reference. Does anyone know why?

Specifically I would like to use "Microsoft.AnalysisServices.AdomdClient". Does anyone know how I could do that?

Best Regards,

Johan ?hln,
IFS

Hi,

if you want more than these one, you have to register them in the GAC to see them in VS. The ones listed were intensivly tested by Microsoft not to produce any memory leaks being threadsafe etc. Additional (custom) resources have to be listed first for the computer and marked with the security policy level they need. "Doing the stack walk" while registering them at deployment time, SQL Server makes sure that called ressources reflect the at most the security settings of the registered assembly.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

Thanks for your answer.

Microsoft.AnalysisServices.AdomdClient is already registered in the GAC, but I don't see it in Visual Studio. What else do I have to do to be able to reference it?

From what I can see it has unrestricted permissions in .NET Runtime Security Policy.

Best Regards,

Johan ?hln

|||

Hi Johan,

As the previous person mentions, the assemblies that are available to references in a sql server project are restricted. I think what this person meant to say is that these system assemblies are loaded from the GAC by sql server, yet this has nothing to do with when you wish to use an unsupported system assembly.

Note here about my terminology, system assembly = .Net BCL, user assembly = custom assembly.

You are wishing to reference an unsupported system assembly in sql server, this can be attempted (I say this because depending upon what the individual assembly tries to do, even in unsafe it will not be allowed to run when called upon and it's corresponding app. domain will be unloaded).

To do this, first run a create assembly statement referencing the adomd client assembly. Second, create a new regular class library project and add your reference to the adomd client libary. Then build the class in VS. Next, run the create assembly statement for your newly created class.

*You may have to set lower permission sets on the adomd client depending upon its attributes etc. There is a concept known as Host Protection Attributes (HPAs) which help sql server in determing which managed libaries should be allowed to execute within the hosted clr context. Basically, you may have to set the adomd client to unsafe it is "threatening" enough. But again, even with unsafe, sql server will only allow so much to occur aka you cannot kill sqlservr.exe from sqlclr code.

Hope this helps,

Derek

|||

Two additional points:

1. Actually, VS has a nice feature where if the assembly you're looking for is already registered in your SQL Server database, then you can reference it directly from your VS Database Project, even if it is a custom assembly or one that is not on the supported system assemblies list. It should show up normally under "Add Reference".

2. There are extremely few things that do not work in unsafe permission set, and the restrictions that are in place weren't done with reliability in mind. There are a number of ways to effectively kill your SQL Server process when running under unsafe, if you wanted to.

Steven

|||Noted on the unsafe being able to kill sqlservr. I did find that HPAs are only used in safe and unsafe perm buckets.|||i meant safe and external access :)|||

Thank you for your answers.

It seems impossible to reference AdomdClient from a SQL Server assembly:

It cannot be added using CreateAssembly|||

Johan ?hln wrote:

It seems impossible to reference AdomdClient from a SQL Server assembly:

It cannot be added using CreateAssembly

|||

TITLE: Microsoft SQL Server Management Studio Express

Create failed for SqlAssembly 'Microsoft.AnalysisServices.AdomdClient'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+SqlAssembly&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

CREATE ASSEMBLY failed because type 'ShilohSchemas' in safe assembly 'Microsoft.AnalysisServices.AdomdClient' has a static field 'shilohSchemas'. Attributes of static fields in safe assemblies must be marked readonly in Visual C#, ReadOnly in Visual Basic, or initonly in Visual C++ and intermediate language.
Warning: The SQL Server client assembly 'microsoft.analysisservices.adomdclient, version=9.0.242.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment. (Microsoft SQL Server, Error: 6211)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=6211&LinkId=20476

BUTTONS:

OK

|||

I have solved this. It works if you create it as unsafe.

Thanks for your answers,

Johan

Limited length of text data type

I cannot put the very long long text into the fields that
have text data type how can I extends the length of this
data type?
Thanks
Hi,
Did you meant that you got problems while retrieval. If it is a problem with
retrieval then use the below commands:-
SET TEXTSIZE { number }
select @.@.textsize
See books online for more details.
Thanks
Hari
MCDBA
"kwan" <anonymous@.discussions.microsoft.com> wrote in message
news:9d2e01c48675$7273bde0$a601280a@.phx.gbl...
> I cannot put the very long long text into the fields that
> have text data type how can I extends the length of this
> data type?
> Thanks
|||How are you trying to "put" the very long long text? Have you tried an
INSERT statement in Query Analyzer or from an application?
Are you sure the problem is in inserting the data, and not in
retrieving/viewing it?
http://www.aspfaq.com/
(Reverse address to reply.)
"kwan" <anonymous@.discussions.microsoft.com> wrote in message
news:9d2e01c48675$7273bde0$a601280a@.phx.gbl...
> I cannot put the very long long text into the fields that
> have text data type how can I extends the length of this
> data type?
> Thanks

Limited Functionality on Side-by-Side Install

We are testing our SQL 2000 db on a test box in which we loaded SQL 2000 first and then installed SQL Server 2005 Enterprise Trial edition side by side. I am trying to execute new functions in SQL 2005 against the Northwind db to test and these functions are not recognized. What am I missing?

What specific functions are you trying to run? I'm also moving this thread to T-SQL so they can help answer your questions.

Thanks,
Sam

|||

Older sample databases like pubs, northwind are in 80 compatibility mode. So newer keywords or certain syntax of statements or functions behave differently in that compatibility mode. You can either change the compatibility mode of the northwind database by running "sp_dbcmptlevel 'Northwind', '90" or create a new database which will automatically be in 90 compat mode or use the new AdventureWorks sample database. For more details on older compatibility modes and what it affects, see the topic below:

http://msdn2.microsoft.com/en-us/library/ms178653.aspx

limited connections on the developer edition

hi all,

I installed sql server developer edition on

xp box. created a new ssis project and

then when i right click on control flow

then click new connections

i see only limited connection available.

how can i install the other connection option

such as oledb. etc.

thanks

joey

got it

my integration service

is running with limited rights

limited # of db's?

Running SQL 2000 Enterprise Edition. Is there a limit to the number of
databases one installaion can support, other than disk space/hardware
limitations?
32,767 per instance. In BOL under 'maximum capacity specifications' there is
a list of this type of data.
Rgds,
Paul Ibison (SQL Server MVP)

limited # of db's?

Running SQL 2000 Enterprise Edition. Is there a limit to the number of
databases one installaion can support, other than disk space/hardware
limitations?32,767 per instance. In BOL under 'maximum capacity specifications' there is
a list of this type of data.
Rgds,
Paul Ibison (SQL Server MVP)

Limitations of MeasureExpression

I have a many to many dimensional problem that I am trying to solve.

Am I right in thinking that MeasureExpression is limited to a simple expression such as [value]*[percantage] and cannot cope with [value]*[percentage1]*[percentage2]?

What I am trying to achieve is similar to the example under the heading Measure Expressions and Many-to-Many Dimensions in the article http://msdn2.microsoft.com/en-US/library/ms345139.aspx. In this example there is a many to many relationship between Organisation and Store Sales; and the weighted [Amount] is calculated in the MeasureExpression as [Amount]*[Ownership].

They key difference in my scenario is that instead of a single many to many relationship between Organisation and Store Sales I have several relationships so I would need to have a calculation such as [Amount]*[Ownership]*[Sales Director Percentage].

Is there a way that MeasureExpression could support more complex calculations - or is there a better way to achieve this?

Thanks

Yes, the measure expressions are limited to A*B or A/B. You should check out Marco Russo's paper on many-to-many dimensions and see if there is anything in there you can use: http://www.sqlbi.eu/Default.aspx?tabid=80|||

Thanks for your input Michael. In fact I had come across that document the previous day, but it doesn't cover my particular scenario. The tricky bit is always that fact that there is a weighting to be applied to each of the many-to-many dimensions.

In the end I decided to handle this in the ETL by breaking down the fact table into constituent parts representing each unique combination and have SSAS aggregate only those needed for each calculation. It seems to me that SSAS is very good at aggregation, but not so good at apportioning values.

We live and learn ...

|||

What about this case:

create intermediate measure as AB = A * B and set its visible property to false

and than create your target measure as MyMeasure = AB * C

|||

I guess that would work in theory, but since I actually need A * B * C * D * E I would need three invisible measures and one visible one which seems a little clunky.

Having talked this through with a couple of other people I think the solution of breaking this down in the ETL process and having SSAS simply perform the aggregation seems to be the best approach.

Thanks.

|||

Hi,

you can try and use Calculated Measures (calculations).

The expressions here can take multiple measures, and also infact invoke .Net assemblies/ stored procedures.

Apart from that , you can use MDX and its array of functions.

check the MSDN site on Calculated Measures.

HTH

Regards

Limitaions of MSDE

Hi,
Is the MSDE database still limited to 2GB. If yes is that the size of the .mdf file ?
Thanks,
-VJHi,
I believe that it is the mdf file (I don't know why they would car about how large you log files are!). I assume that you know that size isn't the only limitation to MSDE. Try searching the MS site, as I know they have a section devoted to MSDE with some good links to available enterprise manager work-alikes, etc... Might also want to look at the express vesrion of SQL Server 2005. You can also search these forums for info on that. BRN..|||MSDE(micorosft data engine) is limited to 2gig in capacity, ten concurrent write users and with caching 2500 or more read users not very sure. You could get the developer edition and install it as a named instance and register the MSDE so you can manage it with Enterprise manager.
MDF(microsoft data file) is not the log file it is the data file, the log file is LDF(log data file) both files are in the Data subfolder in Microsoft SQL Server folder under programs.
And there is very little need to grow 2gig log file because you can always create a job to run DBCC ShrinkFile after long operations that can grow the log file. DBCC shrinkFile returns space less what SQL Server calls Active log. Hope this helps.|||

thanks guys. I got what I needed. Chreers.

-VJ

|||Hi,
I'm sure the original poster appreceates the info you were able to pass along re: MDSE. BTW, I (and I'm guessing the OP), know that the .ldf is the (a), log file for SQL Server/MSDE. My comment about MS not caring about how large a log file you could have implied that the size restriction must be on the .mdf (data), file. It's been a while since I set up my MSDE installation, but I recall that I had a tough time getting the mdf and ldf assigned to different drives. The MSDE didn't make that simple. I'm sure you know how much more effecient it is when the two file types are on seperate drives - even if both are on a IDE controller.
BTW, can you have multiple named instances of the server with the developer edition of SQL Server 2000, on the same licence? That would help in some testing I was planning. Thanks, BRN..|||Hi Brian,
I am sorry did not intend to offend you and I think you can install multiple licenses but not multiple instances because the developer edition is only $37.00 on the web. Try the thread below for more info. Hope this helps.
http://forums.asp.net/1076159/ShowPost.aspx|||

Hi,

Thanks for the link; I'll check it out. BRN..