- Details
- Written by: Stanko Milosev
- Category: MS SQL
- Hits: 5054
If you have problem with your SQL Server, like it locks table, or your select statement takes too long, or executes never, tham try something like:
ALTER DATABASE MyTableName
SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE MyTableName
SET READ_COMMITTED_SNAPSHOT ON
Solution I found here, also you can read this article from Microsoft.
- Details
- Written by: Stanko Milosev
- Category: MS SQL
- Hits: 5074
If you are using Microsoft drivers for connection to MS SQL 2008, and receiving this kind of error, then, you will need to download new drivers from here. After that you will need to download sqlncli.msi (you will get the link in sqlsrv_errors())