IMHO SQLCLR only outperforms T-SQL in two general cases:

1) In cases where the same activation path must be followed by both (Triggers, Service Broker activation procs) then CLR appears...

If you are using SSMS, then there are query options that limit the size of the text that it will display. The options are under Query Reusts..Text, and ..Grid.

ALZDBA (12/19/2008)

---

Scenarion 1 : add begin tran ... commit tran

Just encapsulating the trigger with its own Begin tran ... commit tran, off course didn't do the trick.

Because: that tran is...

Well if the colon (":") doesn't work, then I would try it with a comma (",") instead. 🙂

This article by Frédéric BROUARD gives the best explanation that I know of for the Nested Sets model: http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/recursivequeriesinsql1999andsqlserver2005/1846/

The Path model is the original unadorned natural model of a Tree or a tree-based hierarchy. To use the analogy of our C: drive's filesystem The path mode...

Try it like this in your connection string "111.222.333.444:1433"

GilaMonster (12/17/2008)

---

You gain points by posting (1 per post) or by answering the Question Of the Day correctly. Usually between 1 and 3 points

Forum Newbie - 0

Grasshopper - 10

SSC Rookie...

Well they are online, in...

This is a duplicate post. Please do not cross-post.

Please direct all replies to this thread: http://www.sqlservercentral.com/Forums/Topic621734-148-1.aspx

"formula" is not a SQL Server term.

Do you possibly mean a user-defined Function?

Heh. Well, glad I could help, though it seems like you were able to do that without me. 🙂

I think that you've got it later on...

Actually, Jeff, I believe that this...

maddogs (12/17/2008)

---

It's 5 degrees F outside these days here in central Washington state so there's not much outdoor arrow & inanimate object flinging going on, but I've got a batch...