Changing the SQL SErver DOmain

Hello,
Anybody knows what's the effects caused by a Server Domains Change?
I'm planning to change a Domain of my SQL Server that actually has a trust
with the current Domain of this server.
I think that I don't need to do nothing after this change. I'm correct?
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200703/1
Hello,
Take a look into the google archive for the similar topic.
[url]http://groups.google.com/group/microsoft.public.sqlserver.connect/browse_frm/thread/3533c9535e06f49e/b6ea4289a0ead18c?lnk=st&q=changing+sql+server+doma in&rnum=19&hl=en#b6ea4289a0ead18c[/url]
Thanks
Hari
"julianohorta via droptable.com" <u13014@.uwe> wrote in message
news:6e89b9509fcf6@.uwe...
> Hello,
> Anybody knows what's the effects caused by a Server Domains Change?
> I'm planning to change a Domain of my SQL Server that actually has a trust
> with the current Domain of this server.
> I think that I don't need to do nothing after this change. I'm correct?
> Thanks
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200703/1
>
sql

Changing the SQL SErver DOmain

Hello,
Anybody knows what's the effects caused by a Server Domains Change?
I'm planning to change a Domain of my SQL Server that actually has a trust
with the current Domain of this server.
I think that I don't need to do nothing after this change. I'm correct?
Thanks
Juliano Horta
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1Hello,
Take a look into the google archive for the similar topic.
http://groups.google.com/group/microsoft.public.sqlserver.connect/browse_frm/thread/3533c9535e06f49e/b6ea4289a0ead18c?lnk=st&q=changing+sql+server+domain&rnum=19&hl=en#b6ea4289a0ead18c
Thanks
Hari
"julianohorta via SQLMonster.com" <u13014@.uwe> wrote in message
news:6e89b9509fcf6@.uwe...
> Hello,
> Anybody knows what's the effects caused by a Server Domains Change?
> I'm planning to change a Domain of my SQL Server that actually has a trust
> with the current Domain of this server.
> I think that I don't need to do nothing after this change. I'm correct?
> Thanks
> Juliano Horta
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1
>

Changing the SQL SErver DOmain

Hello,
Anybody knows what's the effects caused by a Server Domains Change?
I'm planning to change a Domain of my SQL Server that actually has a trust
with the current Domain of this server.
I think that I don't need to do nothing after this change. I'm correct?
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200703/1Hello,
Take a look into the google archive for the similar topic.
http://groups.google.com/group/micr...6ea4289a0ead18c
Thanks
Hari
"julianohorta via droptable.com" <u13014@.uwe> wrote in message
news:6e89b9509fcf6@.uwe...
> Hello,
> Anybody knows what's the effects caused by a Server Domains Change?
> I'm planning to change a Domain of my SQL Server that actually has a trust
> with the current Domain of this server.
> I think that I don't need to do nothing after this change. I'm correct?
> Thanks
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200703/1
>

changing existind dimension datasource

Anybody knows how to change a the datasource for an existing Dimension?

I've tryed deleting them but since i've imported the cube from a diferent server, if I try to delete the dimension it is also deleted from the cubes.

thanks for the help in advance.

Hugo

Not sure if your question is for AS2000 or AS2005.

If it is AS2000, you can change the datasource connetion string. That means it will affect other objects that pointing to this datasource.

If it is AS2005, you should add a table from different datasource and create cube and dimension as usual. Steps are:

1) Create a primary datasource (where you cube is) and dsv

2) Create a secondary datasource (where your dimension is)

3) In dsv designer, select Add\Remove tables. You see the dialog which has darasource drop down box. Select the secondary datasource and add the dimension table to dsv.

4) You may want to create relationship between fact table and dimension table before you create cube and dimension. After that, just now cube wizard as usual.

Hope this helps

Ken

|||

ok. thanks Ken for the info.

My SQL is a 2k.- Thanks for your quick response. I've tried it and it works.

Changing database owner

Hi,
Could someone of you knows how to change the database owner?
Thanks in advance.
BorisPerhaps sp_changedbowner is what you are looking for. You can read some =information on this stored procedure within Books Online (within the SQL =Server program group).
-- Keith
"Boris Condarco" <bcondarco@.hotmail.com> wrote in message =news:upgUMvHpDHA.488@.tk2msftngp13.phx.gbl...
> Hi,
> > Could someone of you knows how to change the database owner?
> > Thanks in advance.
> > Boris
> >|||You can use sp_changedbowner. You can find more information
on this system stored procedure in books online.
-Sue
On Thu, 6 Nov 2003 11:42:35 -0400, "Boris Condarco"
<bcondarco@.hotmail.com> wrote:
>Hi,
>Could someone of you knows how to change the database owner?
>Thanks in advance.
>Boris
>