You might be able to get something from the log file depending on your recovery model.

Ultimately not a lot you can do with 2000 after the fact, if you haven't...

Eric M Russell (7/22/2014)

---

benjamin.reyes (7/22/2014)

---

Eric M Russell (7/22/2014)

---

Andy Warren (7/22/2014)

---

That said, today in 2014 (and ever since the mid-1990's), there are much better options than MS Access if you're looking...

Eric M Russell (7/22/2014)

---

Andy Warren (7/22/2014)

---

That said, today in 2014 (and ever since the mid-1990's), there are much better options than MS Access if you're looking for a platform to...

These run from the command line.

This finds the users in an AD group:

net group /domain NAMEOFGROUP

This finds the groups an AD user is in:

net users THENAMEOFTHEUSER /domain

Sounds like it's coming from the machine sql server is on? Is there any other apps or services, such as a cluster that may be trying to log into...

Re-reading the original post, is there a reason why you haven't disabled the sa?

The windows event usually shows an IP address that the request came from. I usually start there.

Do a tracert on the ip and see where it's coming from.

From there...

I've always thought the similarity between the surface and the old roman wax tablets was interesting.

ntrovato (6/10/2014)

---

I will be using Steeleye Datakeeper to do the clustering of SQL 2008 ... it does not require shared storage. See below.

http://clusteringformeremortals.com/2009/09/15/step-by-step-configuring-a-2-node-multi-site-cluster-on-windows-server-2008-r2-%E2%80%93-part-1/%5B/quote%5D

That looks interesting. What's the...

http://technet.microsoft.com/en-us/library/cc771404.aspx

You'll need shared storage for a 2008 cluster.

What types of failures are you trying to prevent with a windows cluster? Have you looked into using VMWare or Hypervisor for...

How much downtime is acceptable? How big are the databases? How similar is the hardware? What sort of storage are you working with?

As far as I know,...

Doctor Who 2 (5/21/2014)

---

Hmm. What you said, Matt, gives me pause about Robert Half. Another one in this area is Sabio Systems; have you ever heard of them? If so,...

You should stop looking at task manager for ram used, SQL Server lies to task manager. As well, the statistic for "Active Memory" in VSphere is not accurate.

"Task Manager...

http://technet.microsoft.com/en-us/library/ms190646.aspx

To save an execution plan by using SQL Server Management Studio options

Generate either an estimated execution plan or an actual execution plan by using Management Studio.

In the Execution plan...