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