Menu
I haven't really done a ton of database work in a few years and have become unaccustomed with the tools available. Back a few years ago I was working with oracle databases and was using primarily TOAD with a little bit of MS Access as my tools of choice to prototype the queries I was using in my applications. I really loved TOAD in that it was super intuitive and really easy to use and I'm hoping to find something similar for MS SQL Server. Something open source or free is preferable, since I doubt my client will want to pay for anything, but I'm willing to hear suggestions of things that cost money if they are far and away the best in class tool available.
840
Closes an open cursor by releasing the current result set and freeing any cursor locks held on the rows on which the cursor is positioned. CLOSE leaves the data structures available for reopening, but fetches and positioned updates are not allowed until the cursor is reopened.
In SQL Server Management Studio, you can right-click on each database, select “Properties”, and choose the “Options” tab. Set Auto Close to false and click OK.
SQL will not be replaced for a long time, as it has a number of key benefits: It is very popular among data professionals. Leading tech companies rely on relational databases and SQL. Professionals working with data are used to SQL; it's quite challenging to re-train the workforce to use another tool.
azure_ardee, i've looking for the Windows Authentication on Squirrel. If you use the jtds driver you cand add the property DOMAIN to the connection string.
The sintax for the conn str is: jdbc:jtds:sqlserver://[:<1433>]/[;=[;...]]
For example: jdbc:jtds:sqlserver://hostname:1433/db_name;DOMAIN=my_domain
Also, you can click the Properties button, check the DOMAIN property and fill the value with the domain name.
I hope i helped!
Nakro
100
Maybe try SQL Manager Express first. If you need more, you can always look for other solutions.
Edit: This was for MS SQL 2005 Express. I hope that there will be a new one for MS SQL Express 2008, and it will be much quicker like VS 2008 compared to VS 2005.
Update: MSSQL 2014 Developer Edition is free for development purposes. It contains SQL Manager with full funcionality.
27
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
