NewbieDude wrote:
but when i add stored procedures, it does not seem to commit to the database, when i click save it asks for a local destination but i want it to save onto the sql server.
When you click "save" it wants to "save" a file, naturally. You need to "execute" (F5 - if you want the keyboard shortcut) the SQL in order to apply it to the database. ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?