Do you have permissions to run powershell scripts?

gen-pop

While XE can provide you some of this info, the better approach is to set up a Server and Database audits (http://technet.microsoft.com/en-us/library/cc280386.aspx[/u]).

And yes, a DBA with sysadmin can alter those...

Jeff Moden (4/5/2014)

---

So, yeah... I agree... hardware and hardware tuning are important but, if you really want to make an improvement, remember what most people won't even consider because hardware...

You need to include a from clause in your update.

Can you provide more information on what your rules for performing the update are?

Read that article, it goes through the troubleshooting steps to help you resolve the issue.

MyDoggieJessie (4/3/2014)

---

I manage 21 servers with about 12 DB's per server, total size is about 11TB (with 2 servers accounting for 9TB of that total amount)

Good Lord Jason :w00t: ...

mishka

I...

Sean Lange (4/4/2014)

---

TomThomson (4/3/2014)

---

Steve Jones - SSC Editor (4/3/2014)

---

Revenant (4/3/2014)

---

Sean Lange (4/3/2014)

---

This is...

Well well well, another blog to read. I don't...

Here's an article on that error and how to troubleshoot it.

http://www.sqlservercentral.com/blogs/brian_kelley/2013/04/22/troubleshooting-sql-server-error-15517/

FWIW, I managed 4500 servers at a previous job with over 10,000 databases.

I recently managed over 200 servers for various clients with total DB size over 50TB.

It all kind of...

Mommy