FYI: I agree with the above statement. In fact, in SSRS, you can...

I'm taking a look at this now.

Just an FYI: Your DROP TABLE script will error out for those of us who don't have your table in our dbs. If you...

WhineWhine, RantRant, ComplainComplain.

Why does morning have to come so early? Can't it wait until I wake up for real?

[/rant]

So, are there any pastries or donuts at the water cooler today?...

Paul,

Thank you for that post. It was very informative.

Ah. Thank you for pointing that out.

I don't see either view or table called sys.objects$ (just did the Resource user db on my local dev copy).

Lowell, make sure to rename the db before you try...

Bad Lowell. We're not supposed to be selecting from Microsoft's secret...

...but I still love you guys. @=)

Spam.

This thread and The Thread are killing my inbox!

An ANSI character set is a set of numbers that represent every letter in the alphabet and every number from 0-9. They also represent punctuation marks, spaces, tabs, line breaks,...

Glad we could help. And very glad it wasn't something worse.

chandan_jha18 (7/27/2011)

---

Lowell (7/27/2011)

---

based on this ms doc, where changing the server collation requires a rebuild:

http://msdn.microsoft.com/en-us/library/ms179254.aspx,

i'm guessing that the server collation is actually the collation of the resource database, regardless...

Could you clarify what you're looking for in the result set. As you can see from the back-n-forth here, we all have different thoughts about what you're looking for.

Green

- Win. (7/27/2011)

---

If you are on Win 2003 box, you can give a try ,

Administrative Tools -> Local Security Policy -> New window - >Local Policies -> User Rights Assignment...