SQL Server Central - Scripts by Pedro Lopes

Check Availability Window - SQL2k5

This script allows you to check the several availability windows for the current day. Read more...

By Pedro Lopes 2008/01/11 | Source: SQLServerCentral.com | Category: Maintenance and Management

Rating:

|

Discuss |

Briefcase | 865 reads

Check Availability Window - SQL2k

This script allows you to check the several availability windows for the current day. Read more...

By Pedro Lopes 2008/01/18 | Source: SQLServerCentral.com | Category: Maintenance and Management

Rating:

|

Discuss |

Briefcase | 582 reads

usp_IndexCreationStatements

(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns. Read more...

By Pedro Lopes 2007/12/13 | Category: SQL Server 2005

Rating: (not yet rated) |

Discuss |

Briefcase | 530 reads

Check Instance Info

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance. Read more...

By Pedro Lopes 2007/12/19 | Source: SQLServerCentral.com | Category: SQL Server 2000

Rating:

|

Discuss |

Briefcase | 917 reads

usp_ShowOrphanUsers

Check Orphaned logins ie, not associated with any database on the current instance. Read more...

By Pedro Lopes | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 204 reads