After making changes to sprocs in my DB “Payroll” and then saving them, I am directed to:
C:\Documents and Settings\Administrator\My Documents\SQL Server Management Studio Express\Projects where the sproc and the changes are saved.
But when I go back into the sproc in the Payroll DB, the changes are not saved there. How can get management studio to save the sproc in the Payroll DB and not in the Projects folder?
I know I can change the above path thru Tools/Options to QueryResults, but that is not my DB “Payroll”. Plus, I am not wanting to save the results. I am wanting to save the changed query in my DB “Payroll”
I have found my Payroll file in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data, but when I try to view it I get the message that it being used, even when Mgnt Studio is not open.
I have tried to look in the Master DB, but it gives me an error message also.
TIA.
Bill
C:\Documents and Settings\Administrator\My Documents\SQL Server Management Studio Express\Projects where the sproc and the changes are saved.
But when I go back into the sproc in the Payroll DB, the changes are not saved there. How can get management studio to save the sproc in the Payroll DB and not in the Projects folder?
I know I can change the above path thru Tools/Options to QueryResults, but that is not my DB “Payroll”. Plus, I am not wanting to save the results. I am wanting to save the changed query in my DB “Payroll”
I have found my Payroll file in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data, but when I try to view it I get the message that it being used, even when Mgnt Studio is not open.
I have tried to look in the Master DB, but it gives me an error message also.
TIA.
Bill