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.

You need to shut SQL Server down for this to be safe and effective. I know people don't and vendors say it will work, but I'm not sure I trust...

AFAIK in this case it would be the same plan. An IN is a shortcut for multiple ORs.

What doesn't change? are you sure the record didn't have a null?

Run the query without the stored procedure, just the update. Does it work?

2005 up there, I'll do 2008 now.

The scenarios I saw weren't overly complex, but they cover a wide variety of add/edit/delete objects (add user, edit linked server, etc.), so the best thing is to be sure...

The inplace upgrade is a one-way thing. There's no easy rollback. You can uninstall, reinstall 2000, attach dbs, etc., but it's slow. If you have time, and people understand this...