One of our biggest database is on Suspect Mode. We searched the net for steps to recover and it is now on Emergency Mode. During transfer of data from old database to new database, we encounter errors.
We checked the MDF file and it is intact. My question is how do we recover the database from the MDF?
Help please.
Russel0725
Last Activity: Feb 19 '09, 09:59 AM
Joined: Feb 5 '09
Location:
-
How to recover database from MDF?
-
Thanks a lot it worked when i converted transactiontype to NVARCHAR. I tried also to do the same for the txnnumber field but COUNT applied to that converted field gives me an error, or does not work. What is the correct syntax to perform COUNT on a converted field? -
I'm sorry I can't do that. It is an established database already and I'm not allowed to change anything, only to query. How else can I accomplish a result set like this?
BussinessDate Storename Transaction Type Dayoftheweek Hour Tcount GrossLeave a comment:
-
Need Help - Multiple Column in Group By clause with Data Type Error
This is the table structure I'm trying to query:
Storename varchar 50
Bussinessdate datetime 8
txnnumber text 16
subtotal float 8
discounts float 8
paidamount float 8
transactiontype text 16
time datetime 8
This is my query which results...
No activity results to display
Leave a comment: