Viewing 15 posts - 1,066 through 1,080 (of 1,179 total)
Probably you can use database Engine tunning advisor and/or use Show Plan to find our more.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 3, 2008 at 3:21 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 3, 2008 at 1:31 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 1, 2008 at 5:47 am
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 😛
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 1, 2008 at 5:35 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 1, 2008 at 5:18 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 28, 2008 at 12:10 am
Visit following link for more detail:
http://support.microsoft.com/kb/832524
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 13, 2008 at 3:08 am
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!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 22, 2008 at 7:19 am
Visit following link:
http://www.exforsys.com/tutorials/sql-server-2005/getting-started-with-sql-server-2005.html
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 18, 2008 at 4:03 am
Troubleshoot with the following MS link:
http://support.microsoft.com/kb/827422
Hope this will help
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 18, 2008 at 3:55 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 18, 2008 at 3:45 am
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....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 18, 2008 at 3:39 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 18, 2008 at 3:33 am
You can use DML Trigger or else you can use Profiler to get information you require.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 9, 2008 at 1:19 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2008 at 1:23 am
Viewing 15 posts - 1,066 through 1,080 (of 1,179 total)