LitKnd

/* Note: don't run this all at once. There are prompts to run some queries in another session, etc. */

WHILE @@trancount > 0
	ROLLBACK
GO

USE master;
GO

IF DB_ID('lockingtest') IS NOT NULL

jasmin-mistry

[string]$server = 'localhost'
[string]$serverurl = "http://$server/ReportServer_SQL2014"

$proxy = $null

# namespace parameter only works for 2010 and not for 2005 but if you get the type after setting up proxy then both works

$proxy += New-WebServiceProxy -Uri "$serverurl/ReportService2010.asmx" -UseDefaultCredential ;  #-Namespace SSRS.ReportingService2010