Maintenance and Management

Get SQL job status for all servers.

  • Script

Below script will Get SQL job status for all servers running on the same network. All you have to do is create a linked server with msdb on local machine. Executing this script will give you all job status on any number of servers. Good for an environment where a DBA had to see job […]

5 (1)

2006-09-20 (first published: )

733 reads

InvalidLogins.pl

  • Script

Perl script that reports SQL Server AD accounts which are now longer valid by verifying the output of sp_validlogins system stored procedure against SID stored in AD. This is done to ensure only accounts that do not exist are reported since sp_validlogins will only check the name and not SID against AD. Accounts that are […]

2007-02-12 (first published: )

239 reads

T-SQL Maintenance Plan Creation

  • Script

Use this script ot be able to create DB Maintenance Plans fast. If you need to create the plans on servers similarly set up, edit the required parameters once, and when you create a new plan, you will only need to specify a database name and one task start time, run the script and the […]

2007-02-05 (first published: )

963 reads

Reset Identity Seeds

  • Script

This Script is used to reset the Identity coloumn to whatever the value we required. We need to compile this procedure in the database where we required to ressed the Identity coloumns of every table. After compiling we need to execute this procedure with a parameter of integer value. Then it will reseed the Identity […]

2006-08-29 (first published: )

198 reads

Data Dictionary - SQL 2005

  • Script

I know there are several scripts out there showing you on how to create a data dictionary... I created this script for creating a data dictionary for SQL 2005. It stores the data into a table in the database that you choose. The script only stores the table name, column name, default value of the […]

5 (1)

2006-10-24 (first published: )

3,096 reads

Blogs

Azure Function Drain mode

By

(2021-Jun-16) Recently, Google started to notify me that my blog website (http://datanrg.blogspot.com/) had been experiencing some...

By

New blog post - Monitor deadlocks in Amazon RDS for SQL Server and set notifications...

Let’s Celebrate Pride by Supporting Nonprofits

By

For Pride this year, we’re highlighting queer nonprofits and charities. It’s more important than...

Read the latest Blogs

Forums

Mirror Database without Domain

By stefgrifon

Hello, I tried to make a mirror for my Demo database My Principal server...

PowerShell script help

By rocky_498

Hi Guys, I am executing a PowerShell script from SSIS (Execute Process Task). Simple...

Performance Counters Missing in SQL 2016 SP2

By ReamerXXVI

Hi, I'm looking for a fix to an issue where performance counters are missing...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers