Also check with the network admin to ensure there are no firewalls in the way.

The message posted said to check the latest errorlog for the last messages and fix whatever those messages said was wrong. So, I'm asking what were those messages and what...

What did you find when...

All you had to do was kill the tape backup task, offline the DB and bring it online again. Detaching wasn't at all necessary. If you'd looked in the SQL...

To be honest, I'd recommend you rebuild the system databases and then re-apply logins, linked servers, jobs, etc. There's a reason why it is strongly not recommended to restore the...

It means that log segments can't be reused because of replication. Doesn't necessarily mean replication is the only reason, just that replication is a reason.

Btw, deleting a log file...

Again......

If you want the DB readable between restores, why are you not restoring WITH STANDBY?

Once you RESTORE ... WITH RECOVERY you cannot restore any more backups. Recovering a database finishes the recovery process and brings it online and usable.

If you need to restore another...

But your where clause is not checking for a date range. It's checking for a string range. All three values are varchar, so you're getting string comparisons. Remove the CONVERT...

Drop the CONVERT.

Don't give them the SA login. Create a login for them which has exactly the permissions you want them to have and no more.

The sa account is sysadmin, cannot be removed from that role. You cannot deny anything to a sysadmin. Someone with the sysadmin role can do anything to a SQL instance,

p.s....

Could anyone with a moment please check my answer here: http://www.sqlservercentral.com/Forums/Topic1618884-391-1.aspx

Want to make sure there's no small inaccuracy which could get exploited.

You don't need to flush the cache.

An ALTER PROCEDURE invalidates the procedure's plan as it is. Wiping every single other query's and procedure's plan out of cache as well is...

It's also violating software design practices. A stored proc is supposed to return one thing, like a method does in your OO languages. You're asking about a procedure that, depending...