I have 12 databases on my SQL Server, one for each month of the year, and I have almost all the same stored procedures in each database. This architecture is hard to maintain, because you have duplication of the code, and a modification must be made on all the databases. Is there a way to put all my code in a separate database and set up a procedure to pass a database name when I wish the code to be executed?
September 8, 2008 8:23 PM
September 9, 2008 4:46 AM