Finaly we are getting to the essence of being :w00t::w00t:

beer and food 🙂

I prefere a very good Geuze Lambic (the bottle with natural cork please) :smooooth:

I'm not that picky...

The strange thing is that I get a @@trancount = 3 at execution time ...

So that would get me to writing another

while @@trancount > 0

Begin

...

same player shoot again ... hit ball when lights are on ...

Select *

, Sum_Y - Sum_N as Subtracted

from (

select sum(CASE table1.column2 WHEN 'N' THEN table1.column1

ELSE 0

END ) as...

I'm glad one of our biztalk devs is very cooperative today 😉

Scenarion 1 : add begin tran ... commit tran

Just encapsulating the trigger with its own Begin tran ... commit...

Due to WWII we have 3 official languages 😉

tempdb is the system working area of sqlserver.

Probably it needed to extend one of its files and hasn't been able to do that within the timeout limit.

Check your tempdb files...

Without any select query example , this is the best I can come up with 😉

To get you on track ...

Select a.col1 as mygroupcolumn

, sum(b.colx) as sum_colx

, sum(c.col1a) as sum_col1a

from...

YSLGuru (12/17/2008)

---

...

HUH?

What makes you think I want this to rteurn more then 8000 bytes? The problem is that Replace() is retruning TOO MUCH text by adding a...

I didn't forget this thread !

I'm not at the office today.

I'll get back to this tomorrow.

it is not a bug,

it is a limit one must know about.

If you need more than 8000 bytes, you need an implicit convert to varchar(max).

,replace(cast('abcdefghicde' as varchar(max)) ,'cde' ,'xxx') As...

kwoznica (12/16/2008)

---

All,

I am still fairly new to SQL Server so please pardon the simple questions I may ask on these forums.

As a junior dba I feel it is...

Keep this in mind !!!!

the KB states:

Note If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or from SQL Server 2005 SP2Cumulative Update 11, you must apply...

You can find it in the install bootstrap files:

e.g in the file "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_servername_SQL.log"

search for

MSI (s) (A4:D8) [09:09:29:007]: Command Line: USERNAME=xxx COMPANYNAME=yyy ERRORREPORTING=0 SQMREPORTING=0 INSTANCENAME=MSSQLSERVER INSTALLSQLDATADIR=D:\...

Make it fool proof...... and they'll come up with a better fool 😀

It will take a while before this...

rbarryyoung (12/15/2008)

---

I agree with you Johan, it is important to remember that unlike their corresponding DDL events, DDL triggers do execute synchronously and in the source execution context. Consequently...