Copied file to local drive and it worked ok. Thank you, Steve.

All I need is 5-10% of free space. But it gives me more than 90% of free space. So the data files didn't seem to be shrinked. Any idea?

Thank you very much for the input. I ended up restoring from backup.

'...installed a new database (Sales)'? or installed new sql server. Is there a way to change the collation at the server level?

Thank you, Katya. Your script worked!

I denied read access, but the db is still functional. If I take the db offline, then I have problem bring it only due to the data file not accessible....

Will I have to do this on all Servers with named instances and all clients connecting to these servers? Is there an easy way out? Will the use of a...

It depends on how long the transaction had been running before you killed it. It will take the same amount of time to rollback that transaction...

Have you tried...?

EXEC sp_change_users_login 'Auto_fix', 'userlogin'

Thank you, guys, for the input. Can you actually code clients with an alias connect to a server/port (a named instance)? I thought for named instances, tcp ports can be coded...

Thank you, Mark.

I ran DBCC UPDATEUSAGE('tempdb') and then checked space again, nothing has changed. Enterprise Manager tells me that available space is 0. How do I know if tempdb or...

I am not sure if Simon is still reading the thread. Any help would be appreciated. I created the function in my code. The script engine is expecting variables for...

Thank you very much, Simon, for your assistance. Actually, I am modifying the following script (check logspace). I want to check the db status before calling the MSActions as...

Even with one final Tlog backup, the 'correct answer' is wrong. Wouldn't the final Tlog backup include the 'disaster' already? Since the Tlog backup runs every 4 hours, the latest...

Let me try again:

How can I make sure all logs are applied and no new transactions are accuring? How much downtime would it require?

Thanks in advance!