Download Windows Server 2012TechNet Gallery - resources for IT professionals
Download resources and applications for Windows 7, 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:
|
To search the whole database for a string in the tables. This stored procedure will return the tables and result set with the matching search string.
|
(33)
Updated 10/29/2013
Released 4/28/2011
8,439
Downloads
|
|
|
This is a utility procedure which gives the details like parameters , Datasources , Datasets etc of the given report by querying ReportServer database tables.
|
(18)
Updated 5/31/2011
Released 5/30/2011
2,396
Downloads
|
|
|
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 |
(5)
Updated 12/24/2012
Released 3/16/2012
973
Downloads
|
|
|
Code sample to demonstrate how to create a SSIS package programatically using C# with source and destinations tables of different column names. This sample code creates a package dynamically to connect two SQL Server tables of different structures dynamically.
|
(0)
Updated 9/20/2013
Released 9/20/2013
93
Downloads
|
|
|
This script will get the list of Linked server with its properties and its associated local/Remote login list. This query result may have repeated linked server nam if it has more than one associated remote login.
|
(1)
Updated 8/24/2011
Released 8/24/2011
286
Downloads
|
|
|
This utility procedure generates a stored procedure for DML operations Insert , Update and Delete for a given table. This procedure will be usefull to generate basic stored procedure to do this operations and use it from the front end.Parameters@
|
(1)
Updated 3/14/2012
Released 3/14/2012
517
Downloads
|
|
|
This script compares the table schemas between two SQL Server databases and gives the report for missing columns , data type mistmatch , length & precision mismatch and Collation Mismatch.
|
(2)
Updated 4/29/2011
Released 4/29/2011
|
|
|
DescriptionDesc
|
(0)
Updated 1/20/2012
Released 1/19/2012
306
Downloads
|
|
|
Description In the SSRS reports , in general we have a requirement to display the parameters and the values used to generate the report in the header or footer. With the parameter collection in the report we will not be able to achive this as the parameter collection in the r
|
(3)
Updated 8/12/2011
Released 8/12/2011
326
Downloads
|
|
|
This C# code is a console application which gets and prints the list of objects in the given SSAS server , Database or Cube.
|
(2)
Updated 7/7/2011
Released 7/6/2011
498
Downloads
|
|
|
This stored procedure extracts data out of a large tables for the given number of rows or percentage of rows or Where clause. This will extract the data from all the given tables with referential integrity intact.
|
(3)
Updated 5/9/2011
Released 5/9/2011
794
Downloads
|
|
|
This stored procedure generates the foreign key relationship to "n" level in tree structure. Also it generates delete / select scripts for all the dependent tables.
|
(4)
Updated 5/10/2011
Released 5/10/2011
946
Downloads
|
|
|
This stored procedure is an extension of sp_who2 system stored procedure to show additional data like Executing command , Execution Plan , Percentage Complete (For specific operations), Estimated time of completion (For specific operations)and Command type.
|
(1)
Updated 5/25/2011
Released 5/19/2011
475
Downloads
|
|
|
This stored procedure will generate the DROP and CREATE script for the indexes on a given table. This will generate scripts for all types of indexes Clustred (primary key) , Non Clustered and XML Indexes.
|
(1)
Updated 9/13/2012
Released 9/13/2012
208
Downloads
|
|
|
This functions Converts / spells the given number into words. This supports conversion in two formats
1.US Number system (Million,Billio 2.UK Number system (Lakhs,Crores .,etc) |
(1)
Updated 6/14/2011
Released 6/14/2011
536
Downloads
|
|