Galería TechNet - Recursos para profesionales de TI

Descargue los recursos y aplicaciones para Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, y otros productos. Encuentre los recursos escritos en VB Script, PowerShell, SQL, JavaScript, u otros lenguajes de script. Los nuevos recursos se agregan frecuentemente. Revise a menudo y consulte las novedades.

Cada contribución es autorizada bajo un Contrato de Licencia por su propietario y no por Microsoft. Microsoft no garantiza la contribución ni implica otorgar derechos sobre la misma.
Ordenar por: rss
4 Support resultados en SQL [Borrar]
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)
Actualizado 03/07/2012
Lanzamiento 21/11/2011
270 Descargas
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)
Actualizado 03/07/2012
Lanzamiento 28/11/2011
493 Descargas
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)
Actualizado 03/07/2012
Lanzamiento 18/11/2011
536 Descargas
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)
Actualizado 03/07/2012
Lanzamiento 21/11/2011
386 Descargas
SQL