Run that in a query window to get the statements that are represented.

For example, running this query using a truncated piece of your binary value:

[font="Courier New"]SELECT CAST(0x4445434C41524520405420 AS VARCHAR(MAX))[/font]

Returns this:

[font="Courier...

SELECT CAST(0x4445434C41524520405420 AS VARCHAR(MAX))

Make sure the binary representation has an even number of characters before decoding.

Mike Good (6/21/2008)

---

a) How can I identify these situations? I don't see anything akin to dbcc loginfo to help analyze data files, and I don't see any way to...

Andy,

First thing I'd do is run a DBCC CHECKDB against the databases you're backing up.

Second, since this started occuring recently I'd be looking at anything that was updated recently, such...

The simplest option, but maybe not the best, is to change how error rows are handled.

On the Flat File Source, select the Error Output. In the Error column for DOB...

NSort for SSIS might be of interest too. I haven't used it but the posts and articles I've read have been positive.

http://ordinal.com/ssis.html

One problem with HASHBYTES that might make it of limited use is it doesn't support more than 8000 bytes for input.

If interested, you can vote on this issue at Connect:...

Here's an example of using ADO.NET to start a stored procedure; built in Visual Studio 2005.

using System;

using System.Collections.Generic;

using System.Text;

using System.Data.SqlClient;

using System.Data;

namespace ConsoleApplication1

{

class Program

...

What's the error message you're getting when it fails?

You should be able to specify the '|' as the column delimeter and a '|' plus a newline character as the row...

Using Instant File Initialization in SQL 2005 should bring the creation time down significantly. If it's not enabled, zeros are written to the data and log files when initialized.

To...

In addition to specifying the wildcard character as a literal there's also the ESCAPE clause that can be used.

SELECT * FROM myTable WHERE column1 LIKE '%/%%' ESCAPE '/'

Querying the XML plan directly could help focus in on parts of that plan to look at.

-- Load the plan into an XML variable

DECLARE @xml XML

SELECT @xml = BulkColumn

FROM...

This is how we do that from workstations on the same domain. Never tried it from a computer that wasn't on the domain so it may not work in...

If you save the execution plan and attach it to a post someone might point something out; In the Excution plan window, right-click and Save Execution Plan As...

Also, have a...

jenelle.hilemon (6/4/2008)

---

Did you use Microsoft Outlook to create the list? Does Outlook have to be installed on the server that your trying to create the notification on? I have tried...