SQL 2008 Backup Issues and Solution

SQL 2008 Backup Error The server Principle " " is not able to access the database " " under the current Security context...

Suspect Query for SQL 2000/ 2005 /2005

Recover Suspected Database for SQL 2000/2005/2008 Suspect Query SQL 2005 AND 2008  ALTER DATABASE yourDBname  SET EMERGENCY DBCC checkdb(...

Shrink eMO database log file in SQL 2005/2008

Shrink Log file of eMO database in SQL 2008 Steps to Shrink DB Log 1. In SQL Server Management Studio 2. Right click on the eMO database and...

Install SQL Server 2008 R2 in Windows 2008 Server / Seven

SQL 2008 Server R2 Installation An evaluation copy of SQL Server 2008 R2 can be downloaded from here. Download SQL 2008 R2 Recommendations b...

SQL 2000 / 2005 / 2008 Management Studio Shortcut Keys

Run SQL window - shortcut keys The following shortcut keys are active in the Run SQL window: Ctrl + A select all Ctrl + B change list-box po...

SQL Server Query Analyzer Shortcuts : SQL 2005 / 2008

SQL Server Query Analyzer Shortcuts Shortcut Function Shortcut Function ALT+BREAK Cancel a query CTRL+SHIFT+F2 Clear all bookmarks ALT+F1 Da...

Collation conflict in MS SQL Server 2005 / 2008

Issues of SQL Server Collation and Solution “SQL_Latin1_General_CP1_CI_AS” in the UNION operation. (Microsoft SQL Server, Collation conflict...

SQL Server 2008 R2 Error and Solution

SQL 2008 R2 Network related Issues and Solution An error has occurred while establishing a connection to the server. (provider: Named Pipes ...