SQLServerCentral.com Script Library

Scripts from the maker of Sql Spy. 

Displays Identity Column Values
By: Robert Vallee - Posted: 10/21/2001
Script Rating (3.71)   Total number of votes [7]
Displays identity column values, number of rows in the table, and the difference between the two. The difference can indicate the amount of deletions that could be going on. ...

Display Identity Values and Other Info
By: Robert Vallee - Posted: 09/06/2001
Script Rating (3)   Total number of votes [6]
Displays identity values, number of rows in the table, and the difference between the two. The difference can indicate the amount of deletions that could be going on. ...

Display Stored Procedure Parameters
By: Robert Vallee - Posted: 09/04/2001
Script Rating (4.41)   Total number of votes [17]
Display any stored procedures using input and output parameters. I took the view, PARAMETERS that ships with SQL 2000 and cleaned it up a bit. ...

Output Language Date Settings
By: Robert Vallee - Posted: 09/04/2001
Script Rating (1)   Total number of votes [1]
Display language/date settings for your SQL Server. ...

hx_Windows_Logins
By: Robert Vallee - Posted: 08/22/2001
Script Rating (3.75)   Total number of votes [4]
Display only windows logins for SQL Server ...

hx_ShowIdentityColumns
By: Robert Vallee - Posted: 08/22/2001
Script Rating (3.43)   Total number of votes [7]
List out all columns that are set as Identity columns in the database ...

hx_ShowFixedDriveSpace
By: Robert Vallee - Posted: 08/22/2001
Script Rating (2.4)   Total number of votes [5]
Very simple, how much space is free on the hard drives of the SQL Server you are connected to. ...

hx_OLEDBproviders
By: Robert Vallee - Posted: 08/22/2001
Script Rating (2.75)   Total number of votes [4]
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help ...

hx_JobSchedules
By: Robert Vallee - Posted: 08/22/2001
Script Rating (3.89)   Total number of votes [9]
Displays Job Schedules info if any ...

hx_IndexInformation
By: Robert Vallee - Posted: 08/22/2001
Script Rating (4)   Total number of votes [4]
Displays Index Info for whatever database it is run against ...

hx_DTSPackageDetails
By: Robert Vallee - Posted: 08/22/2001
Script Rating (2.5)   Total number of votes [2]
Displays DTS Package info if any ...

hx_dbMaintancePlans
By: Robert Vallee - Posted: 08/22/2001
Script Rating (2.5)   Total number of votes [2]
Displays Maintance plan history if any. I used distinct to filter out and return only what is relevent to what I need. You may not wish this for your purposes. Feel free to make changes ...

hx_DatabaseProperties
By: Robert Vallee - Posted: 08/22/2001
Script Rating (3)   Total number of votes [5]
Displays database properties. Was this the best way of doing it? Probably not, but it works. ...

hx_ConfigurationOptionReference
By: Robert Vallee - Posted: 08/22/2001
Script Rating (4)   Total number of votes [4]
Displays Configuration option references and current set values. ...

Optimize Character Field Usage
By: Robert Vallee - Posted: 08/10/2001
Script Rating (4.48)   Total number of votes [21]
This stored procedure was designed to scan all your character based columns in a particular database and show the minimum, maximum and average data length. As well as give an efficiency rating of the data stored. Input: None Output: Table...

Contribute a Script.

SQLServerCentral.com Script Library