Or we're both delusional, which is at least possible... 😀 😉

Considering I'm still up on cloud 9, it's not so unlikely for me. :w00t: :w00t: :hehe:

Yes. A full backup contains all schema objects and data.

How does a query fail because of a missing trigger?

Did you check to see if the index you created was useful for the query?

You need to find the application that is vulnerable to injection (you can use profiler to see the commands coming to the database)

There isn't a quick silver bullet on this....

You need to restore the backup you took before restoring the previous night's backup. Restore that somewhere and interegate the log.

The database that you restored to the previous night's backup...

Are all the files where SQL expects them to be? Query sys.master_files and see where SQL thinks the data files should be. Make sure they are there.

Yes, your're right it should.

I cvan't test now, but I have seen it in the past on a restored database.

I don't know of any functions within SQL to read a backued up transaction log. all the ones (DBCC Log, fn_dblog) read the active portion of the log, not a...

Could you post a particuarly nasty example?

Depends on the indexes that you have.

2. How to know that how...

Difference in slang in different places.

Down where I live we use the term "write the exam"...

terry.jago (7/1/2008)

---

The process for clearing this is as follows

1) dbcc opentran(dbname) - this will show the oldest open transaction

2) Kill this process command kill suid

3) backup...

Please...

Peter Curd (7/1/2008)

---

I have set Perfmon counters to run for 3 days but 3 days worth of profiler is going to be a lot of data! Would it ruin...

http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/