- I have many tasks at work everyday. I have a query at work that needs to be performed everyday(number of queries may increase). I have general(good enough) ability in computers, databases and SQL.
Goal: I want to optimize my work flow, and I want to make it very easy so even if I am not at work somebody with very little knowledge can do it.
Now: SQL is written in Excel file. The SQL text is copied -> Management Studio is opened -> Database login is done -> SQL text is pasted in -> SQL is executed.
Wanted: SQL is stored in file(sql) -> If opened, the database login screen is shown OR login is done automatically -> SQL is executed.
Problem: The database login screen doesn't seem to be shown when an SQL file is opened(opens if Management Studio is already open). I either want the login screen to be shown or to be able to include the username and password in the file somewhere so it is done automatically. (I know this is small, but assume I'm lazy and time is money, and newbies can waste a lot of time :) )