Forgot to answer that one... It's a worst practice to call outside process from within a transaction (still in transaction in the trigger).

If you don't want to link the servers it's impossible. You'll at least need a job on the outside server that can connect to the protected server, but you...

TX... gonna have to download that beta someday .

How about a shipdate column???

So there's just a new datatype (varchar(max)) for using in functions/sps?

Glad we didn't show 'em how to use the sledge hammer.

HTH.

Alright... can't help you much there.

You can use EM to script all the objects you want.

If we got 100 bucks everytime we said that .

When you rename an object, its script create name is not modified (except for tables). You have to do it manually.

hmm.

Make the app write the record to a text file on a shared drive on the server that only the 2 server logins an nothing else can access. Then...

How are you gonna use that??

I would keep the original select, then use output parameters for the 2 others... or use the reporting tools to get those values.

k... just making sure that the design wasn't flawed.

Select Min(dtMM.marks) as MinM, Max(dtMM.marks) as MaxM from

(

SELECT college_id,department_id,student_id,SUM(marks) as SUM

FROM student a INNER JOIN college

ON a.college_id=b.college_id

GROUP BY college_id,department_id

) dtMM

Select DISTINCT o.Name, O.XType from dbo.SysObjects O inner join dbo.SysComments C on O.id = C.id where text like '%UCN%'