Showing posts from March, 2013

How to find maximum number of workers that can be created?

Resolving Error: 831, Severity: 20, State: 1 with message “Unable to deallocate a kept page” in SQL 2005 Error log

How to resolve Error: 1006 (3EE); Provider Error: 1006 (3EE) in SQL Server’s log/job failure history?

How to bring litespeed central and local repository in sync?

How to resolve Error: 3041, Severity: 16, State: 1 reported in SQL Server Log?

How to find the port SQL Server is listing/using using TSQL/Code?

How to find when SQL Server started using TSQL?

How to find when data (row) of a table is last updated?

How to give permission to someone to use SQL Server Activity Monitor or to use DMV

How to restore a database from a snapshot?

Finding detailed status of disks of a SQL Server

How to find space and size related details from all tables in a database

How to update a credential when underlying account’s password is changed?

How to execute a SSIS package using some other account instead of SQL Server Agent’s service account?