See this thread...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=207697

I think replacing the @source with ip address should work.

HTH

What I'd like to do is as follows..

I want to be able to generate excel reports where I would get information about formating etc from some metadata tables I have...

We're talking apples and oranges here..

DTS allows you to make custom tasks(sql or activex) that you can schedule as a Job.

DTS-- Data Transformation Services(theres a lot more than data...

This would work too..

select top 1 *

from

(select top 2 [value_to_compare],[other_fields]

from foo

order by [value_to_compare] desc

)q

order by [value_to_compare] asc

if you wanted the third item you would change 2 to 3...

I've done something similar by using a second table to determine whether the trigger should be active.. Your procedure would then update the table.

The trigger would only fire after checking...

This isn't a tutorial...but a geat book for anyone starting to program SQL server.

Murach’s SQL for SQL Server

http://www.murach.com/books/sqls/index.htm

I coded everything entirely using T-sql. There was some thought about using extended stored procedures with c native code, but the performance gains were minimal( dynamic t-sql functions to...

Why do use null there ? What does that mean(that the book only has 1 author ?)

I would default that value to 0.

Then you can use what is below.

Select...