I have a few rules:

1-Printscreens must be taken with the window size as small as possible. A screen shot of a 640x800 window is best to view on...

Hi bteraberry,

Unfortunately, this is not a parser error. If you put that sql statement in a SQL job, even if encapsulated in an exec statement, it throw an error and...

Hi,

When trying to answer the QOD, the answer "4 100GB drives as a RAID 5 array and 2 100GB drives in a RAID 1 array at $250 per drive."...

Hi Gang,

I think that the software issued the wrong drop table command...

I've found out the resulting transactions on the system tables in Apex SQL Log explorer:

DELETE FROM [dbo].[syscolumns] WHERE [id]...

Hi,

Yes, there is also other tables that was lost in the same transaction: I didn't mentionned them because they were all used in the transasction and were all lost in...

"I've checked in the sysobjects table if I could find out at least the QUOT table name, and it was not there"

Patrick

Hi,

No rows are returned.

Patrick

Hi,

I've checked in the sysobjects table if I could find out at least the QUOT table name, and it was not there. Some other SQL guys here could confirm that the...

Doing this query will ignore the indexes:

select idtransaction, failed, CreatedDateTime from transactions WITH (INDEX(0)) where failed = 1

and it returns the proper amount of rows.

So the table seems ok...

It returns 9 rows, no duplicates (10 actualy now since there is one more "failed" record in the table, but you know what I mean)

I will try to do...