ur answer was v.clear.

so i dont need to install SQLbrowser right.

but can u explain what dose it mean cluster aware and not cluster aware

am i missing some thing here, how the installation will install it on both nodes and the service is not a cluster aware??

The standard SQL Server installation will install the...

thanks, all this is very help full, but how can i install SQLBrowser??

i could find nothing on the net.

yes i have already check this, and i dont have any application that uses sa account.

hay sorry about the '???????' but when i past the script i dont know how it has been added, and u can see this case in some script published in...

it might be not harmfull, any way the log file have a recored for it every three minutes.

SQL Enterprise 2005.

with no service backs.

althoug u have said that i cant, but it is a good sanwer i will use.

thanks

i really wish if i could do so, but i have spent soo much time on it, i just solved 10% from it..

u know, i dont post something here unless...

i have a system our company use, and i need to do some modifications in the backround.

the system create a temptable named dynamiclly.

so i need to get the temptable created...

this wont help cos i need to get the user name or the session id for the user how created this temp table.

????

if u know the temptableName '{temp table name}'

then i dont need to search for the temptableName '{temp table name}'

thanks gues for the info and for ur help..its going to happen but things must go slowly.one step at a time.

sp_readerrorlog wont read the agnet error log files.

u take a backup for the master after mager change:

like creating linked server, add login, server level trigger and so on.

there is no need to backup it every day, any...