Thanks, Jeff, much appreciated.

And frankly, this makes no sense at all, who said any thing about Compact Edition and what relevance...

Um, nothing in the title or the article implies that it takes 60-Seconds to become a DBA, and the the content of the article obviously argues the opposite. The...

JC-3113 (12/3/2009)

---

Hi RBarry Young

sorry to bug you again, but i came across another issue when running this on another server

seems there's a 256 limit somewhere

Msg 106, Level 15, State 1,...

Can you supply us with a script or the data the can duplicate the problem? Just attach it to your reply as a TXT or ZIP file if it...

Unquoted names (i.e., no "[..]") cannot have certain characters in them like spaces or "-". So I just added the brackets around the database names ("%D%" --> "[%D%]").

Thing is,...

MTY-1082557 (12/3/2009)

---

this is the xml ( I just sending you part of that because its huge)

<xml> <version alias="m4l_HSI_006$1" versionidentity="" packid="" versionid="" rowid="1"> <attribute key="t_weight" keyDesc="Weight" value="0" valDesc="" /><attribute key="t_rid" keyDesc=""...

Show us...

Hmmm, weird. It's obvious what's wrong, but I though that I had fixed it long ago. Well, this should fix it anyway:

ALTER Proc spLogin_OwnedObjects ( @login as SYSNAME...

Why don't you just write this all the time?

if (@flag = 1) begin

raiserror('hello', 16, 1)

return

end

Give us some sample data that demonstrates the problem.

If you use DBMail instead of SQLMail, then sending mail from a trigger should not be an issue as DBMail is built on Service Broker and is therefor asynchronous.

Scanninng tables...

Faye Fouladi (12/3/2009)

---

I found the solution.

the secret was to use the Group By All clause, then one would see the zeros for the Count if there are no records that...

Database users aren't under Server Logins,...

What does "but still remains active to the column i was trying to edit." mean?

Also, could you edit your post and use the [ code ] tags please? thnx