some may consider the extra space a security feature :crazy:

Simplest way is to modify the job step command and remove the space.

If you cannot rename the database (which may need...

it depends on the SLA for "high available".

Of course, mirroring can be configured to be synchronous, but is depricated for future versions, because Always On is the "new" kid in...

did you try:

select c.*, u.*

FROM Company c

INNER JOIN SAMINC.dbo.ARCUS y

on y.IDCUST = c.comp_companyid

inner JOIN SAMINC.dbo.ARSAP z

on z.CODESLSP = y.CODESLSP1

inner...

start it all running the Upgrade Advisor for SQL2008R2!

This free tool will notify for potential issues.

have a look at Using Upgrade Advisor to Prepare for Upgrades

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 ?