Example of mapped drive restore (assuming you even have access to use xp_cmdshell):

EXEC...

I've never used NET USE when restoring backups. The only way it would work is if run in the context of the service account, which would mean a two-stage...

Well, if you do that, you're going to use that bandwidth up when you do the copy instead of when you do the restore, so I wouldn't worry too much...

Divide by 100000000.0 and cast as decimal.

John

That's right. You have to specify a URL, not a mapped drive. The drive is only mapped in the context of your login session, and not that of...

Do you have foreign key constraints in your database, and are they trusted[/url]?

John

What have you tried so far?

John

Yes, I agree that it was worded too strongly. Can you think of any cases where it isn't possible to rewrite a series of UNIONs so that it contains...

But that's because you changed the order. The proviso was that the UNION operator is the last one to be evaluated. If you use parentheses to make it...

Sean Lange (5/16/2013)

---

John Mitchell-245523 (5/16/2013)

---

Phil Parkin (5/16/2013)

---

lnardozi 61862 (5/16/2013)

---

Just for completeness sake, you never use more than one UNION, which is the last one. All the rest should be UNION...

Does your text file connection in SSIS think that the top row is the header row?

John

I suppose because...

There's no reason a log backup can't run at the same time as a full or differential. Indeed, if your full takes a long time to run, and you...

I must admit that I wasn't sure whether, having aliased the table/view (let's call it object), you could then use the original object name in the SELECT list. However,...

Please don't waste everybody's time by cross-posting. No more replies on this thread, please - continue here.

John