Stefan Krzywicki (7/25/2012)

---

Brandie Tarvin (7/25/2012)

---

You know, I just realized we forgot to give you a VR noogie for titling your post "weird error" without any additional details. @=)

Shame! (waggles finger...

You know, I just realized we forgot to give you a VR noogie for titling your post "weird error" without any additional details. @=)

Shame! (waggles finger in Stefan's direction) You...

The interesting thing is that I have those collations and I have the Report dbs on my production server and my script works just fine.

I always develop my scripts in...

Excuse me a moment.

<hides mouth behind hand> ROTFLOL

</puts hand down>

That's okay. No harm done.

Your Name Here (7/24/2012)

---

Brandie

Thanks for the script - I'm sure it'll come in handy. One FYI though: the dynamic SQL didn't handle collation conflicts (doggone that ReportServer db... <grin>)....

Fixed!

Resolved the problem by editing the script, opening up Project Explorer, right-clicking References and adding a Reference to Microsoft.Office.Interop.Excel.

rodjkidd (7/24/2012)

---

While waiting for some reasonable sized databases to back up before doing some upgrades, I finally managed to have a stab at answering a question today. No one else...

You're welcome. Let us know if you need anything else.

Andrew Cruz-Moores (7/23/2012)

---

Greetings All!

I have log shipping configured between a primary and secondary server. The secondary server will not restore files if they are not in the files name...

Are you running SQL on a virtual machine?

I'm wondering if there are several SQL installs on the physical box in question and memory used by others is reflecting in the...

This one can be answered by using Google or Books Online. If you don't have Books Online, grab your install DVD (or .msi) and add it to your client tools...

Microsoft's own online tutorial for SSAS: http://technet.microsoft.com/en-us/library/ms170208.aspx

Lynn Pettis (7/23/2012)

---

SQLRNNR (7/23/2012)

---

Just grant them access to the Dev instance on the server rather than RDP. Then install management tools on their desktops and allow them to use...

If this webhosting needs database restores, you really need to contact your DBA team. Obviously they didn't set up the correct permissions and they need to if you want to...

"Help me, Obi-Wan Tracenobi. You're my only hope!"

Running away now. @=)