Probably you can use database Engine tunning advisor and/or use Show Plan to find our more.

Somebody has recomemded lower fillfactor value to grow the data pages faster.

I am fully aggried that this settings should follow for OLTP but would like to know whether it...

Your options are very correct but needs to find out the best options as per your environment and license availability.

We are having 20-25 GB of Data in SQL 2000 and...

Creat Stored procedure like User_sp_detach_db and use sp_detach_db as dynamic SQL in this stored procdure and control the permission of user_sp_detach_db 😛

Create two Stored procedures; one to detach the db and other to attach db and grant the exec permission to perticular user.

Also restrict the Database Role to perticular user...

I was waiting for the solution but couldn't get single thred 🙁

Is this SQL Server bug or it's working for others?

I have resolved the issue with alternet solution uninstall Database...

Visit following link for more detail:

http://support.microsoft.com/kb/832524

If db was detached; hope following link might help you:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_Edmo/html/b7b3bafd-e510-4fbd-a8f9-64d921eb7140.htm

Good Luck!!

Visit following link:

http://www.exforsys.com/tutorials/sql-server-2005/getting-started-with-sql-server-2005.html

Troubleshoot with the following MS link:

http://support.microsoft.com/kb/827422

Hope this will help

We have never seen or come across such incidents.

Best thing you can do is capture the necessary info by capturing trace through profiler. In future if the same thing...

You can't recover deleted rows unless and untill you are using checkpoint. To rollback checkpoint is must.

Resoultion:

1. You can restore the backup with stop at otion and extract the data....

I have gone through all reply of this post and would like to suggest following two on top of all these:

1. You must Run DBCC CHECKCATALOG in sql server 2000...

You can use DML Trigger or else you can use Profiler to get information you require.

Hello Siva,

Find your reply here:

1. When SQL Server Agent service account locked you can't restart the Agent but if agent is running no impact.

2. If agent is stoped no SQL...