Thanks Grant.

Thanks Grant.

Try this in your SQL

xp_logininfo 'Domain\account' the account might be in some groups

Grant Fritchey (2/23/2016)

---

Transactions and transaction playback, log shipping, are not the same as a backup, a page-by-page copy of the database. The processes of restore are different. The at rest...

Grant Fritchey (2/23/2016)

---

VPlex I believe copies stuff at the page level? If so, yeah, it's likely to replicate corruption.

Log shipping (or, since we're in the 2014 group, Availability Groups, a...

Alert Summary:

Average Wait Time monitor for SQL 2014 DB

The average amount of wait time (milliseconds) for each lock request that resulted in a wait. Based on the DB engine counter,...

TheSQLGuru (2/14/2016)

---

I agree with Eddie (big surprise - Hi Eddie!!). 🙂

Waits are cumulative in SQL Server, so they are pretty useless just looking at them in isolation. What you need...

Eddie Wuerch (2/14/2016)

---

Is there a Wait Type listed? What's the full message?

A "waiting" thread is simply one that isn't doing anything. For example, the lazywriter thread is usually waiting...

johnwalker10 (2/11/2016)

---

You need to set a password for the Credential that is associated with the proxy. To do this, right click on the credential and select properties. Enter...

SQLSlammer (2/11/2016)

---

In Management studio, browse to security / credentials, right click on credentials and select create new credential, give it name and the user account and password you want to...

what all permission you want to give??

datareader,datawriter,db_executor,ddladmin will work for you...

Phil Parkin (2/10/2016)

---

VastSQL (2/10/2016)

---

Hi Experts,

We have a powershell which we need to run from one of our SQL Servers. The script checks for a particular service in 4 servers and...

Thanks SQLSlammer.

SQL Service and agent account looks fine. Can you guide me...

You sure you have proper installation media?? Whats the size ?

Try running it with administrator...

GilaMonster (2/3/2016)

---

No. If I'd meant to say that, I'd have said that.

If TrackID is...