Here is the query

DECLARE @Tbl AS TABLE (Details VARCHAR(MAX))

DECLARE @FilePath AS VARCHAR(100) = '\\NWDrive\FolderName\'

DECLARE @Cmd AS VARCHAR(100) = 'DIR ' + @FilePath

INSERT INTO @Tbl

exec master..xp_cmdshell @Cmd

SELECT ...

this might be like services are in middle of restart. check application event log if you can see any error message.

You can insert the resultset of below query to any table.

SELECT ps.database_id, ps.OBJECT_ID,

ps.index_id, b.name,

ps.avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS ps

INNER JOIN sys.indexes AS b ON ps.OBJECT_ID = b.OBJECT_ID

AND...

http://www.simple-talk.com/sql/t-sql-programming/identity-columns/

Check this example

http://www.mssqltips.com/sqlservertip/2011/export-sql-server-data-to-oracle-using-ssis/

Check this

http://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/

Check this article 🙂

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31790/

How differential backup works.

http://msdn.microsoft.com/en-us/library/ms345448(v=sql.90).aspx

any transaction might be using the database. that's why your transaction got blocked.

You can try with killing that transaction or use this query to rollback that particular transaction.

Alter database...

adding default value on existing column.

http://stackoverflow.com/questions/92082/add-column-with-default-value-to-existing-table-in-sql-server