|
|
I don't know a way to read the log file. And the only tool i know which can
possibly help you is Apex SQL Log.
G-U-R-U
|
|
|
|
|
devboycpp wrote: Can I restore my lost records without a backup file ?
No, however depending on how the data was deleted, it still may exist on the disk. You might want to see if there are any tools available to recover sql server data on a hard drive.
devboycpp wrote: Is there a way to find out how this happened ?
There may be. I would start with any logs you have at your disposal. Check the Web Server logs, the SQL logs, Audit logs, the SQL Server Service logs.
If you can not find anything there, look at how you insert, update and delete data from the affected tables for bugs.
Check the web code for possible sql injection.
|
|
|
|
|
All depends on the recovery model.
if you have a "full" recovery model then use a third party product to do if for you
how do i recover data from sql server s log files[^]
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
I am not sure if this is the correct category to post my question.
I am now currently using netbeans, java db and glassfish.
i want to display values from the database in the table.
so i drag the table from the database to the table.
However i get the following:
http://img80.imageshack.us/img80/2290/whylikethis.png
why is this so? it just kept refreshing and i am unble to edit the values that i wanna display on the table.
|
|
|
|
|
pancakeleh wrote:
http://img80.imageshack.us/img80/2290/whylikethis.png
The link which you mention here is not working whatever,
I am suggesting you to Move Java Forum and mention code if it not working or giving error.
|
|
|
|
|
It's a java question. You should have posted in java forum. Also you should have post the code here which you have tried so that we can at least guess the thing. And then what database? Also your image link is broken(it's redirecting to this forum) but I can see the image by pasting the link text http://img80.imageshack.us/img80/2290/whylikethis.png, so here after correct that. cheers.
|
|
|
|
|
Hey guys,
I've made this simple, as you can see in the picture I have some categories and subcategories, in this case
Electronics > Television (check out this to understand better http://i56.tinypic.com/rmvifs.jpg)
Television is a type of product which has some fields like (size, color, brand) that has to be saved in the database. there are many different types of products which have their own fields and their number is unknown therefore this cannot be done statically, it has to be done dynamically.
in addition to all this, each field has values, there are three types of values
true/false
multiple choice
single text
the values for each field also needs to be stored in the database so when for instants TV is selected the fields are loaded + their values.
I hope I were clear enough, would appreciate it if you could help out with the best design
K1
|
|
|
|
|
Could you please look into link you provided ? It's not redirecting properly.
|
|
|
|
|
If you cut and paste the link, it seems to work. Anyway this might help.[^]
Unfortunately, it looks remarkably like a lecturer's whiteboard with a homework problem, snapped on a mobile 'phone, but I could be wrong. 
|
|
|
|
|
it actually is my whiteboard and that's the problem I wanna find a solution for ! 
so have you got any idea guys ?
|
|
|
|
|
Well, I wouldn't tackle the problem that way at all. Assuming you are using a 'grown up' database, and you don't have millions of records under 'Electronics', then I would just have two tables.
The first would hold the records of all the 'Electronics' items, with a 'Category' column containing a unique code for TV, DVD player and so on. Other than the essential columns, like Name etc, I would have Descr1, Descr2, Value1, Value2, etcetera, enough to accommodate the most complex item. Some columns would have normal names, for instance, 'Price', or 'Cost'.
The second table would reference the first through the Category Code, have the same columns and column headers as the first table, but the rows would each contain descriptive values for the equivalent column headers in the first table.
|
|
|
|
|
I am still out of luck, I am not getting to see image.
Thanks for all your work.
|
|
|
|
|
So sometimes I use bcp from my c# and call it in a separate process while passing it command line arguments. I have been doing this for months, but today it started throwing an ambiguous error. I have changed nothing, so the sudden failure is proving difficult to resolve. I am still able to create the bcp format file, but when I try to insert a file I get:
An error occurred while processing the command line.
bcp PriceRecords.dbo.SVR5 in "C:\Code\b
in\debug\SVR5\1220201093611.csv" -t',' -f "C:\Code\bin\Debug\SVR5.xml" -U xxxxxx -P xxxxxxn -S localhost\SqlExpress
where xxxxxx = user and password
Using MSSQL 2008, not seeing any error in the SQL logs.
|
|
|
|
|
It appears wrapping the table name in brackets fixed this issue. I have no idea why this error seemed to have spontaneously started.
|
|
|
|
|
Often wrapping the table in brackets fixes problems with naming conflicts, especially if the name conflicts with a reserved word. Of course I have no idea if that applies in your case.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Hey guys, I was wondering if you can guide me to any source to find out more about ebay's database structure ?
Regards,
K1
|
|
|
|
|
Have you seen this? eBay's Database Structure[^]
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
yes I have but isn't exactly what I need ! thanx
|
|
|
|
|
Dear All, I have bellow table which I want to transpose, the pivot in SQL 2k5 works but I want it like in a dynamic way.
as lets say i have table
EmpID Name
1 A
2 B
I want to transpose by EmpID, that works fine but what if one more record is added to the table as
EmpID Name
1 A
2 B
3 C
then my transpose only picks up 1 and 2, how can i dynamically transpose that?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
I do that in a DataTable once I've read the data, you could also do it while reading the data. I've never had a need for doing that in the database.
|
|
|
|
|
thanks for your reply, doing in DataTable is the simplest solution.
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
I hope you are asking about dynamic column generation with PIVOT.
You can first generate all the column dynamically using SQL Query and then you can give as a column input to PIVOT that will work beyond the static column bounary.
You could find THIS[^] to be useful.
Regards,
Hiren.
modified on Monday, December 27, 2010 2:51 AM
|
|
|
|
|
appreciated, that is what i need!
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
