Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by dmcub
-
HEAP indexing
Hi. In a heap table does index get placed on every column or only some? Can you force uniqueness by using it? For example, in a product table ID int PK product_code varchar(5) product_abbrv varchar(10) I need to be able to search quickly by both ID and product_code, and enforce unique... -
Cannot properly restore or delete a database
Thanks, I'll do it again w/o the norecovery option. What can I do to delete the DB though, since there are no logs to restore? Any help will be appreciated.- dmcub
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Cannot properly restore or delete a database
Yesterday, I tried to restore a DB, and I am not able to see any objects under it. Enterprize manager shows this database grayed out and says "loading)". It cannot be loading for 2 days, especially since the job history says that the job succeeded. I tried to restore the DB under a...- dmcub
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
