i want the list of tables when databasemirroring configured.

thanks........

exact error is below....

This table cannot be published because it does not have a primary key column. Primary key columns are required for all tables in transactional publications.

thanks.........

a table without primarykey.

i am trying to transactional replicate then it popup error as it is not possible to replicate without primarykey.

can u pls let me know the reason.

thanks Steve and Elloote

it means,

i opend the sqlserver with windows authentication mode and sqlserver authentication mode.

is global temp table is available in these two connections?

thanks...........

thanks.......

thanks.

we have so many production servers on sql2000.so i need to get the knowledge on sql2000.

so thats why i am asking microsoft exam books of sql2000.

ok thanks.

i don't want to write the exams,i want to study the microsoft exam papers of sql2000.

thanks.

i want to become a master in sqlserver2000,so pls suggest exam papers of mcdba2000.

then i will read that books for getting knowledge in sql2000.

ok, thanks........

thanks to all........

thanks

thanks..........