Yeah, it's some Mode-80 syntax restriction, but I do not understand why. Maybe someone more conversant in SQL 2000 syntax can comment.

You could also try what Jeffery is suggesting,...

Hmm, must be an old open transaction then.

Execute this command:

select *

from master..sysprocesses

where dbid = db_id(N'your DB')

Look at the "Last Batch" time for any processes with open transactions. ...

Jeff Moden (12/26/2008)

---

Heh... everyone gets all bent out of shape when someone uses a cursor in a place where it shouldn't be, but no one says boo when someone uses...

I believe that this means that the Log Reader is not running or is not running against your database.

Cool. Glad I could help. 🙂

OMG, I cannot believe some of the stuff that you know Gail! How on earth...

It's "Application.CalculateFull".

jason brimhall (12/30/2008)

---

I have to agree with Jason Adams on this topic. This article seems to miss one of the most important aspects of DBA work - proper indexing....

The other thing that I will mention, is how I do it: Views.

Yeah, I know we already went over that, but I do it a little bit differently. ...

Well, I am not sure what else you can do. I do not think that EndPoints can be used for this, but I am not sure.

You may be able...

From the 2008 BOL:

The Scalable Shared Database feature enables you to scale out a read-only database built exclusively for reporting (a reporting database). The reporting database must reside on a...

We will need to see the Sproc's code, the table definitions and the trigger code.

I think a better question is "Whats a shared scalable database?" This is the first time that I have ever heard of it. Amazing.

Nah. Just replace any appearance of "st.{col_name}" with:

(Select {col_name} From sys.dm_exec_sql_text(qs.sql_handle))

It's not as efficient as your orginal query, but it should still work just fine.

Change it in the Management Studio Table Designer. It will take care of everything.