Posts Tagged ‘mssql’

Granting execute permissions to all stored procedures in a database for MSSQL

Wednesday, March 24th, 2010
I had this problem today when coding up an application that uses stored procedures to operate tasks. Most database admins like keeping their security locked down. So here's a way to allow execute stored procedure commands while keeping basic reader/writer permissions. SQL2005 /* CREATE A NEW ROLE */ CREATE ROLE db_executor /* GRANT EXECUTE TO THE ROLE */ GRANT EXECUTE TO db_executor…
  • Share/Bookmark

Tags: , , ,
Posted in Databases, Nerd Stuff | No Comments »

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Tuesday, March 23rd, 2010
Had this error come up while building a java app. Common problem when trying to connect to mssql database. Install the Microsoft SQL Server JDBC Driver and extract it to somewhere useful like C:\Program Files\... Add the following path to the System variables in your Environment Variables for Windows (My Computer > Properties) C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar This should work... If you're using an IDE - you'll need to add the CLASSPATH into the… Continue reading
  • Share/Bookmark

Tags: , , ,
Posted in Java, Nerd Stuff | No Comments »

Full transaction log on MSSQL

Sunday, January 17th, 2010
Had a big problem the other week when one of our databases was throwing heaps of exception email errors on scheduled tasks. After debugging for a few hours I worked out that the transaction log was completely full! Check out this useful article; http://msdn.microsoft.com/en-us/library/ms175495.aspx A useful tool is running the following command; backup log with no_log It's also suggested you do a Maintenance Plan Wizard - http://msdn.microsoft.com/en-us/library/ms189036.aspx I'll post more in this… Continue reading
  • Share/Bookmark

Tags: , ,
Posted in Coldfusion, Nerd Stuff | No Comments »