Guys,

There's a little bit of misinformation in some of the posts here - copying to a UNC target is generally the same as copying to the same...

Anyone using roll-your-own scripts may want to check out QuickLZ[/url] - fastest compression speed around, at the cost of a modest compression ratio. If not overrunning your backup windows...

Good to hear!

Regards,

Jacob

How exactly are you running the remote SP? You will need to ensure that your MSDTC setup is working properly if you want to insert the results of the...

This thread is gold 🙂

Regards,

Jacob

Well, since you can create a login based on a Windows group you can map that login to a user in your DBs, so you could implement a security model...

You can get "SQL Server 2005 Code Recovery" from here[/url] that does the 2005 DAC decrypt for you in a no-brain manner if you don't mind paying a little.

Regards,

Jacob

This is a non-trivial problem. It's not entirely clear what the OP wants but if it's as Jeff suggests it's going to be tricky. We do a similar thing...

rholt (4/16/2008)

---

ok - i'm sort of understanding this, but would the fact that I have RS loaded & running on my PC constitute a 2nd hop or just a...

A quick quote from BOL (Specifying Credential and Connection Information):

BOL

---

When sending a connection request over the network, the report server will either impersonate a user account or the unattended execution...

@rholt:

It sounds like you may be running into a Kerberos delegation issue. Are your RS server and the source DB server running on different boxes? If so you may not...

Ben Sullins (4/14/2008)

---

Yeah so if you're data set(s) read directly from the database then you need to make sure the account you're using has db_datareader on whatever DB's it is...

Jeff Moden (3/19/2008)

---

I've got an MS URL that explains the blocking in 6.5 somewhere. Lemme see if I can dig it up... I've always gotta prove these things so...

EDIT: Just re-read Mike's post and it sounds like his formula works...

@sergiy: No, you're right - I can't :blush:

Just did a quick test using both inline and scalar UDFs for some test data based on the OP's sample....