I thought as much, but I had to give it a try here before giving...

Evil Kraig F (2/20/2014)

---

SELECT CONVERT( INT, LEFT( column, CHARINDEX( column, '\') - 1))?

What chapter in which textbook are you guys working on? That'll help us know what they're trying...

Figured it out: There was another instance of the receiver queue that I did not know about, and SQL Server was load balancing between the instances.

I ended up solving this problem by using the below query instead. Even though access to the system views appears to be the same, my network service account does...

Erland Sommarskog (7/16/2013)

---

Put the statement in a stored procedure or user-defined functon. Sign the module with a certificate in master. Create login from the certificate and grant that login VIEW...

OK, I appear to have fixed it by telling the profiler to watch for RPC:* events. Apparently adding a parameter turns the query into a remote procedure call.

Yes, that is exactly right. In my case, this was a test database and the logfile was created in a different version of...

I had this issue on Sql 2012 and fixed it this way:

1) Stop SQL

2) Delete the recovering database's log file

3) Start SQL