Grant Fritchey (1/22/2014)

SQLRNNR (1/22/2014)

No, schedule regular...

From what you describe in the original post, yes, the DBA's can probably do everything described without RDP access. You can view the event log, file sizes, etc. etc....

Do a search for Ola Hallengren. He has everything you need.

New golf clubs, and time to practice with them so that I can get my game close to where it once was.

But, as a DBA, I would have made sure that the data was clean before attempting an import!:-)

Jeff Moden (11/9/2013)

Gary Varga (11/8/2013)

Absolutely, but in the context...

You're still not very clear. And I couldn't resist the wise guy response...

Is the source of the data rows in a table? A string?, Something else?

CREATE FUNCTION dbo.ListPassengerNames()

RETURNS varchar(8000)

BEGIN

RETURN ('James, John, Bob, Kate, and Julie')

END

Go

This looks like an import problem!

Is the sample data you provided in a database table? If so, how did it get there?

It looks like the output into a...

Look at RDX also.

bryan van ritter (9/17/2013)

i am trying to convert a nvarchar column to a decimal value.

the nvarchar column has empty records as well as NULL values.

now when i try...

Microsoft's move in this area does not surprise me.

Simply put, they were not making money on this program. They probably are making lots of money on the...

I can tackle this. I have a good one in place in all of my databases. The script has been passed around the block many times.

Gee, this sure sound like using BCP in character based mode would do the trick.

BCP DatabaseName.schema.table OUT FileName.csv /m 100 /b 100 /e TableName.err /c /t\, /r /S ServerName /T...

This appears to be a significant design flaw.

The first question is would address be considered an entity, or is address really an attribute of Other entities? :Salesman has address"...