Red Gate's Log Rescue is SS2K only. ApexSQL and Lumigent have 2005 tools.

Could it be reindexing? Those are moved across and could cause the logs to grow.

I bet that once a named instance exists, the setup program detects it and prevents the install. It's possible that a scripted install might work, but I've not tried it.

The user owns an object, in this case, a schema.

Move the schema to a new user and then drop this one.

I've debated this a bit and there doesn't seem to be a reason to do this. It's likely poor evaluation of the indexes in place and just adding another one.

My...

First I think you need

... sp_executeSQL N' alter table ...'

And it works for me, SS2K5, dev, SP2.

Columns added to table.

Do you have permissions to add columns?

Steve has stated the question well and I don't think this is supported. I think the intention is that you'll only stay the same or upgrade versions, not downgrade to...

Is this in the log for the maintenance plan? Which job is this for?

As mentioned above, someone must be changing things. SQL server doesn't alter permissions for any reason.

SQL Server will tend to take as much memory as it can unless you limit it. This memory was probably used at some point and SQL Server isn't going to...

The values inserted aren't the same. You're using a code that's different fo the first "s" in the #temp table, so it's not equal to 'Malteser Schlossschule'. the cast to...

Micheal typed the words before I could. I'd go with the names, for the same reasons. They shouldn't change, and if they do, this helps you follow the history in...

SSIS or DTS can do this.

It's basically script the objects, run the script (you might have errors), and then copy the data.

Since the way things are structured is different, you...

You would be better off posting this on a web site devoted to development.

The idea of the browser is that it isn't connected to the back end. each page, even...

It is a good basic T-SQL book, but it doesn't cover 2005 stuff very well, which is disappointing with the sticker on the front that says it does.

I'm working my...

Jeff and his RBAR 😉

Learn how recursion works. Even if you don't use it in SQL Server, it's a good tool to understand.