Thank very much sir,now i dont have any error when i run upgrade advisor but when i run sql server setup file for installation/upgrade i get the following error:

upgrade...

Thank you sir.

LOLLLLLLLLLL

I am so sorry... not hours but years :),I did mistake while typing.

I am not clear about monitoring server yet but

Thank you of both of you CrazyMan and Adi for your help.

Thanks Irfan

select * from dbo.sysobjects ( not sys.tables)

and you can use TYPE column in where clause to get specific tables like user table,system tables,views etc.

Irfan

Thank you very much,I will read this and will come back to you soon :).

I have not setup yet but i am saying if

there are two server A and B,

A server is publisher and B server is subscriber and users are connected to B...

And how is http://www.newhorizons.com please? And any one else which you think better for training.

Thanks for your good advise and time.

Yes i do and i know a lot of things but i want to go through a to z as i am having random knowledge mostly dba side not...

Thank you Nair,It is working now in both Enterprise Manager and Query Analyer through script,i think main box was slow due to a reason.

Nair, Do you know any article or...

Thank Atif,I am using SQL2000 and somehow it is working fine now with script and through EM as well.

Atif if you dont mind do you know any article or place...

Which one is appropriate section please?

Without mentioning any size mean at minimum level default size of database.

Regarding the locking/blocking,There is one lock on dbid=10 and 10 is the id of that database which i just...

Thanks Sir.