Display: Cloud | List
Most Popular Tags
Results (50 total) All > script (x)
PowerShell scripts (Modify Reporting Services configuration files [AX 2012])
I have scripted this with PowerShell. Full post is here:http://dynamicsnavax.blogspot.com/2012/01/modify-microsoft-dynamics-ax-2012-ssrs.html
Last modified by Thomas Lee on 2/20/2012 4:43:15 PM
Tags:  code  external  powershell  script  ssrs
Sample Using PowerShell (KnownColor Enumeration (System.Drawing))
<#.SYNOPSIS This script shows formatting of enums.DESCRIPTION This script iteraties through two enums and uses tostring and enum format strings to display the enum's values..NOTES File Name : Show-EnumFormat.ps1 Author : Thomas Lee - tfl@psp.co.uk Requires : PowerShell Version 2.0.LINK This script posted to: http://www.pshscripts.blogspot.com MSDN sampl
Last modified by Thomas Lee on 11/10/2011 3:36:36 PM
Script table definitions (Database.Tables Property (Microsoft.SqlServer.Management.Smo))
The userdefined tables in a given database can be scripted out traversing the Tables collection and using the ScriptionOptions Class.An example in PowerShell that gives some basics: $SqlServerName = '(local)'$DbName = 'AdventureWorks'$SqlBatchSeperator = 'GO'[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.Smo') | Out-Null$Server = New-Object Microsoft.SqlServer.Management.S
Last modified by Niels Grove-Rasmussen on 9/27/2011 1:05:55 PM
Tags:  database  powershell  script  server  smo  sql  table
Scripting Logins (Server.Logins Property (Microsoft.SqlServer.Management.Smo))
A database backup does not contain the Logins. This can be an issue when you restore a database on another databaseserver.The Logins can be scripted out as a "backup" with PowerShell: [string]$SqlServerName = '(local)'[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.Smo') | Out-Null$Server = New-Object Microsoft.SqlServer.Management.Smo.Server $SqlServerName $Server.Logins |
Last modified by Niels Grove-Rasmussen on 9/27/2011 12:23:12 PM
Tags:  login  logins  powershell  script
Time passes by.. (Lesson 1: Creating the Target Database)
The script will not work after 12/31/2010 and must be corrected to any date later than or same as today.. CREATE CERTIFICATE InstTargetCertificate AUTHORIZATION TargetUser WITH SUBJECT = 'Target Certificate', EXPIRY_DATE = N'12/31/2999'; BACKUP CERTIFICATE InstTargetCertificate TO FILE = N'C:\storedcerts\$ampleSSBCerts\InstTargetCertificate.cer'; GO Also you may be irritated by the name
Last modified by Thomas Lee on 2/13/2011 5:42:10 PM
Again, Create Certificate Script is out of date (Lesson 2: Creating the Initiator Database)
Change the date from 2010 to anything in future:CREATE CERTIFICATE InstInitiatorCertificateAUTHORIZATION InitiatorUserWITH SUBJECT = N'Initiator Certificate',EXPIRY_DATE = N'12/31/2010';BACKUP CERTIFICATE InstInitiatorCertificateTO FILE = N'C:\storedcerts\$ampleSSBCerts\InstInitiatorCertificate.cer';GOAlso you may be irritated by the name $ampleSSBCerts and change it to SampleSSBCerts.
Last modified by Sorri on 2/12/2011 3:27:16 PM
Tags:  certificate  error  script
Sample Script - Using PowerShell (__Namespace class (Windows))
Further to Radjin's post, I recently wrote a similar script. See:http://gallery.technet.microsoft.com/ScriptCenter/en-us/890ff802-9db2-4d25-aa13-4a2b22fe5db3 or http://pshscripts.blogspot.com/2010/10/get-wminamespaceps1.htmlMy script tidies up the list (sorting it by namespace name) and formats using a hash table for a nicer column heading.
Last modified by Thomas Lee on 10/10/2010 10:28:47 AM
Last modified by Mike McKeown (expired MS and LPL subscriptions) on 10/7/2010 6:59:53 AM
SQL Server 2008 Books Online (November 2009)Logging in the Script TaskThe use of logging in Integration Services packages lets you record detailed information about execution progress, results, and problems by recording predefined events or user-defined messages for later analysis. The Script task can use the Log method of the Dts object to log user-defined data. If logging is enabled, and the S
Last modified by Microsoft on 12/10/2009 11:53:02 PM
Tags:  logging  script
# // ***********************************************************************# //# // Author : Cedric.bravo# // WebSite : www.guvirt.org# //# // File : ConfigureIC_TimeSync.ps1# //# // Version: : 1.0# //# // Purpose : This script can be used to Disable Hyper-V Integration# // Component Time Synchronisation for VM.# // ***WARNING***# // THIS S
Last modified by Jimy Cao on 4/29/2011 1:18:06 AM
Page view tracker