another thing to keep in mind with any hints is :

As with data volume changes, you'll also have to check their working and the need for them every time...

just my 2ct to solve a design flaw...

- Since it can only hold one the the 4 key values, maybe actually design 4 columns with fk ref to their corresponding...

Adam did a great series about using whoisactive .

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/30/twenty-nine-days-of-activity-monitoring-a-month-of-activity-monitoring-part-30-of-30.aspx

If you find any problems contact him directly.

He'll appreciate your feedback and he reacts fairly quick.

I use the (also free) WhoIsActiveUI...

what's the rowlength / setsize of the returned set ?

checksum can produce duplicates !

So, even when using a checksum column to identify a row, best is to still add e.g. primary key columns to be sure you are modifying...

SQLRNNR (5/4/2011)

---

ALZDBA (5/4/2011)

---

Maybe this can help out.

Failedconnectiontracker is using sqlserver event notifications to capture all login info.

We have a dba database on every sqlserver instance to host all sysadmin/dba systems...

I'm glad you managed to use the failedconnectiontracker 😉

So it must be a local process, non sqlagent direct related.

( i mean a sqlagent job has recognisable text sqlagent in the...

that may be normal, depending on the size of your table.

The clustered index actually holds the data rows at its leaf level (bottom level)

So, if you drop the clustered index,...

Maybe this can help out.

Failedconnectiontracker is using sqlserver event notifications to capture all login info.

We have a dba database on every sqlserver instance to host all sysadmin/dba systems stuff.

In the...

Did you manage to resolve your question ?

- can you post @@version information of your sql2005 instance?

- did you perform post migration maintenance on the db ?

( DBCC CHECKDB (0) WITH ALL_ERRORMSGS, DATA_PURITY;

...

no !

e.g. db_datareader database group is allowed to read all data of all tables and views

do you have the needed authority to view that info ?

Ninja's_RGR'us (5/4/2011)

---

P.S. If it's THAT urgent then hire someone to do it for you.

This is advanced stuff and you should not start that project under pressure. And...

bitbucket-25253 (5/4/2011)

---

Jeff Moden (5/3/2011)

---

mtassin (5/3/2011)

---

WayneS (5/3/2011)

---

ChrisM@home (5/3/2011)

---

Jeff, please please please write a book, without changing your style. Give us all an opportunity to repay you for what you've done for...

Gianluca Sartori (5/3/2011)

---

OK, now it definitely works.

I got it working after a long fight with permissions, policies, and registry keys.

...and I thought that a DBA didn't need to be...