Rename table without breaking sp?

What is the best way to rename a table without breaking esxisting Stored
Procs that are dependent on the table....?

Thanks
Jason

[Aaron [SQL Server MVP]]

ALTER the stored procedures at the same time, or don't rename the table.

If you rename the table, the stored procedures aren't going to magically
re-write themselves.

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




<jason@catamaranco.com> wrote in message
news:OrVSi59eEHA.1604@TK2MSFTNGP11.phx.gbl...

> What is the best way to rename a table without breaking esxisting Stored
> Procs that are dependent on the table....?
>
> Thanks
> Jason
>
>

[Aaron [SQL Server MVP]]

Another option is to rename the table and create a view with the old table
name that points at the new table.

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




<jason@catamaranco.com> wrote in message
news:OrVSi59eEHA.1604@TK2MSFTNGP11.phx.gbl...

> What is the best way to rename a table without breaking esxisting Stored
> Procs that are dependent on the table....?
>
> Thanks
> Jason
>
>

[Chris Hohmann]

<jason@catamaranco.com> wrote in message
news:OrVSi59eEHA.1604@TK2MSFTNGP11.phx.gbl...

> What is the best way to rename a table without breaking esxisting Stored
> Procs that are dependent on the table....?

Database? Version? DDL? Sample Data?
[url]http://aspfaq.com/5009[/url]

How about creating a view/query with the name of the old table, based on the
new table?

Thanks.

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:eD0dgC%23eEHA.3988@tk2msftngp13.phx.gbl...

> ALTER the stored procedures at the same time, or don't rename the table.
>
> If you rename the table, the stored procedures aren't going to magically
> re-write themselves.
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
>
>
>
> <jason@catamaranco.com> wrote in message
> news:OrVSi59eEHA.1604@TK2MSFTNGP11.phx.gbl...

> > What is the best way to rename a table without breaking esxisting Stored
> > Procs that are dependent on the table....?
> >
> > Thanks
> > Jason
> >
> >

>
>

Thanks.

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OZJJ6C%23eEHA.1424@tk2msftngp13.phx.gbl...

> Another option is to rename the table and create a view with the old table
> name that points at the new table.
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
>
>
>
> <jason@catamaranco.com> wrote in message
> news:OrVSi59eEHA.1604@TK2MSFTNGP11.phx.gbl...

> > What is the best way to rename a table without breaking esxisting Stored
> > Procs that are dependent on the table....?
> >
> > Thanks
> > Jason
> >
> >

>
>

Thanks - sql server 8.0......3 foreign tables related...two stored
procedures dependent.

- Jason
"Chris Hohmann" <nospam@thankyou.com> wrote in message
news:esblSE%23eEHA.704@TK2MSFTNGP09.phx.gbl...

> <jason@catamaranco.com> wrote in message
> news:OrVSi59eEHA.1604@TK2MSFTNGP11.phx.gbl...

> > What is the best way to rename a table without breaking esxisting Stored
> > Procs that are dependent on the table....?

>
> Database? Version? DDL? Sample Data?
> [url]http://aspfaq.com/5009[/url]
>
> How about creating a view/query with the name of the old table, based on

the

> new table?
>
>