rename table

Hello,
I want to rename a table but this table is used into storage procs and
views. How could I rename this table in order to the new name changes into
storage pros and views?
Thanks
LN
You can't, you will have to manually change the stored procedures and views.
You can however create a view with the same name as the old table that does
a straightforward select of all the relevant columns, that will save you
from having to update everything.
Jacco Schalkwijk
SQL Server MVP
"hlne" <Helene.Zouari@.isped.u-bordeaux2.fr> wrote in message
news:OIOxLRfsEHA.3788@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I want to rename a table but this table is used into storage procs and
> views. How could I rename this table in order to the new name changes into
> storage pros and views?
> Thanks
> LN
>

rename table

Hello,
I want to rename a table but this table is used into storage procs and
views. How could I rename this table in order to the new name changes into
storage pros and views?
Thanks
LNYou can't, you will have to manually change the stored procedures and views.
You can however create a view with the same name as the old table that does
a straightforward select of all the relevant columns, that will save you
from having to update everything.
--
Jacco Schalkwijk
SQL Server MVP
"hélène" <Helene.Zouari@.isped.u-bordeaux2.fr> wrote in message
news:OIOxLRfsEHA.3788@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I want to rename a table but this table is used into storage procs and
> views. How could I rename this table in order to the new name changes into
> storage pros and views?
> Thanks
> LN
>

rename table

Hello,
I want to rename a table but this table is used into storage procs and
views. How could I rename this table in order to the new name changes into
storage pros and views?
Thanks
LNYou can't, you will have to manually change the stored procedures and views.
You can however create a view with the same name as the old table that does
a straightforward select of all the relevant columns, that will save you
from having to update everything.
Jacco Schalkwijk
SQL Server MVP
"hlne" <Helene.Zouari@.isped.u-bordeaux2.fr> wrote in message
news:OIOxLRfsEHA.3788@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I want to rename a table but this table is used into storage procs and
> views. How could I rename this table in order to the new name changes into
> storage pros and views?
> Thanks
> LN
>sql

removing alternate snapshot location setting

I was using an "alternate snapshot
location" for the storage of my reinitilized
snapshot data. All those snap shots have
made it to the subscribers. I am now
wanting to go back to those pacakges and set
their snapshot location back to default
(basically the default dir on the
distributor). When I go back and check that
check box, it's not going to try to start a
new snapshot is it?
I figured once the snapshot was done and
pushed over, that the rest of replication
would be the sync'ing part.
Thanks,
-comb
No - this doesn't cause the snapshot agent to start automatically, or mark
the subscribers for reinitialization.
It only affects things the next time you choose to run the snapshot agent.
Regards,
Paul Ibison
|||In article <OPxX59qfEHA.556
@.tk2msftngp13.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> No - this doesn't cause the snapshot agent to start automatically, or mark
> the subscribers for reinitialization.
> It only affects things the next time you choose to run the snapshot agent.
> Regards,
> Paul Ibison
>
>
that is perfect then.. thats the information
i needed to know..
thanks for the response..
-comb