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 --~--~---------~--~----~------------~-------~--~----~ 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/ -~----------~----~----~----~------~----~------~--~---
