Viewing 5 posts - 1 through 5 (of 5 total)
So why dont you try restarting SQL Server and delete it.?
November 15, 2004 at 5:09 am
The Hash index is not present in SQL 2000. It is only in Oracle, where it is effective in querying large tables mainly for analytic or OLAP purposes.
RKM
October 14, 2004 at 4:16 am
The trick is that you have to give the connecting field on primary / unique key. I hope it is the test id. Rest is ok..
October 14, 2004 at 4:09 am
Hi Pancho,
Attaching and dettaching is also a good option. But it has got 2 disadvantages.
1. You will have to reconfigure any replication set in your database.
2. The method is not permanent....
September 28, 2004 at 8:40 am
Hi ,
DB wise:
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
September 27, 2004 at 4:47 am
Viewing 5 posts - 1 through 5 (of 5 total)