I was going to suggest 'xp_cmdshell 'hostname' but i have tried it and it just returns the virtual server name (though works when done straight in dos).

So I created a...

Chris Helm-389957 (2/8/2010)

---

Hi Adam thanks for responding.

I know I can do that manually, but I've got 4 reporting servers to keep an eye on and no DBA with the time...

Might be to do the local keyboard/language set on the remote system.

Set up another remote machin with vpn and try that, bu if other users are fine, then its gonna...

As long as it is ONLY for testing and developing solution for your live SharePoint, it should be ok. If you have any further questions you should either...

If you browse in your ssms object explorer down to Objects' and the click 'Linked Servers', the linked servers list will appera in the right hand windows (Object Explorer...

This seems to address your issue (i found it with a quick google).

Try what it suggests (make a copy of you mdf first) and get back to us.

sorry forgot link:...

Was the database still shwon in the databases list?

Have you tried attaching via th ssms gui (removing the entry for the log)?

Did you google the output?

If the databases still shows in your databases list, the first thing to do is drop it. To do this, take it offline and then detach.

After that attach the mdf...

chris.dunn-795452 (2/4/2010)

---

For a week I commuted 80 miles each way then thought hell no and asked work to put me up in a hotel, which they obliged since I was...

Cant imagine ever doing that. Us Lononers are bone-idel really 😉

Steve, dude!

No job is worth that! Unless your getting multiples...

Lynn Pettis (2/3/2010)

---

Officially, sys admin for a Data General MV4000 system that a print/fulfillment...

Just so im gettin this right, you drove 180 miles a day!? What was the job?

FCC have recenetly settled driver dispute, so the service was meant to be getting better (more trains with more carriages (4 vs 8)). Well the service on Monday wasnt bad...

What do yoou mean 'SP' :ermm: