I have a script that i use to generate the tables and views in two databases. In the script there is a view that has a join over tables in both databases.
The databases can have different names each time i run the script so this affects the database names in the views.
Is there anyway i can have parameters to a script so i can make it more generic?
Otherwise i must edit the script each time and there is a risk i make a mistake.