using cursors or loops to generate commands that pull from metadata related to objects are what i consider the exception to the general rule of avoiding cursors/loops.

the avoid cursor rule...

I believe the permission GRANT VIEW DEFINITION TO [MyDomain\LOWELL] is what you are after.

Agreeing with Hugo here; certainly possible,it would just take a naming convention to do this.

I would think it would be a LOT easier just to name each backup by the...

i think you are right about hardening/permissions being the issue.

When i run xp_logininfo against non-existing domain\group

or exisitngdomain\fakegroup, i get blank results, no error.

That makes me think it's permissions

exec master..xp_logininfo...

welcome aboardSSC!

i converted your post into an easily consumable format...now anyone can copy/paste/test.

the intersect and except operators are an easy way to compar esomething like this, if you are expecting...

I believe Registered Servers are SQL only, so are you looking in the "Local Server Groups", or did you actually create a central management server to store the info?

Central Management...

your test data wasn't readily consumable, you inserted into the temp table without a definition for it.

here's the data as my best guess for the setup portion: the dynamic pivot...

Can you modify the procedure, since you cannot use openquery?

sounds like a one procedure to rule them all situation, not the best way to do things.

I would modify the proc...

river1 (1/3/2016)

---

Thank you lowell.

Just two more questions.

1) You say that shared connections are also deployed. What about it the connections are not shared (if they belong just to that...

your project deploys SSRS reports and other objects(shared data sources, etc) and it stores the reports as xml in the ReportServer.dbo.Catalog table in [Content] column, which is a varbinary column...

Jeff Moden (12/28/2015)

---

If it turns out to not be setup and no one...

sp_help ENROLLMENT_IN is one way, you can scroll down to the foreign leys.

another way, you can use the metadata to find out the information;

select * from sys.foreign_keys WHERE object_id =...

another version, which takes into consideration if the birthday has passed or not:

DECLARE @DOB datetime

SET @DOB='1962-12-11'

SELECT CASE

WHEN DATEPART(DY,GETDATE()) >= DATEPART(DY,@DOB)

...

to a high degree, every snippet of code is written with automation in mind. i think that's probably a best practice where possible.

today might be six servers, but tomorrow, what...