Check and Change isolation level of SQL Database

ALTER DATABASE EFORMSDEV_LC SET READ_COMMITTED_SNAPSHOT ON GO ALTER DATABASE EFORMSDEV_LC_PM SET READ_COMMITTED_SNAPSHOT ON GO SELECT name, snapshot_isolation_state_desc, is_read_committed_snapshot_on FROM sys.databases

open firewall ports on Windows 2008 R2 for SQL Server 2008 R2

@echo ========= SQL Server Ports =================== @echo Enabling SQLServer default instance port 1433 netsh firewall set portopening TCP 1433 "SQLServer" @echo Enabling Dedicated Admin Connection port 1434 netsh firewall set portopening TCP 1434 "SQL Admin Connection" @echo Enabling conventional SQL Server Service Broker port 4022 netsh firewall set portopening TCP 4022 "SQL Service Broker" @echo Enabling Transact-SQL Debugger/RPC port 135 netsh firewall set portopening TCP 135 "SQL Debugger/RPC" @echo ========= Analysis Services Ports ============== @echo Enabling SSAS Default Instance port 2383 netsh firewall set portopening TCP 2383 "Analysis Services" @echo Enabling SQL Server Browser Service port 2382 netsh firewall set portopening TCP 2382 "SQL Browser" @echo ========= Misc Applications ============== @echo Enabling HTTP port 80 netsh firewall set portopening TCP 80 "HTTP" @echo Enabling SSL port 443 netsh firewall set portopening TCP 443 "SSL" @echo Enabling port for SQL Server Browser Service's 'Browse' Button netsh firewall set portopening UDP 1434 "SQL Browser" @echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK) netsh firewall set multicastbroadcastresponse ENABLE

Update existing user mapping after restoring database

EXEC sp_change_users_login 'update_one', 'abc', 'abc'

SQL Server 2008 R2 version with Sp

SQL Server 2008 R2 : 10.50.1600.1 With SP1: 10.50.2500.0

Windows Service Error

0x1395 The cluster group could not be found.

Check Cluster Size in Windows 2008

fsutil fsinfo ntfsinfo c: (where c: is the volume/path to obtain the data for)

This will show you smilar to the following:

NTFS Volume Serial Number : 0x9e800d87800d675d
Version : 3.1
Number Sectors : 0x000000000c7fffff
Total Clusters : 0x00000000018fffff
Free Clusters : 0x000000000091cfd1
Total Reserved : 0x00000000000001b0
Bytes Per Sector : 512
Bytes Per Cluster : 4096
Bytes Per FileRecord Segment : 1024
Clusters Per FileRecord Segment : 0
Mft Valid Data Length : 0x0000000009fc0000
Mft Start Lcn : 0x00000000000c0000
Mft2 Start Lcn : 0x0000000000c7ffff
Mft Zone Start : 0x00000000000c9ca0
Mft Zone End : 0x00000000000ca7e0
RM Identifier: 07A1930B-353D-11DE-AB63-E15CC5EE82D6

Create / Drop tables in SQL Server

GRANT ALTER ANY SCHEMA TO [ODI_CALLISTA_ORG_UNIT_DX]
GO

GRANT CREATE TABLE TO ODI_CALLISTA_ORG_UNIT_DX;
GO