You may be able to create a COM wrapper for the .Net dll then use the SQL Server's OLE Automation apis (e.g.  stored procedure sp_OACreate to create an instance of the object)....

I believe the permission allows granted users to refer to objects which have foreign-key constraints (e.g. in a stored procedure or user defined function) vs. the ability to create relationships...

TOAD has now put out a comprehable product for SQL Server.... You can find it for download at http://www.toadsoft.com/toadss.html . Like the original TOAD - Don't know how long...

I also believe that the an assignment select entails the creation of a resultset vs. using the set statement.

If you're running the t-sql interactively in Query Manager you can also : view results in grid, then select the grid in the results pane, right-click in top corner of...

My understanding of the availability of the Reporting Services add-on for SQL Server 2000 is end of year 2003.

Thanks for the links to the articles and taking the time to reply. I'll pass the info onto our network admins and post back our next steps. You mention your...