|
|
 |
How to recover database from suspect mode?
|
| Total Hit (26306) |
Sometime your database may go into suspect mode. A database can be marked suspect for one of the following reasons (this is from SQL Server Books Online):
«code LangId=0»If one or more database files are not available.
If the entire database is not available.
If one or more database files are
....Read More |
Rating
 |
|
|
|
Finding SQL Server Object Name from PageNumber
|
| Total Hit (6602) |
Most of time when sql server throw an error will tell you object Id or PageNumber.
This article will show you how to find which object caused the error.
«b»Step-By-Step Example«/b»
Lets say you got the folloing error from SQL Server
«b»Error«/b»
«font color=red»Error: 7105, Severity:
....Read More |
Rating
 |
|
|
|
Shrinking transaction log file on sql server 7.0
|
| Total Hit (1931) |
Many times when I do bult insert/delete operation my transaction log grows very fast and I use this scipt to shrink it. This simple scrip will show you how to shrink transaction log file in SQL Server 7.0 when your DBCC SHRINKFILE command wont work. In most cases DBCC SHRINKFILE(<log filename>,<new
....Read More |
| Rating
|
|
|
|
How to start SQL Server Agent automatically when SQL Server starts.
|
| Total Hit (3520) |
When you install SQL Server by default SQL Server Agent Service is set to Start Manual mode and some times this can stop your scheduled jobs. Its also possible that you stop Agent and forget to turn it on.
This article will show you how to create a SP which can start SQL Server Agent service if i
....Read More |
Rating
 |
|
|
|
Check job status using T-SQL
|
| Total Hit (4881) |
You can use the following stored proc to retrive status of SQL Server job.
If user executing this SP is not in sysadmin then make sure that user has "Select" permission on <Code>msdb..sysjobs</Code> table and execute permission on <Code>master.dbo.xp_sqlagent_enum_jobs</Code> extended stored pro
....Read More |
Rating
 |
|
|
|
How to create audit triggers?
|
| Total Hit (2305) |
This article will show you the most easiest way to audit your data changes for a specific table in sql server.
I will show you, how to use <Code>DBCC INPUTBUFFER</Code> command to capture some valuable audit information when update/insert/delete occurs.
Step-By-Step Example
- Run the follow
....Read More |
| Rating
|
|
|
|
Scanning the network for SQL Server for a range of IP addresses
|
| Total Hit (936) |
In a large IT department, it can be difficult to locate where new SQL Server installations were made and how many of those SQL Servers were patched, etc. This article explains how to scan the entire network for a range of IP addresses to find which boxes have SQL Server instances installed. The OSQL
....Read More |
| Rating
|
|
|
|
Statistics Used by the Query Optimizer in Microsoft SQL Server 2000
|
| Total Hit (698) |
Describes what data is collected, where it is stored, and which commands create, update, and delete statistics about indexes and column data stored in the Microsoft SQL Server 2000 database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving
....Read More |
| Rating
|
|