Chad Crawford (11/17/2011)

---

Wahoo! Just passed the MS 70-453 test, making me a MCITP for SQL 2008 just in time for 2012 to come out. 😀

Very happy - Passing...

And where does the data come from?

Is it possible to post the DDL's of those 3 different tables, some sample input and the desired result? (read the link in my signature about posting questions).

It is not...

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1207038-17-1.aspx

You can use the approach explained in this thread:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3db067f2-628e-432d-aa25-f63b1ccb1dfa/

Here you go:

http://sqlblog.com/blogs/andy_leonard/archive/2011/11/10/1631.aspx

True, even I can do some .NET coding, but I rather stay far away from XML 😀

Maybe this question is more appropriate on a .NET forum? There will be people who are more proficient in coding .NET and having more experience dealing with XML using .NET.

Do you get an error or something like that?

What does your report do? Where does the data come from?

If the remote machine is outside of your LAN, won't FTP be a better choice?

If it is not, do you have a UNC path or something like that? If you...

Useful links:

http://blogs.technet.com/b/seanearp/archive/2009/03/14/renaming-crazy-sharepoint-database-names.aspx

http://www.raregrooverider.com/post/2008/02/04/Renaming-a-SharePoint-Central-Administration-Database-with-a-GUID-Appended-to-the-Database-Name.aspx

http://msmvps.com/blogs/shane/archive/2010/11/04/rename-the-sharepoint-2010-performancepoint-database-to-remove-the-guid.aspx

Some article said you could change the names of most of the databases during installation. This was 2007, so I don't know if it is still possible for SharePoint...

Good question, but a bit easy for 2 points.

Ninja's_RGR'us (11/16/2011)

---

GSquared (11/16/2011)

---

Roy Ernest (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

L' Eomot Inversé (11/16/2011)

---

But it was Remi who said it, and in the thread, and the combination of those two factors seems to me to...

SQLRNNR (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

Why, what would you guys do in his shoes?

Dev (11/16/2011)

---

I had one of those. I sat down with the architect and explained to him what NoLock...

GSquared (11/16/2011)

---

Or change your subscription settings on The Thread and don't bother with e-mails from it.

I already know it will be updated throughout the day just about every day. ...