I too have encountered a similar problem and after much experimentation I noticed that when using Nhibernate to generate my schema to a file the generated column type was always length 8000. Setting setting CustomSqlType to Varbinary(max) as suggested above made no difference, however, this work around in my FluentMapping seemed to do the trick: … Read more
The best solution is obviously to use Windows security. If that is not suitable, here is a possible alternative trick, exploiting the fact that Access remembers all opened connections until the program is closed: copy the connect string of one of your tables create a passthru queries “ptqConnect” and enter any fast SQL statement in … Read more
Install Microsoft SQL Management Studio, which you can download for free from Microsoft’s website: Version 2008 Microsoft SQL Management Studio 2008 is part of SQL Server 2008 Express with Advanced Services Version 2012 Click download button and check ENU\x64\SQLManagementStudio_x64_ENU.exe Version 2014 Click download button and check MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe Open Microsoft SQL Management Studio. Backup original … Read more
There are a number of limitations, notably: Constrained to a single CPU (in 2012, this limitation has been changed to “The lesser of one socket or four cores”, so multi-threading is possible) 1GB RAM (Same in 2008/2012) 4GB database size (raised to 10GB in SQL 2008 R2 and SQL 2012) per database http://www.dotnetspider.com/tutorials/SqlServer-Tutorial-158.aspx http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx With … Read more
SQL Server Express doesn’t include SQL Server Agent, so it’s not possible to just create SQL Agent jobs. What you can do is: You can create jobs “manually” by creating batch files and SQL script files, and running them via Windows Task Scheduler. For example, you can backup your database with two files like this: … Read more