Mirror database and users

We are mirroring to a server used to generate reports and datamarts. Is
there a technique of synching up the database users with the principle
server?
We use snapshots to generate reports and datamarts off of.Best approach is to make sure the logins on that other SQL Server has the co
rrect SID in the first
place. Search KB for sp_help_revlogin and check it out. If that isn't an opt
ion for you, you need to
do something with sp_change_users_login, something you run after the failove
r has taken place...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kevin Jackson" <kjackson@.powerwayinc.com> wrote in message
news:ekB9rBEeGHA.1320@.TK2MSFTNGP04.phx.gbl...
> We are mirroring to a server used to generate reports and datamarts. Is t
here a technique of
> synching up the database users with the principle server?
> We use snapshots to generate reports and datamarts off of.
>

Mirror database and users

We are mirroring to a server used to generate reports and datamarts. Is
there a technique of synching up the database users with the principle
server?
We use snapshots to generate reports and datamarts off of.Best approach is to make sure the logins on that other SQL Server has the correct SID in the first
place. Search KB for sp_help_revlogin and check it out. If that isn't an option for you, you need to
do something with sp_change_users_login, something you run after the failover has taken place...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kevin Jackson" <kjackson@.powerwayinc.com> wrote in message
news:ekB9rBEeGHA.1320@.TK2MSFTNGP04.phx.gbl...
> We are mirroring to a server used to generate reports and datamarts. Is there a technique of
> synching up the database users with the principle server?
> We use snapshots to generate reports and datamarts off of.
>sql

minvalue and maxvalue in sequence

Hello everyone:

I try to create a sequence with following requirements:

create a sequence that will generate integers starting with the value 9. Each value should be three less than the previous value generated. The lowest possible balue the sequence should be allowed to generate is -1, and it should not be allowed to cycle.

I think values generated by this sequence are 9, 6, 3, 0

my sql statement goes like this:

SQL> create sequence MY_FIRST_SEQUENCE
2 increment by -3
3 start with 9
4 minvalue -1
5 nocycle;
create sequence MY_FIRST_SEQUENCE
*
ERROR at line 1:
ORA-04004: MINVALUE must be less than MAXVALUE

I don't know what's the maxvalue in this squence. Should it be 9 if that's the case. why do I get a error message?

Plase give me some suggestio on how can I make this sequence work. Thanks!

sjgrad03
12-03Even without knowing anything about sequences, if this is a DESCENDING sequence and it STARTS WITH 9, then it is logical that its MAXIMUM VALUE is 9.

Your statement will be executed properly if you add MAXVALUE n, where n >= START_WITH_value. If it is not clear enough, here's an example:

CREATE SEQUENCE my_seq
START WITH 9
MAXVALUE 9
MINVALUE -1
INCREMENT BY -3;

or

CREATE SEQUENCE my_seq
START WITH 9
MAXVALUE 1000
MINVALUE -1
INCREMENT BY -3;

NOCYCLE is the default and it is not necessary to specify it.

Read more about creating Oracle sequences here (http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6015.htm).

Minimizing Locking Question

Hello all,
I am working on an Access 2000 project that is used to generate reports on archived sales data. This app uses linked tables that are pointing to some SQL 2K tables. Some of the queries are large and end up creating a table lock when executed, blocking all other users from using the app until it has finished executing the query. I would like to have queries that read data ignore this lock on the table but do not know of a way to do this using linked tables in Access 2000. I would use a NOLOCk table hint but need something else for this issue.
Any ideas?
ThanksWhat else do you need other than NOLOCK with linked tables?

Migration Wizard Error

Hi !,

The migration of OLAP cubes with aggregations to SSAS, generate the following error:

"Another 'Aggregation' object has the '31 3314' ID."

and then the migration process stops.

The dimension structure is changed during the process and a posible solution is deleting all the aggregation before migration.

But I would like to know if it is really a bug or there is a known reason for getting such error.

Thanks in advance !!!

Leandro

Looks like you somewhow got 2 aggregations in AS2000 with the same name.

Now, when trying to migrate AS2005 trying to create aggregations for you and stops at the point when meets aggregation with the duplicate name.

Several options.

Try and get rid of the duplicate aggregation using Parition Manager sample application shipped with SQL Server 2000 resource kit.

Try re-desingn aggregations using Analysis Manager.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

That's right.

So Instead of migrating directly from a production server, would it be better to copy AS2000 objects to another database/server, clean all duplicate aggregations, and then run the migration wizard ?.

We have high volume partitions, but fortunately users dont browse freely the cubes. An application runs a lot of specific MDX queries. So we decided to design aggregations manually because generating an aditional one was too costly and it was better to define a lower-level aggregation that serves two similar types of MDX queries, than adding two aggregations by using the Usage Based Optimization.

I dont know If the last algorithm was optimized to support such type of aggregations design criteria.

Thanks very much.

Leandro

Thanks Edward,

|||

I would definitely try make sure that any modifications are done in the test environment.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights