this seems to get me most of the data sources in the current catalogs as a direct query:

WITH MyCTE

AS

(

select convert(varchar(max),CONVERT(varbinary(max),Content))As StrContent,*

from reportserver.dbo.Catalog

)

SELECT SUBSTRING(StrContent,p1.i,p2.i - p1.i),* FROM MyCTE

CROSS APPLY(SELECT...

reports change very rarely...can you simply restore the ReportServer database to the day before you stepped on the data source?

if not, can you restore the database as a different name,...

sounds like windows firewall to me.

you can prove it real quick by simply turning off windows firewall, and trying to connect from another machine.

the right thing to do after that,...

Glad it helped you Rick!

with 20K+ hits on this thread, it's clear that it's probably helped more than just the folks who were kind enough to post a thank you!

glad...

bradh 14842 (3/25/2015)

---

I am trying to figure out the best method for transferring SQL 2005 databases from 2 different physical servers to a new server running windows server 2008 64bit.

I...

i think you have to extract it from the GAC(Global Area Cache?)

c:\windows\assembly\GAC_MSIL or %windir%\assembly\GAC_MSIL

you shoyuld see a fodler there with the dll name, IF it is installed.

ie Microsoft.SqlServer.Management.Common

inside you'll probably...

this is really a security problem.

developers should not have access to production data.

it sounds like now you supsect or are afraid that they can touch the data, but you still...

i think google is probably your friend on this one: i think this one was the better resource than anything i got from MSDN

http://windowsitpro.com/windows-server/rename-nodes-cluster

i've never done it, but the article...

or is there an incremental primary key in the Oracle source that you can just select fromOracle where the source...

there's applicaitons specifically designed for monitoring servers and services; a search of network monitoring sql server will get you a zillion apps. in a shop with 350 sql servers, your...

....combined with a server stop and start, that is correct...but not as a stand alone command.

...

the running values for @@servername stay in place, until the service is stopped and started.

if you select * from sys.servers where server_id = 0, that is the new name, of...

i didn't compile this or test it , but it looks right to me;

what if you return SQL values? SQLDouble will implicitly convert to Double, i think?

you might have to...

well i know we have some monitoring apps on the network that use WMI calls;

if i use a powershell query that uses WMI, do you think it might...

sp_who3 is not a built in proc from microsoft.

my google search found at least four versions in the top ten results, so you'd have to look to the source itself.

http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3

i...