|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
19/05/2008, 17h59
|
#1 |
Messages: n/a
Hébergeur: |
How to verify all records touched/accessed in a very large table
Hi all
Using Sql server 2005. I would like to know if there is a utilty or if you have any ideas on finding out which records have been accessed in a very large table? basically I have a table that is accessed by many users and I want to know which records have been accessed in this table by the users. I could use this info to me in testing: I would only test the unaccessed records! Is there a utility or "internal" procedure that can with this? Thanks in advance; |
|
|
19/05/2008, 18h13
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: How to verify all records touched/accessed in a very large table
Answered in another group. Please don't multi-post.
"Sbell" <placidite1@yahoo.com> wrote in message news:3ebcefc4-f917-487e-9bf4-03018462f05d@f63g2000hsf.googlegroups.com... > Hi all > > Using Sql server 2005. > I would like to know if there is a utilty or if you have any ideas on > finding out > which records have been accessed in a very large table? > > basically I have a table that is accessed by many users and I want to > know > which records have been accessed in this table by the users. I could > use this info > to me in testing: I would only test the unaccessed records! > > Is there a utility or "internal" procedure that can with this? > > > Thanks in advance; |
|
|
|
20/05/2008, 15h24
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: How to verify all records touched/accessed in a very large table
Aaron Bertrand [SQL Server MVP] wrote:
> Answered in another group. Please don't multi-post. > > > > "Sbell" <placidite1@yahoo.com> wrote in message > news:3ebcefc4-f917-487e-9bf4-03018462f05d@f63g2000hsf.googlegroups.com... >> Hi all >> >> Using Sql server 2005. >> I would like to know if there is a utilty or if you have any ideas on >> finding out >> which records have been accessed in a very large table? >> >> basically I have a table that is accessed by many users and I want to >> know >> which records have been accessed in this table by the users. I could >> use this info >> to me in testing: I would only test the unaccessed records! >> >> Is there a utility or "internal" procedure that can with this? >> >> >> Thanks in advance; > Hi there, which group was it answered in ? I'd like to read it |
|
|
|
| Outils de la discussion | |
|
|
