0
votes
1answer
46 views

missing data after attach mdb

Recently, one of my customers had a server crash. Unfortunately, the 3th party who was responsible for the backup had 'forgotten' to schedule a backup of the DB (I know, I should have noticed that). ...
1
vote
2answers
321 views

How to leave only e.g. TOP 100 records in ALL TABLES in database (SQL SERVER 2005) [closed]

I'm having a huge database over 100GBs and I need to burn an application (for demonstration purposes) on CD or DVD which uses this huge database... is there a way how to leave for example only first ...
1
vote
1answer
74 views

How can i fix the ?????? problem in SQL Server 2000

I got both of mdf and ldf files from user. He told me that it's infected. but my Symantec said it's clean. i can attach it to SQL Server 2000. but all Thai words in all rows and tables became ...
0
votes
1answer
25 views

How do I Create an AutoCounter Column in a Table in SQL 2008 R2?

There is nothing in the "Data Type" drop-down that indicates an auto-counter. I selected int and I am assuming there is a setting somewhere else to turn it into an auto-counter. The idea is to have a ...