It sure is! But then I ask why the installers can even start up and pretend to function if the disk image is incomplete. But that's my QA persona not...

Resolved. It turned out my .iso file was incomplete. < 2GB when it should've been closer to 4GB. I downloaded it anew and am good to go.

Resolved. Profiler shed the light I needed. There was a old but still enabled\scheduled SQL job firing off and never stopping as it didn't accommodate for NULLS in its final...

It is a 64 bit 2012 R2 server. I'm not the original owner of it so I don't know what it's been through. I'm tempted to request a rebuild of...

I'm comfortable with traces, just which events to trace might be the question. I can't readily reproduce the behavior either. The server ran fine for days after the last time...

This is on an older QA server of mine that's been starting to act a bit weird. It's running applications that are released and running in the field for months,...

Aaah. Thank you!

Ah, Mark, that's what I was forgetting. Thanks!

I finally figured it out. I ended up creating dummy databases on the two SQL instances and the sa account was connecting to the wrong one. Both had the same...

Well I'll try to explain better...

One solution would be to create a UDF instead of a view and pass in a user guid into that UDF which queries the account...

Ok. A-scripting I shall go!

Thanks guys, yes I see the numbers in the properties of my SQL 2005 so that's good info.

And Gail, reading this I came to realize that as well. The...

Thanks so much! There's a lot in there to wrap my head around, I'm still learning the xml manipulations. I hadn't provided any further info as it didn't matter to...

Yes it helped, I had this info from another site I'm not familiar with, your post confirmed for me it's the correct solution in my case. Lots of posts on...

Unfortunately I can't control the comma-delimited string, that's the way the developers designed it and the end applications read off that field, NOT the Projmembers table where they do get...