First of all you should be bit more civil.

all those above mentioned methods will show the  table(s) that depend on other tables if proper...

First of all you should be bit more civil.

all those above mentioned methods will show the  table(s) that depend on other tables if proper Fkey relationships are set.

Thats not a good idea at all.

hi

do u have proper indexes. if not create them

if u have proper indexes then make sure they are not fragmemented. 20,000 records is not much after all.

Michelle

I dont think we can restore the backup of SQL 2005 db to SQL 2000.

Pls keep us posted if its possible.

Newbie,

i agree with Shaun there, that wud be the best way to do things.

to know the time taken by your queries use the tool "SQL profiler". U shud get enough...

yes, Null values should be avoided as they need to be specially handled in data operations. Maybe u cud set some default values for the columns. This would keep the...

paul

i feel its better to have one event table rather than 3 . since there are 3 types of events u can have a "event type" field in the table....

harold

the syntax for adding a function to a check constraint

ALTER TABLE CheckTbl

ADD CONSTRAINT chkRowCount CHECK (dbo.CheckFnctn() >= 1 );

i got it from BOL... go there for more info

Chirag

ur problem could be because of ur lease line connection being slow

Or   some bad performing query locking up resources resulting in time out.

time out is in seconds and 0 stands...

Usha

check whthr any process has locked up your table.

In EM - Management\CurrentACtivety\Locks/Object.

jseper

check this system table - sysforeignkeys

harold

I know a slightly different way to do this.

i dont know whthr we could straightway put a expression that u want in a check constraint, but u cud create a...

hi

i was able to export data from sql to a access file residing on another machine in the local network using import export.

hope this helps ........ and iam sorry...

hi

i may have not understood ur issue correctly. do u mean u want to export from a access2000 to another access2000 or from sql server to access2000. if its...