Yes, it can be used to read them, but if...

Jeff Moden (5/16/2010)

---

GilaMonster (5/16/2010)

---

mike 57299 (5/16/2010)

---

I have tested this issue by issuing an INSERT command in the command window. It hangs until I use the task manager to kill...

btw, this is one of the reasons why, when doing a SQL 2000-2005 upgrade (which I assume is what you're doing), you should be doing end-to-end testing of the application,...

mike 57299 (5/16/2010)

---

* Trigger on queue causes small exe to fire that will populate an order with all the extra stuff needed into the normal order_hdr and order_dtl files.

* Since...

Yes.

mike 57299 (5/16/2010)

---

I have tested this issue by issuing an INSERT command in the command window. It hangs until I use the task manager to kill the exe process....

A trigger executed within the transaction that fired it. The transaction is not committed, and hence the locks are not released, until the trigger completes. Hence, if another connection (like...

This is called deferred name resolution. If, while creating/altering a stored procedure, SQL encounters a table/view/procedure that does not exist, it skips over that name, assuming that the object will...

I suggest you make it clear to them that you are not familiar with database design and that your skills are around the writing of queries.

If they ask you to...

From Books Online: (emphasis mine)

Backing up the tail of the log

Like any log backup, a tail-log backup is taken by using the BACKUP LOG statement. We recommend that you take...

May I suggest some time with your favourite search engine. See what people have written about, see what people are asking about. If nothing else, it should spark some ideas.

As...

Yeah, but that doesn't allow for a where clause.

A step-by-step document? There are...

Sunil Padarath (5/15/2010)

---

Hi Gail

in my test instance i have managed to changed the db status to mergency. this i was able to do so by putting the instance into single...

Jeff Moden (5/14/2010)

---

Cory E. (5/14/2010)

---

Jeff Moden (5/14/2010)

3. No... I disagree... old threads should NEVER be locked. Every once in a while, I'll come across one that I absolutely...