if you connect via IP address instead of server name, is it near-instant? maybe it's still networking/dns?

how about fully qualified instead of WINS name?

ie connecting to 10.40.10.100 or SQLProd.Yourdomain.local or...

since you are restarting the instance, and it takes a long time, i'd say it's because the databases are not coming on line quickly.

the first thing i would check is...

what do you mean by varying results ? is the data the SSIS touches absolutely static(ie a staging table only you touch, with no joins to other data), or are...

CELLIOTT-497809 (1/8/2016)

---

Verified with 2 other users and they are getting the same error. One of the users was a Domain admin account. BTW... I forgot to add the...

CELLIOTT-497809 (1/7/2016)

---

I have a SQL 2012 Server that I am not able to access from my workstation using SQL MGMT Studio with my Active Directory username. However, I am...

just to confirm, there is no way to cross apply and execute RBAR style;

since you mentioned you had a procedure you want to call, you could modify or copy procedure...

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