For comparison with the...

Grant Fritchey (9/22/2015)

---

That totally varies by company.

My last employer had four levels: Junior, DBA, Senior, Principal

We were part of the overall IT organization, under a VP responsible for Server Administration,...

Thanks to all. Very helpful.

lrosini (10/11/2013)

---

Looks like a permissions issue to me - "current user does not have permissions on that object". Check that the user you are executing as has permissions to the...

Here's the full SQL Server stored procedure for reference. Yes, the Oracle procedure returns 5 result sets each with one column (don't ask... I have no good answer and the...

Thanks for the suggestion. Explicitly defining result sets using WITH RESULT SETS (...) returns the...

Erland,

Thanks for your help and advice.

It was on SQL Server 2000 prior to moving. I made a mistake in my earlier post also: it's not on SQL Server 2012 now,...

Oh dear... you're testing my memory with that one...

If I recall correctly, you'll need to allow an inbound rule for either the msdtssrvr.exe executable or the port SSIS listens for...

@@version will report the version of the node currently serving the instance. I believe you would need to fail over the SQL Server instance cluster service to the node you...

Thanks for all the input! I will be publishing our policy in the next couple of weeks, and I believe it is better for the information in this thread.

Thanks again.

By the way, SQL Server consuming all its available memory isn't unusual. In fact, it's usually a good thing when configured right and the OS has room to breathe. I...

There are so many variables to consider in memory usage problems. If...

Glad...

foxxo (10/3/2012)

---

Im in medium-large organisation and production changes are handled by ITIL practises. The change initiator or sys admin raises an RFC which is risk assessed and approved by...

Thanks, all. It seems every post confirms my thoughts on exclusion.

Love the community here, I knew I'd get some good answers.