Just to reply to my own thread twice, this powershell queries WMI on the server to output the db and other info. You need similar permissions as you do to...

In case anyone else needs to do this, it looks like I can get it with a WMI query

MSReportServer_Config class

\\<servername>\ROOT\Microsoft\SqlServer\ReportServer\<instance>\v10\Admin there's a databaseservername property and other details.

Jacob Luebbers (4/15/2008)

---

@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...

There's also the issue that you won't get a parallel query plan if you modify a table variable, but temp tables are fine:

From SQL2008 BOL: http://msdn.microsoft.com/en-us/library/ms175010.aspx

Queries that modify table variables...

Question should be 'how are' not 'are are': "are are the security requirements "

Answer has 08 instead of 80.

interesting question though.

It can seem that the...

I think the problem with that approach is that if someone exploits one of your...

If you are concerned that these aren't native backups you can always do a simple test:

restore filelistonly from disk = 'C:\path\to\backup.bck'

This doesn't kick off a restore, it just displays a...

I wasn't suprised when I got it wrong, selecting only Database Engine, since I didn't know and couldn't envisage how it would work for those other services. I still can't.

i was sure i chose the 2nd one and was suprised when i got it wrong. But it said the correct answer was the one i thought i selected (the...

hahaha good call iplman 🙂

Yep, it was wrong when i tried it too. One person had it correct, guess they didn't read the question right 🙂

While c/p + modify of that didn't solve my problem, it did get me to the

correct section of .Net documentation 🙂 and with that + your link I

finally got it...

Hey Mark, thanks for that. Looks like it may just do it, will try it out tomorrow and see how it goes.

Took the London hint and updated my info.

Later,

Nick

If you can afford some down time on the reporting server then the easiest way may be just to disable publishing on your publisher (dropping replication), make your schema changes,...