SQL Server Indonesia User Groups Community

Whitepapers: Advantages of a 64-bit Environment Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005 Comparing Tables Organized with Clustered Indexes versus Heaps Connectivity and SQL Server 2005 Integration Services ( written by Bob Beauchemin) Database Administrator’s Guide...

Whitepapers: Auditing in SQL Server 2008 Data Compression: Strategy, Capacity Planning and Best Practices ( tech reviewed by Paul S. Randal) Data Loading Performance Guide Database Encryption in SQL Server 2008 Enterprise Edition FILESTREAM Storage in SQL Server 2008 ( written by Paul S. Randal) High...

Why? Error: 18456, followed by Error: Login failed for user 'username'. Reason: Failed to open the explicitly specified database. and then you find out that in your database, there is a user name that has no login name How to fix it? you can use sp_change_users_login to update database user name...