thank you

sp_dropserver and sp_addserver worked for me..

the only mistake was ... i did not restart the server after sp_addserver...

anyways thanks to all of...

what are the jobs you mentioned about..???...

I am unable to setup the replication.. (unable to configure distributor,publication..).. because of the above..

I think it is because of not having a CLustered Index on the tables... which might cause longer scan on tables.

It is recommended to have atleast one clustered index...

Hi All

I too have a problem with date values comparision... the below is the code

 CONVERT(VARCHAR(30),TRANS_DATE,101)>(@REPORTDATE)

where @REPORTDATE is declared as DATETIME

this condition is working in some of the data bases...

Thank you steve

Is there anyway to check the load caused by the triggers???..

and how SQL server decides which trigger to execute first if we have 2 same INSERT(UPDATE/DELETE) triggers??..

As you are using Transactional replication..

all the transactions will be logged and cannot be truncated untill all the transactions are moved to the distributor database.

Seems changing the recovery model doesn't work...

Colin,

 Thank you for your response..

I have read some where that Avg Disk Queue Length should be less than 3 always.. and which is some way related to the number of...

yeah .. "Hide Server" is not checked..

Hi James

 thanx for you quick reply. MS SQL Server 2000 is installed on the box.. and MSSQLServer & SQLSERVERAGENT Services are running properly.

I did not find any service named SQL...

Check out these to script specific objects

http://www.databasejournal.com/features/mssql/article.php/2205291

http://www.nigelrivett.net/DMO/DMOScriptAllDatabases.html

here is my situation wid the SQL profiler

when I save the trace in to a database table, the query text is been trimed to 256 characters.. is there any way...

Have you tried Redgate SQL Data Compare tool

is this you have record level comparision and many more features.

Here is an addition..

When SQL Server performs some operation, it loads as many related pages as it requires into the memory. For example,...

have u checked the growth settings..

whether the Maximum filegrowth is set to

    1.Restrticted grow

    2.Unlimited growth

I think it doesn't work out as

Used sp_attach_single_file_db only on databases that were previously detached from the server using an explicit sp_detach_db operation.