>
Repository

Script resources for IT professionals

Download resources and applications for Windows 10, Windows 8, Windows 7, Windows Server 2012, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.

Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
Sort by: rss
770 SQL Server results [Clear]
Satheesh Variath
This SQL script will compare table columns, Index and foreign keys in two databases. This will show a result with missing objects and the objects with definition mismatch
(7)
Updated 9/30/2013
Released 6/14/2012
5,830 Downloads
SQL
Olaf Helper
This PoSh script tries to enumerate SQL Server instances in your network using SMO and creates an inventory as a Html document.It's similar to MS MAP,but only as a simple plain script and dedicated for SQL Server instances.With this info you could plan a SQL Server consolidation.
(14)
Updated 11/27/2011
Released 11/27/2011
9,791 Downloads
Olaf Helper
This Transact-SQL script list all existing subscriptions with the schedule data.
(14)
Updated 9/6/2011
Released 9/6/2011
3,195 Downloads
SQL
Denzil Ribeiro
  SQL Server 2012 provides a host of diagnostics  in the form of the System Health extended events session which includes sp_server_Diagnostics collection Here  are a set of Sample reports provide a ‘dashboard’ over the events collected in this session. Key data points covered in
(11)
Updated 4/29/2013
Released 4/29/2013
4,643 Downloads
SQL
Olaf Helper
Transact-SQL script to analyse the database size growth using backup history.
(7)
Updated 8/18/2011
Released 8/3/2011
3,971 Downloads
SQL
OneScript Team
In SQL Server, can only use master.dbo.xp_regread procedure reading registries to get components version information, some enterprises in order to safely remove the procedure. So, in this chapter, we will use PowerShell to determine the version of SQL Server installed components.
(0)
Updated 12/14/2015
Released 11/10/2015
534 Downloads
vinaypugalia
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files) at one go out-of-box. Hence, today I will share a simple TSQL script to download achieve this.
(0)
Updated 8/6/2014
Released 8/6/2014
1,469 Downloads
SQL
SathyanarrayananS
In SQL Server , we can generate Index script in the following ways :1.) Under Object Explorer -> Databases -> Database -> Tables - > Indexes -> right-click on index - > Create Script as ..2.) Using Generate SQL Server Scripts Wizard - > setting Script Indexes to True 3.) Using In
(8)
Updated 9/7/2013
Released 9/7/2013
2,545 Downloads
SQL
Sorna Kumar Muthuraj
 Audit is always a kind of standard requirement in all the trasactional system. For auditing a particular table ,we need to create a similar structure audit table and create Insert , Update and Delete triggers to keep track of the changes in the table. This
is utility procedure
(13)
Updated 12/24/2012
Released 3/16/2012
3,689 Downloads
SQL
OneScript Team
This T-SQL script will demo how to combine multiple rows into one row by a same column value in SQL Server.
(0)
Updated 4/21/2014
Released 4/21/2014
1,669 Downloads
SQL
Chrissy LeMaire
Uses PowerShell and SMO to migrate SQL logins. Logins are completely migrated and maintain their: SIDs, passwords, server/database roles, server/database permission sets & securables, default database and login attributes. Works on SQL Server 2000 and above.
(7)
Updated 12/9/2015
Released 9/7/2014
1,563 Downloads
Chrissy LeMaire
Import-CsvToSql takes advantage of .NET's super fast SqlBulkCopy class to import CSV files into SQL Server at up to 90,000 rows a second.
(0)
Updated 9/7/2015
Released 9/5/2015
423 Downloads
Kev Riley
SQL script that iterates over all online databases for an instance and produces a list of databases and the count of Virtual Log Files (VLFs). The SQL Server Database Engine divides each physical log file internally into a number of virtual log files.
 having too many or too fe
(10)
Updated 1/24/2014
Released 3/15/2012
2,106 Downloads
SQL
Olaf Helper
This PowerShell script exports all (or filtered) reports, data sources and images directly from the ReportServerdatabase to a specified folder. For the file name the complete report path is used; for file name invalid characters arereplaced with a -.
(6)
Updated 9/7/2011
Released 9/6/2011
4,187 Downloads
Ch. Rajen Singh
Below example demonstrate how we can access file properties using TSQL. The stored procedure retrives all the files properties (i.e file name, size in KB and last modified date) within a specific folder.This can be achieved using T-SQL & OLE automation object i.e Shell Applicatio
(0)
Updated 4/4/2014
Released 8/7/2013
2,111 Downloads
SQL

Couldn't find the script you were looking for?

16 - 30 of 770 Items