thank you all for your kind help

deepak do you have a version of that code that will work for two seperate instances on the same machine ?

read BOL etc and...

thanks crispen

when I use the configure database mirroring security wizard it doesnt present domain name and doesnt let me edit it in (maybe as theyre just instances on the same box...

Apologies I really should learn to type on occasion , I of course meant

70-431 to be a ts

and then add on

70-443

70-444

for the full blown pro

~si

thank you...

so if I understand correctly I can sit

70-443 (is there a difference between the "pro" & "ts" )

70-444

70-431

In any order I choose ,,, also I could just take...

Yelena many thanks that is just what I need !!

I will post it as an insert statement etc when Ive tracked down all the values etc

regards Si

I'm not after any stats , all I want to know is which tables have data inserted into them during a certain process i.e the end result being a list...

Many thanks, Ive not got to work out the best way to exclude them when Im using the following syntax to determine which indexes need defraging

CREATE...

using a query to highlight which indexes are in need of a quick defrag etc which is based around

DBCC SHOWCONTIG (Categories) WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS

go

the results include indexname...

now I feel stupid 🙂

thank you very much for the advice/help

-si

Hi

thanks for the reply. I try stopbeforemark and it indeed returns the row. However, if I use this sequence :

/*backup and overwrite */

BACKUP DATABASE...