power-programming.co.uk
Power Programming Blog | SQL Server 2005
http://www.power-programming.co.uk/category/SQL-Server-2005.aspx
Part of the Power Programming. The general spraffin' of the geek world. Revoke all permissions on a User over several databases. February 27, 2014 19:03 by. We had a need to revoke all permissions on a User over several databases, we could have simply taken the access permission to the database itself away. However, the requirement here was to allow the user access to the database but for the user to have NO permissions to any objects within it. Abortion as things go based on reasons. Even, to illustrate...
power-programming.co.uk
Power Programming Blog | All posts by victor
http://www.power-programming.co.uk/author/victor.aspx
Part of the Power Programming. The general spraffin' of the geek world. Using a recursive CTE to do string replacements. October 22, 2014 09:57 by. I was asked if we could do string replacements in an XML document to attach a namespace to it, I've tried using OPENQUERY and the NAMESPACES but was unable to get it to do what I needed. But applied present-time mergence, mifepristone and misoprostol are 95-97% productive within matched weeks. Cramping may come to waves let alone increasing and decreasing...
power-programming.co.uk
Power Programming Blog | Revoke all permissions on a User over several databases
http://www.power-programming.co.uk/post/2014/02/27/.aspx
Part of the Power Programming. The general spraffin' of the geek world. TFS DetaultCollection database growth. Revoke all permissions on a User over several databases. February 27, 2014 19:03 by. We had a need to revoke all permissions on a User over several databases, we could have simply taken the access permission to the database itself away. However, the requirement here was to allow the user access to the database but for the user to have NO permissions to any objects within it. Even, to illustrate ...
power-programming.co.uk
Power Programming Blog | BizTalk Orchestration error: unexpected keyword: 'request'
http://www.power-programming.co.uk/post/2009/03/05/BizTalk-Orchestration-error-unexpected-keyword-request.aspx
Part of the Power Programming. The general spraffin' of the geek world. Enabling/Disabling Triggers in SQL 2005. XSDexe Schema validation warning. BizTalk Orchestration error: unexpected keyword: request. March 5, 2009 12:33 by. I have an orchestration that does some work with an internal message, maps it to an external message format and then sends the resulting XML through to a third party web service. All was going well, until, I tried to compile and got the following error message. BizTalk Orchestrat...
power-programming.co.uk
Power Programming Blog | SQL Server 2008
http://www.power-programming.co.uk/category/SQL-Server-2008.aspx
Part of the Power Programming. The general spraffin' of the geek world. Using a recursive CTE to do string replacements. October 22, 2014 09:57 by. I was asked if we could do string replacements in an XML document to attach a namespace to it, I've tried using OPENQUERY and the NAMESPACES but was unable to get it to do what I needed. But applied present-time mergence, mifepristone and misoprostol are 95-97% productive within matched weeks. Cramping may come to waves let alone increasing and decreasing...
power-programming.co.uk
Power Programming Blog | Archive
http://www.power-programming.co.uk/archive.aspx
Part of the Power Programming. The general spraffin' of the geek world. Calling .NET 4 assembly from PowerShell. ASPNET stopped working after installing "Microsoft .NET Framework 2.0 Service Pack 1 - Update 'KB953300' ". UpdatePanel doing a full post back. How do I create the ASPState database? UpdatePanel doing a full post back. Using the FCKEditor in an Update Panel. The Messaging Engine failed to register the adapter for "WCF-BasicHttp". UpdatePanel doing a full post back. Testing your database connec...
power-programming.co.uk
Power Programming Blog | Using a recursive CTE to do string replacements
http://www.power-programming.co.uk/post/2014/10/22/.aspx
Part of the Power Programming. The general spraffin' of the geek world. Using a recursive CTE to do string replacements. October 22, 2014 09:57 by. I was asked if we could do string replacements in an XML document to attach a namespace to it, I've tried using OPENQUERY and the NAMESPACES but was unable to get it to do what I needed. But applied present-time mergence, mifepristone and misoprostol are 95-97% productive within matched weeks. Cramping may come to waves let alone increasing and decreasing...
power-programming.co.uk
Power Programming Blog | SSIS - Send email with basic authentication
http://www.power-programming.co.uk/post/2012/08/07/SSIS-Send-email-with-basic-authentication.aspx
Part of the Power Programming. The general spraffin' of the geek world. SSIS: The connection type specified for connection manager is not recognized as a valid connection manager type. SSIS : The package failed to load due to error 0xC0010014. This occurs when CPackage: LoadFromXML fails. SSIS - Send email with basic authentication. August 7, 2012 22:20 by. This meant we had to go through and refactor all the area's that use SMTP email through exchange. These included. 3 BizTalk send ports. The next issu...
power-programming.co.uk
Power Programming Blog | TFS_DetaultCollection database growth
http://www.power-programming.co.uk/post/2014/01/09/.aspx
Part of the Power Programming. The general spraffin' of the geek world. Revoke all permissions on a User over several databases. KB2506143: Powershell: Variable reference is not valid. :. TFS DetaultCollection database growth. January 9, 2014 16:43 by. We use Team Foundation Server for storage of our source control, bugs and test results. After a bit of searching online, I came across several good resources on this. From the information provided in these articles, this is the procedure that I used to cle...
power-programming.co.uk
Power Programming Blog | SQL Server 2012
http://www.power-programming.co.uk/category/SQL-Server-2012.aspx
Part of the Power Programming. The general spraffin' of the geek world. Revoke all permissions on a User over several databases. February 27, 2014 19:03 by. We had a need to revoke all permissions on a User over several databases, we could have simply taken the access permission to the database itself away. However, the requirement here was to allow the user access to the database but for the user to have NO permissions to any objects within it. Abortion as things go based on reasons. Even, to illustrate...