It's not a difference between maintenance plans and T-SQL. The maintenance plans use T-SQL commands, just like typing them in yourself.

The difference could be the options selected for the...

You should be able to set up a linked server for that in Management Studio. Connect to the 2005 server, expand Server Objects, right click on Linked Servers, put...

Some expansions on this subject at:

http://www.sqlservercentral.com/Forums/Topic536927-145-1.aspx

These two articles have a lot of information on logging and auditing:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

Their discussions add a lot to them.

Which way is the connection going? Is the 2000 server pulling data from the 2005 server, or the other way around?

I could be missing something, but it looks like what you posted will do what you need. Do you have a question about it, or a problem with it?

Take a look at "Create Event Notification" and the linked articles from it, in Books Online. Should have the data you need in there.

The CDs/DVDs are just a convenient way to install on a server that doesn't have an Internet connection, or to reinstall without having to redownload.

No. That won't accomplish anything useful. Views don't work that way.

Second the motion on "SQL Server 2005 Bible". Excellent book. The 2000 version of that book made it possible for me to learn SQL when I needed to.

As always, I'm going to recommend doing pivot operations outside the database. If you absolutely MUST do them in the database, check out the data here:

http://www.simple-talk.com/sql/t-sql-programming/crosstab-pivot-table-workbench/

Phil and Robyn...

This, "SUBSTRING(TPSAptfor,1,CHARINDEX(',',TPSAptfor,1)-1)" will give you an invalid substring length error (which is the one you seem to be getting) if there is no comma in the field.

Select the...

Check out OpenRowset in Books Online. Has instructions for how to do this.

The use of the two is slightly different. If you look at the XACT_STATE code, you'll notice that it has a commit statement if XACT_STATE = 1.

If you want...

I didn't realize your top level had a parent ID equal to its Individual ID. You'll need to add a test for that to the Where clause.

To put them...