Nope. There are several interconnected tables and the 3rd-party app deletes from several of the tables and 'cleans' up data in other tables based on what it deletes from the...

You were probably logged in as yourself and not SA. That means the procedure became YOURS. This is a prime example of why system stored procedures shouldn't be changed. ...

Another downside of Lumgent's Log Explorer is that it has to be loaded and running prior to when you need to use it. It's not able to read log files...

Are you sure it's the same backup file being restored? It really sounds like you restored a log on one server, but a differential on another.

Could a backup have been...

Have you tried RESTORE DATABASE command, vice RESTORE LOG just to see if it works?

-SQLBill

Nope. To restore with a transaction log, you have to have a FULL backup. The transaction log backup only applies to the full backup done prior to the...

Did the log backup get overwritten by a differential backup? BTW-Differential Backup is Microsoft SQL Server's term for an incremental backup. What you are doing is restoring a Transactional...

Wow David, 12 GB and you have to kick off the users to do a backup? My major database is currently 248 GB (yes that is 2 hundred and...

In the BOL, use the Index tab, enter Local Temporary Tables. The right pane will display CREATE TABLE. Scroll down to TEMPORARY TABLES section. A local temporary table is...

Start with the BOL...it's free and it's the Official SQL Server Help file...

BOL=Books OnLine=Microsoft SQL Server's HELP

Installed as part of the Client Tools

Found at Start>Programs>Microsoft SQL Server>Books OnLine

or online at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

-SQLBill

You use Query Analyzer and just run the command as it's shown in the BOL.

For example:

DBCC SHOWCONTIG ('tablename')

You don't need to add EXEC before the command, like you have to...

It could be someone mapping a drive on their computer to your SQL Server. When one of my remote users tried to connect to my SQL Server, I saw...

If you delete BUILTIN/Administatrator login and the app failed, then that is an indication that the application uses Windows Authentication and is using a login that has local (or network)...

You can't connect from the client machine which is Windows XP, correct? If so, did you recently apply XP service pack 2? That service pack turns on the Microsoft...

What datatype is FirstName column? Is it CHAR?

-SQLBill