You probably told EM to not recover the database after the last t-log backup was restored. In QA execute the following:

restore database [dbname] with recovery; -- dbname is the...

Faye Fouladi (1/26/2010)

---

Suppose:

Declare @mynumber int

Set @mynumber = 10299

How can I return 102.99 from this or if the variable will be given at runtime, how can I process...

I'm thinking you meant to type this:

select * from tablename

Looks to me like you forgot to hold the shift key when you press the 8.

And if you are really serious, look at purchasing the Developers Edition. The street price is about $50.00, and if you look around hard enough, you can find it...

GilaMonster (1/26/2010)

---

Are you sure that you want to do that? What happens if, when going to restore, you find that the latest full DB backup is corrupt? Or find out...

GSquared (1/26/2010)

---

James Goodwin (1/26/2010)

---

You want to search through your code to find out all the places that reference this table to check for possible problems before you make the structural...

FORUM link worked for me with no problems.

Over time without extra pay!

Glad to have been able to help. If you have any questions or problems, SSC is the place to come!

And that is what??

DBA-640728 (1/22/2010)

---

yes there is another trigger in StudentGroup for delete. But i don't have any records in this table.

i disabled the two triggers (delete and instead of delete)...

Not sure, but sounds like some form of Policy Based Management is being used.

EDIT: Or there is a DDL Trigger in place and something is missing.

Depends, was the work that needs to be reworked done to the requirements at the time? Where did the miscommunication occur? Did the client not understand what work...

Also, is there a DELETE trigger on this table: StudentGroup?

DBA-640728 (1/22/2010)

---

yes you are right there are two triggers.

one is Student_InsteadOf_Del_Trg

INSTEAD OF Delete

NOT FOR REPLICATION

As.....

where line 308 is

DELETE Student FROM Students s INNER JOIN Deleted d ON...