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...

Jeff Moden (5/3/2011)

---

ALZDBA (5/3/2011)

---

It's a pity some obscure character caught the attention of CNN, Bloomberg, Al Jazera, ... the day your great article got published.

For sure it would have...

It's a pity some obscure character caught the attention of CNN, Bloomberg, Al Jazera, ... the day your great article got published.

For sure it would have been a headliner...

IMO this thread http://www.sqlservercentral.com/Forums/Topic1044430-391-1.aspx is a very good ref on DISK/SAN troubleshooting.