thank you for the feedback.

everybody at ease now :hehe:

is it a checksummed backup ?

You could use this to verify its content:

Check out RESTORE VERIFYONLY to see how sqlserver can support you.

What's your knowledge about SQL2008 ?

Should you even be doing a restore ? ( is a restore really needed )

What are you trying to accomplish ?

it also depends what application opens your csv file.

Does that interpret carriage return characters, tabs, ...

What are your client settings and what are the separator characters used in the csv...

Thank you for the feedback.

Sharing your experiences and fixes will always help others.

I just wonder about the moment a job records it is executing a next step into sysjobhistory.

Will...

hard to believe that's the query that multiplied your [money] numbers by 10 :crazy:

Does your source table also use the money data type for these columns ?

Can you repro the...

is it configured to be using TCP\IP connections ?

how did you copy the data ? (statement please)

tt-615680 (9/11/2013)

---

Dear All,

When I tried to create a Linked Server I get the following error message would you please let me know what would cause the issue please?

Named Pipes Provider:...

did you check the sqlserver errorlog file if it holds error messages from the failed backup requests ?

t-sql is the language

sql server is the engine

as far as I know, there is no way of telling the connection actually comes from a linked server definition.

What you can do is do some connection tracking and...

for us - the db crowd - there has been no need to alter stuff as the mail team just re-routed the relay definition for smtp.

They prepared their action well...

We used smtp with exchange, so we had to get all ip-addresses granted to be able to use the smtp relay for dbmail.

I'm not even sure if we also need...

Soon the Thread will be posting its own ranted forum questions itself 😉