that's the text of the compiled object. So if that is (part of) a stored procedure it will show the sproc ddl ( unless it is encrypted ).

Using the...

- not every execution produces a recompile. ( that's the goal with cached plans )

I haven't implemented the xevents version to monitor it all, but I'll have a go if...

immaduddinahmed (9/18/2013)

---

i have a query

UPDATE dbo.cheeck

SET CheckTime = DATEADD(DAY, -1, CheckTime)

WHERE Status = 'O' and datepart(hh,CheckTime) BETWEEN 0 AND 11

i want to update a current date data please help...

if you rdp the source sql instance ( where you want to define the linked server ) can you use sqlcmd / SSMS ( if installed ) and connect to...

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