Mozilla Firefox

The web interface for ReportServer does not work in Mozilla Firefox 1.0:
reports appear as blank pages.
Is this due to use of ActiveX controls in the browser, or is there some
other reason - and who's problem is it?
brianSomeone awhile back investigated this pretty extensively and I gather it has
to do with how the web interface was designed. It is not an active x
problem. If you want to provide support for Mozilla you will need to use
your own front end instead of the one provided by MS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Brian Smith" <bsmith@.NO.SPAM.schemiotics.co.uk> wrote in message
news:uwkkBk5OFHA.580@.TK2MSFTNGP15.phx.gbl...
> The web interface for ReportServer does not work in Mozilla Firefox 1.0:
> reports appear as blank pages.
> Is this due to use of ActiveX controls in the browser, or is there some
> other reason - and who's problem is it?
> brian

Moving tables between databases and setting alias

Due to bad programming techniques and legacy databases, my company has a large database with all the tables in it. I would like to start moving these tables out of the database and into more appropriately named databases.

I was wondering if there was a way to set an alias up so that, when the table is moved, there will be no problems with out code still trying to access the table from the old database.

Maybe an example is the best way to explain this. Lets say we have a DB_Company database with table T_Customers, T_Suppliers, etc.
Now, as the company grows, we decide to create a dedicated database for all the customers. So we create a database DB_Customers and move the T_Customers table into it.
The problem is that they may be some code that is still trying to access the DB_Company.T_Customers table. Is there a way of setting an alias up so that, when someone tries to access the DB_Company.T_ Customers table, he is automatically redirected to the DB_Customers.T_Customers?

Hope that's not too confusing :-(

Jag

Hi jagdipa,

I don't think (AFAIK) you can do an alias to the tables...But you can first check the db objects w/c depends on the table, by using the sp_depends '<tablename>' stored proc. and will display to you its dependencies.. and change as needed..

or

after getting the dependcies wrap the table into a view so that you don't need change the name in the dependencies..

HTH

|||Thanks Bonskijr, but that its not possible.

I am a great believer in using views and never accessing the tables directly. Unforuanetly, the people before me did not. There could be many pages that access the tables directly.

Edit: I just read your post properly. The second idea is very good. I will have a look into that. Thanks alot.

Moving SQL Server to a new domain

All,
I have the task of separating our AD into 2 domains due to selling one of
our companies off. Unfortunately, one of the SQL 2000 servers belongs to this
company and that needs to be moved to the new domain.
The machine in question is a windows 2003 server running SQL server 2000
sp3a. There are 3 databases on the machine, and there are domain accounts
that have permission to 2 of them.
The project will include creating the new domain and creating a trust
between them so that I can migrate user accounts with SID history, for
Exchange reasons.
How would I be able to move the server to the new domain? Do I just use the
Active Directory Migration Tool to move the server to the domain after the
user accounts have been moved, then assign the new domain user accounts to
the databases?
Any help would be appreciated
Thanks
Andoni
"Andoni" <Andoni@.discussions.microsoft.com> wrote in message
news:D3F1B0F8-53BA-43DB-8EB3-6A1E5C40AE33@.microsoft.com...

> How would I be able to move the server to the new domain? Do I just use
> the
> Active Directory Migration Tool to move the server to the domain after the
> user accounts have been moved, then assign the new domain user accounts to
> the databases?
After you migrate everything with ADMT, bounce the server into the new
domain, reset the service account and I do not believe you need to do
anything with login's based on domain accounts because they are sid based.
|||Hi Jason,
I have migrated the server, the user accounts were migrated beforehand. By
reset service account do you mean if SQL runs under a domain account? Also,
In the enterprise manager under security/logins, it's still showing domain
users in the old domain instead of the new one. will i need to create new
domain users?
thanks
A
"jason" wrote:

> "Andoni" <Andoni@.discussions.microsoft.com> wrote in message
> news:D3F1B0F8-53BA-43DB-8EB3-6A1E5C40AE33@.microsoft.com...
>
> After you migrate everything with ADMT, bounce the server into the new
> domain, reset the service account and I do not believe you need to do
> anything with login's based on domain accounts because they are sid based.
>
sql

Moving SQL Server to a new domain

All,
I have the task of separating our AD into 2 domains due to selling one of
our companies off. Unfortunately, one of the SQL 2000 servers belongs to this
company and that needs to be moved to the new domain.
The machine in question is a windows 2003 server running SQL server 2000
sp3a. There are 3 databases on the machine, and there are domain accounts
that have permission to 2 of them.
The project will include creating the new domain and creating a trust
between them so that I can migrate user accounts with SID history, for
Exchange reasons.
How would I be able to move the server to the new domain? Do I just use the
Active Directory Migration Tool to move the server to the domain after the
user accounts have been moved, then assign the new domain user accounts to
the databases?
Any help would be appreciated
Thanks
Andoni"Andoni" <Andoni@.discussions.microsoft.com> wrote in message
news:D3F1B0F8-53BA-43DB-8EB3-6A1E5C40AE33@.microsoft.com...
> How would I be able to move the server to the new domain? Do I just use
> the
> Active Directory Migration Tool to move the server to the domain after the
> user accounts have been moved, then assign the new domain user accounts to
> the databases?
After you migrate everything with ADMT, bounce the server into the new
domain, reset the service account and I do not believe you need to do
anything with login's based on domain accounts because they are sid based.|||Hi Jason,
I have migrated the server, the user accounts were migrated beforehand. By
reset service account do you mean if SQL runs under a domain account? Also,
In the enterprise manager under security/logins, it's still showing domain
users in the old domain instead of the new one. will i need to create new
domain users?
thanks
A
"jason" wrote:
> "Andoni" <Andoni@.discussions.microsoft.com> wrote in message
> news:D3F1B0F8-53BA-43DB-8EB3-6A1E5C40AE33@.microsoft.com...
> >
> > How would I be able to move the server to the new domain? Do I just use
> > the
> > Active Directory Migration Tool to move the server to the domain after the
> > user accounts have been moved, then assign the new domain user accounts to
> > the databases?
> After you migrate everything with ADMT, bounce the server into the new
> domain, reset the service account and I do not believe you need to do
> anything with login's based on domain accounts because they are sid based.
>