Something to note - installing an unsupported application (SQL 2000) on an unsupported OS (any that would support SQL 2000) will result in an unsupported scenario.

That being said, a quick...

My opinion - check the logs.  The message "the login failed" makes me think that the account was locked out or otherwise disabled.  If it is an AD account, if...

Is it always failing on the same file?  If so, then it is likely something with that file and the restore.  If it is sometimes failing on that file and...

My approach is to design the database with restrictions in place to begin with.  Use roles to restrict what data a user is allowed to access.  I expect (ie hope)...

Might not hurt to check out the Exchange error logs and see what those say.  Could be something that is easily corrected by reviewing the logs on the other side...

SSRS Standard, as far as I am aware, doesn't support clustering and only allows you to host it on 1 server.

I believe you would need to upgrade to Enterprise to...

You could use ISNUMERIC.

Personally, if I COULD I would be changing the application that puts the data into the system to validate it and refuse to store invalid data.

Failing that,...

I've been noticing this too.  Hopefully it gets fixed soon.

I DO get notifications to new private messages, but not to replies to forum posts...

Alternately, if you don't have a VS subscription, you could reach out to the company you purchased SQL Server 2012 from and they should be able to provide you with...

My opinion - I would do whatever works best for the tool you are using.  BUT I would also be careful about using a tool to monitor SQL error logs. ...

My advice - review the error and check the logs.

The error should tell you what is wrong, and in the event it doesn't, the logs should tell you what is...

Things that I would check are:

1 - does the service account have permissions to the folder AND file?

2 - does any other application or service have the file open at...

With our system, we had turned on successful login logging on one of our systems and had a HUGE performance hit to the database.  The problem was caused by how...

Without seeing an execution plan or ddl, I the below are just guesses.

Depending on the number of rows returned by your nested select, you may get better performance by changing...

Have you tried opening the master key by password and adding encryption by service master key?