Showing posts with label certain. Show all posts
Showing posts with label certain. Show all posts

Wednesday, March 28, 2012

Is it possible to limit resources by login?

Is it possible in SQL 2005 to set a limit on resources to certain logins. In other words throttle down some users and therefore increase the priority of others?

SQL 2005 does not have the ability to limit resources based on logins.

Monday, March 26, 2012

Is it possible to hide a field or fields based on User Groups?

RS 2000

I have a report that has a few sensitive fields and would only like to show them to a certain AD group.

Is this possible?
Hi,

sure this is possible through custom .NET code. Implement your own Active Driectory checking class and use that within reporting Services. Based on this class you can make the textbox Visible or Hidden.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Friday, March 23, 2012

Is it possible to do this?

In an OLAP data source view I added ten additional fields to it based on certain conditions and it is used for the aggregation for a report. It is only stored as a number '0' or '1' so that I can sum it up for the report as a measure. It is working fine in the report. However I want to reperesent this ten additional fields on the X axis on a graph and I am not sure how to achieve this. It sounds like the reverse of the "pivot table", creating multiple rows (10 in my case) from a single rows of record. I have created a dimension with this ten fields. My question is how to merge this with another two new field, one to capture the column heading and the other to capture the value of it in an OLAP dataset. Thanks.Actually the MDX function I am looking for is "UNPIVOT" like in T-Sql.

Monday, March 12, 2012

Is it ok?

Here is what's happening to my database -
I have a table that shows about 40 dependencies in
via EM. Thereafter, when I add and delete certain columns
in the table, it shows about 8 dependencies. Even though
the columns I am adding/deleting don't have any reference
in dependencies.
In this instance is it ok to use the application or its
a matter of concern. How do I resolve this?
Thank you,
-Linda
Are these dependencies other tables? Perhaps the referential integrity
constraints were defined that way?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Is it ok?

Here is what's happening to my database -
I have a table that shows about 40 dependencies in
via EM. Thereafter, when I add and delete certain columns
in the table, it shows about 8 dependencies. Even though
the columns I am adding/deleting don't have any reference
in dependencies.
In this instance is it ok to use the application or its
a matter of concern. How do I resolve this?
Thank you,
-LindaAre these dependencies other tables? Perhaps the referential integrity
constraints were defined that way?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Is it ok?

Here is what's happening to my database -
I have a table that shows about 40 dependencies in
via EM. Thereafter, when I add and delete certain columns
in the table, it shows about 8 dependencies. Even though
the columns I am adding/deleting don't have any reference
in dependencies.
In this instance is it ok to use the application or its
a matter of concern. How do I resolve this?
Thank you,
-LindaAre these dependencies other tables? Perhaps the referential integrity
constraints were defined that way?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.