yepp, it was my fault to not check the db for policies. It was a software called TCPCM by Siemens (!) checking the database for invalid objects, i found a...

Turned out, the database had AUTO_CLOSE on. and Backup with veeam caused the troubles.

hm.
it looks like the error i had, but i did not apply the same solution.
Thanks for your help/replies

Session was killed by human intervention. I think it was killed because another session was blocked by Checkdb. (I'm not sure what the initial intention was, but i will prevent...

Just for the record.
The session was running until just now, when I restarted sql service.
Now its gone.

But the rollback is running for 6 days now, and it still shows 45% rollback completion. 
The linked information from @MadAdmin (thx) states, the rollback should be in...

Hm. 
the weekend is gone (d'oh!) and the transaction is still in rollback state. (d'oh!)
No blocking sessions found.
Database is about 70GB in Size.
so it looks like i...

Thanks, that made some problems yesterday.

Really?

i'm on:

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)

Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

seems there are some more issues with...

sorry, i did not make that clear!

the script works fine, but after rename and refreshmodule both of the Stored Procedures return 1

and not as expected 1 and 2

Thanks you Gail.

Now this makes sense.

I didn't realize this behaviour till now.

Thanks for enlighten me. 🙂

Thanks for the info.

I allready know there are different ways to solve this. that was not my problem

I was curious if anyone knew this behaviour, and why it works this...

Thanks to all of you for helping me out.

I did the following To speed up the View:

RTRIM(LTRIM(projekt_name)

The execution plan shows, that the index is not used any longer...

Did it for me