A possibility... on the destination server:

set identity_insert MyMainTable on
insert MyMainTable (IdCol, col2, col3...)

  select IdCol+1000, col2, col3...
  from SourceServer.MyDB..MyMainTable
set identity_insert MyMainTable off

insert MyReferencingTable1 select col1, col2, FKcol+1000....
 ...

Unfortunately you cannot.  You must trace to a file and then load it to a table later.  You can do the table load manually or through scripts.

...and best to make sure those students haven't set up anythings else in model - views, stored procedures, functions, etc, and especially fixed database roles for themselves.

How are you disabling the jobs?  On the off chance that you're using ad hoc direct updates rather than EM or sp_update_job, then SQL Agent's cache is not refreshed, and...

What are we going to do with all this proccache information data we've collected.  Not much use unless we collect some sort of timestamp too is it? 

In a real situation...

Thanks James.  Good article.

There is too another handy reason (for dba admin stuff) for creating "sp_" stored procedures in master. 

Say you're working in database X and want to run...

The correct answer is in line with what BOL says, but one would think that if I ran the code below I would get "master proc" displayed.  But I get "pubs...

Actually the "correct" answer is the closest to being correct (which is why I chose it).  However, all the initial posts in this thread are right... it is indeed RSReportServer.config...

Estuardo,

You should be able to do what you want to do without a router, but it's not something I would recommend.... either a router (with most ports close or in...

Estuardo,

Do you have a router (with port forwarding) connnected to the Internet, or is your SQL Server (81.193.38.224) connected directly to the net?

Let's not forget our "other DBMS" colleagues.  

With "anOther DBMS", integer is an alias for a particular definition of numeric, so Rob was maybe quite justifiably stumped. 

I would imagine that nulling the column will result in heaps of logging for rollback purposes.

I could be wrong.... wouldn't be the first time.

If other...

That varchar column isn't all null is it?

A table-based UDF is often given the tag "parameterised view".  Check them out in BOL.

Are you sure Mtr_Func is not one of the non-comparable data types?  I've tried it on northwind..employees and the result is different if I remove a "normal" data type,...