TechNet 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: rss
John Behneman
Batch file to consolidate running 3 App-V SQL scripts to create the 4 App-V SQL jobs, add Data Messages to sys.messages and fix the deprecated TRUNCATE_ONLY issue with Check Usage History App-V Job when running on SQL 2008.
(0)
Updated 7/3/2012
Released 11/28/2011
255 Downloads
John Behneman
This Script fixes an issue where the App-V Check Usage History job fails when run on SQL 2008. This is a second version that will work with additional batch file. The only different between this file and sp_SFTcleanupusage_update.sql is the file name.
(3)
Updated 7/3/2012
Released 11/21/2011
269 Downloads
SQL
John Behneman
The App-V Database will work without these Data Messages added to the sys.messages table in the Masters DB table but the SQL Server may start generating 18054 events as described in the description section. This script will add these data messsages and prevent these events.
(3)
Updated 7/3/2012
Released 11/28/2011
493 Downloads
SQL
John Behneman
This script addresses the issue with the App-V stored procedure (sp_SFTcleanupusage) executed by the 'Check Usage History' job which uses the Trucate_only option that is no longer supported in SQL 2008 therefore the job fails.

(5)
Updated 7/3/2012
Released 11/18/2011
536 Downloads
SQL
John Behneman
This sql script creates the 4 App-V SQL jobs and alerts, Check Usage History, Close Orphaned Sessions, Enforce Size Limit and Monitor Alert/Job Status, it can be run alone or in conjuction with CREATE_JOBS_MESSAGES.BAT and 2 associated SQL scripts.
(3)
Updated 7/3/2012
Released 11/21/2011
386 Downloads
SQL