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 |
|
sundaysmile
Starting Member
1 Post |
 Posted - 2007-12-03 : 09:59:45
|
| IN sql server 2005, you can rename a db table as sp_tbl1 by right clicking the table in object explorer and rename it to sp_tbl1,The task is if you want to again change back the name from sp_tbl1 to tbl1 then sql server does not alow you to do that.Is there any other way using dbcc commands or anything else to get that renamed back??Thanks,Kumar |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-03 : 10:17:20
|
You renames tables with prefix sp_ ?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-03 : 10:19:34
|
| Make use of sp_rename system stored procedure.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
A tricky task