Geeks With Blogs
Sean Carpenter Thoughts on Development SQL Server
SQL Server 2005 SP1 Released
Well, after a relatively short CTP, SQL Server 2005 SP1 has been released. This should be pretty cool, since the CTP solved the problems I was having with Import/Export. [Found via David Hayden] ......

Posted On Wednesday, April 19, 2006 10:34 AM

Changing the Receive Handler for a BizTalk 2004 Receive Location
This is actually pretty basic, but I had a hard time with it this morning, so I thought I'd share how to do this. I created a host and host instance on our BizTalk server specifically to host the receive locations we are running. Creating the host and instance was no problem, but I had a hard time changing the receive locations to use the new host. In the BizTalk Administration Console as well as in BizTalk Explorer, there is a place to choose the Receive Handler - the problem was that this dropdown ......

Posted On Tuesday, March 28, 2006 6:55 AM

SQL Server 2005 SP1 CTP
The SQL Server 2005 SP1 CTP is available for download.  I'm going to be trying it out immediately since one of the included fixes is for the problem I was having with the Import/Export wizard.

Posted On Friday, March 17, 2006 5:07 AM

SQL Server Backup to UNC Path Failing
We back up our SQL Server databases to a central storage machine using UNC paths in the BACKUP statement (BACKUP DATABASE db1 TO DISK='\\storage\Backups\db1... For a while, backups were failing with the message: BackupDiskFile::RequestDura... failure on backup device '\\storage\Backups\db1\db1.... Operating system error 64(The specified network name is no longer available.). I struggled for a while to find a solution and finally found this thread on Unfortunately that ......

Posted On Wednesday, February 15, 2006 6:54 AM

Text Report of SQL Dependencies

This is a bookmark for myself as much as anything else, but here is Raymond Lewallen's script for generating a text based dependency report for a SQL Server database.

Sql dependency report from query analyzer

Posted On Thursday, October 20, 2005 12:45 PM

Inserting Base64 Data, Part 2
One thing I forgot to mention in yesterday's post: it is possible to have SQLXML do the conversion from Base64 to binary using an updategram. When using an updategram, it is possible to specify a mapping schema, which lets you use attribute names in the updategram that are different than the column names in the table. A mapping schema also lets you specify data type conversion, one of which is Base64 to binary. Here's a brief example: Mapping Schema<xsd:schema xmlns:xsd="http://www.w3.or... ......

Posted On Thursday, October 20, 2005 7:04 AM

Inserting Base64 Data into an image Column
I recently had the need to insert some binary data that was encoded as Base64 into a SQL Server image column. Since I was using BizTalk, I was hoping it would be relatively straight forward - I was wrong. There's a bit of information here on how I came to this problem and some BizTalk stuff, so if you just want the solution, jump to here. The Background I was using BizTalk to pull a record from one SQL Server, do some processing on the data, and then insert the processed record into another SQL Server. ......

Posted On Wednesday, October 19, 2005 1:09 PM

Copyright © Sean Carpenter | Powered by: