Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jtwork
Yak Posting Veteran
82 Posts |
 Posted - 2008-05-16 : 06:03:00
|
| Does anyone know how to do a sp_rename thats not held to the current database? |
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2008-05-16 : 06:08:47
|
| hiwat u mean by that.. |
 |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-05-16 : 06:19:48
|
| try something likeExec dbname.dbo.sp_rename '', '' |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-05-16 : 09:37:46
|
from BOLquote:
Changes the name of a user-created object in the current database
the only other way is to use DSQL--------------------keeping it simple... |
|
|
|
|
|
|
sp_rename