Thursday, November 3, 2011

SQL Server Error logs

11/03/2011 05:43:44,spid9s,Unknown,
SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on
file [S:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\tempdb2.ndf] in database [tempdb] (2).
The OS file handle is 0x0000000000001358. The offset of the latest long I/O is: 0x0000002e040000

Wednesday, November 2, 2011

About SSMS of SQL Server

SSMS 2005 can NOT connect to SSIS 2008
SSMS 2008 can NOT connect to SSIS 2005