Any help for that error?

YES. As I said:

YOU need to replace the table and column names with the REAL table and column names.

-SQLBill

No open source products that I know of....I have heard that Lumigent's LogExplorer does a good job, but I understand that it can only read logs created AFTER it has...

Do you have any applications on that server? Could they have created 'hidden' databases? For example, Veritas' Backup Exec creates a SQL Server database and sometimes you will see their...

I've never heard of DBShadow, so I can't help with that. I would suggest you calling the vendor and seeing what they say. Question: why aren't you just using...

Of course you got that error. Your example shows the table names are TABLE A and TABLE B. PW provided you an EXAMPLE using those table names...YOU need to replace...

For finding out what the version equates to, this is the best site that I have found:

http://www.sqlsecurity.com/DesktopDefault.aspx

On the menu bar, select FAQs/DOCs, then select SQL Server Version Database.

-SQLBill

Nope, never seen that. How are you doing your backups? What does your backup command look like?

-SQLBill

That's not what John asked for....it will help if you provide us the schema (column names) for each table and some sample data for each table and a result that...

How are the applications set up to connect to the database? Some DBAs/programmers/vendors set their applications to use SA account or the local admin account.

-SQLBill

My guess is that they would be responsible for ensuring everything was standard. Double check code, security settings, etc. and maybe re-write code to meet the standards.

Didn't your friend...

How are your logs being backed up? Do you append them to the current file or do you create a new backup file for each log backup? If you...

Terry,

It's not a bogus question. Here's the question again...

Which one of the following may not be supported in a future release of sql server after sql server 2000?

That says...

Nope, just do it right now.

-SQLBill

Your problem might be that your TEMPDB can't grow fast enough for a transaction.

I never set mine for percentage, I always do MBs.

Try setting yours for 50 MB for...

From Microsoft's website:

timestamp (Transact-SQL)

Is a data type that exposes automatically generated, unique binary numbers within a database. timestamp is generally used as a mechanism for version-stamping table...