I am looking for default server settings like connections, no.of errorlogs and job history log...

Will we have any proc/function to find out those....

Thanks, Karthik

How much secs is configured in the query-timeout property in conection on server properties.

It is SQL Server 2000 EE (Active/Passive Cluster Setup)

Thanks

The statement like......

select top 100 * from xyz

where 1=1

AND (sid IN ( 111 ) or oid IN ( 089 ) )

and timein >= N'02/02/2009 09:00:38'...

Hi,

You will get the timestamp for last modified the data files in the physical location of mdf file.

Thanks.

Pls verify your service pack for SQL Server 2005 on both servers.

Database mirroring right choice for your bussiness

You should configure the database mirroring with high-safety mode with automatic failover.

You can tune your db thru

1. SQL Server profiler

...

Please move the database to the another server/configure memory for sqlserver manually

Thanks Jimmy Jen,

One of my hard disk failed in the array controller and raised ticket to the vendor to replace it immediately. gimme ur email id.

ALTER TABLE <yourtablename> DROP CONSTRAINT <constraint_names>

Hi Prasad,

You try this method,

BACKUP LOG <database_name> WITH TRUNCATE_ONLY

Regards

 - Karthik

Thanks for your reply,

I have fixed the issue,

Regards

pls apply this command

select * from test order by dirname

pls check san if any configuration change?