Craig Farrell (12/2/2010)

---

:blush: And I feel like an idiot for not taking the 3 minutes to keep reading the thread. I was under the same understanding as he...

Craig,

The next comment (by RLF) in that thread clearly states a Windows Group cannot own a job, which matches the documentation in [1] and [2] referenced above. Then Andrew...

I figured this out. The version of the server is Standard Edition.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

results in:

10.0.2531.0SP1Standard Edition (64-bit)

Tried it as a user with server role sysadmin, and another time as 'sa'.

Both times 0 records:

select *

from sys.configurations

where

name = 'common criteria compliance enabled'

...

Lynn Pettis (5/10/2010)

---

Can you post some sample data that represents the data you receive, including edge conditions that can cause problems and then what the corrected data should like before...

As a brief aside, I envy those of you who can fix these problems internally.

We recently had a customer decide for us without our input that they would hire a...

Lynn,

I'll agree that Paul's OPENROWSET idea in conjunction with the "don't blit, just load" trick you mentioned at the beginning of this thread can form a good solution. I...

Paul White NZ,

I appreciate everyone's help. I simply haven't found a solution that fits my awkward/dumb problem.

I'll thank everyone when/if I have a solution, giving credit to the lucky...

Paul White NZ,

Your solution doesn't work on edge cases where data elements themselves may contain pipes.

As for using CLR, we use CLR heavily here in many exotic ways, especially for...

Yes, of course, I've done all that debugging. The problem is there is no way I know of to use SSMS + Agent such that I can see what...

CREATE TABLE [dbo].[zz_u_test_TEMP](

[col1_dirty] [varchar](50) NULL,

[col2_dirty] [varchar](50) NULL,

[col3_dirty] [varchar](500) NULL,

[col4_dirty] [varchar](50) NULL,

[col5_dirty] [varchar](50) NULL,

[col6_dirty] [varchar](50) NULL,

[col7_dirty] [varchar](50) NULL,

[col8_dirty] [varchar](50) NULL,

[col9_dirty] [varchar](50) NULL,

[col10_dirty] [varchar](50) NULL

) ON [PRIMARY]

9.0

16

1 SQLCHAR 0 0...

I'm not sure you understand the problem.

bcp does not have a good way to represent NULL values in format files. If character data that contains a delimiter is escaped...

Just to be clear, does that mean you will post a benchmark confirming the 10x increase reported by the vendor? I can understand if the vendor has license restrictions...

That strategy is working out well and giving us some head room to plan for our next round of servers where we can properly plan and size them with Fusion-IO...

You can circumvent the max index key size

http://blogs.msdn.com/anthonybloesch/archive/2009/11/23/implementing-uniqueness-constraints-on-large-columns.aspx