mmm.. which instances

dlgross

i had a case similar to yours once. and i used dynamic sql

using triggers

chane your datatype for the @sql to nvarchar

sp_executesql works with unicode characters

you really must stay away from this dynamic sql if possible

osql -L

you can pipe the output to a text file

osql -L > c:\sqlservers.txt

you can also use SMO objects with .net and do some fancy stuff there

you also need to enclose your values in another pair of quotes

''Building''

you are using dynamic sql hence you need to enclose your zero with another set of quotes since you want to concatenate and not add it to the left most...

the semi colon is a way to separate different sql statements, but it does not make a difference in sql server. maybe they will enforce it in years to come.

DECLARE

@Q1 INT, @Q2 INT

--get the lower quartile

SELECT @Q1 = duration