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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2007-02-15 : 12:26:52
|
| I have restored PlayIT DB from IT DB...I am trying to change all of database objects ( view, trigger, SP,and functions..) that are using IT database to PlayIT database...how can I do this? it is impossible to change it manullay.. is there a script that I can run to change the databsename It to PlayIt in all of databse objetcs?For examplethere are views in PlayIT that has select * from IT --> i need to change this to select * from PlayIt. |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-02-16 : 00:04:08
|
| Maybe script out all the view and do a search and replace? then create those views again? |
 |
|
|
|
|
|
Make changes the DB objects