Hey For this problem Sql 2005 provide solution You can create Synonyms and refer that synonyms name instead of refering databaseneme.tablename into sp. so if your db name also change then no need to update all sp. this solve your problem.
On 6/21/07, thiruselvan <[EMAIL PROTECTED]> wrote: > > Thanku satish for ur solution.But is it possible to insert,update and > delete on those views which which use in our TEST1 database. > > On Jun 20, 6:34 pm, BabuLives <[EMAIL PROTECTED]> wrote: > > Hoping that you dont want change the SP every time when you chnage the > > database name you can always create a view and access those table in > > another database from current database.This makes u to chnage the view > > alone without changin the SP's.. > > > > Hope this helps u.. > > > > Regards, > > Satheesh > > > > On Jun 20, 10:25 am, thiruselvan <[EMAIL PROTECTED]> wrote: > > > > > > > > > I have 2 databases in sqlserver 2005.one is TEST1 and another is > > > TEST2.In the TEST1 database while writing stored procedures,I use the > > > TEST2 tables also.when i use the TEST2 database tables i call them by > > > using TEST2.USER2.Table1.Everyting is running fine.But in future my > > > client may change the TEST2 database as TEST10.Now i need to rewrite > > > all the stored procedures in database TEST1 which ever uses the TEST2 > > > database.But i want a solution where i should change my stored > > > procedures,whatever my TEST2 database name changes. > > > > > Thanks and Regards > > > Thiruselvan R.S- Hide quoted text - > > > > - Show quoted text - > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups ".NetIndia" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/TechdotNetIndia?hl=en http://www.satheeshbabu.com http://www.satheeshbabu.blogspot.com/ -~----------~----~----~----~------~----~------~--~---
