The space of the tempdb is = 229498.81 MB and the available space is 215296.58 MB at the moment so no it doesn't look as if there is enough space...

Thank you for your reply!

The backup is taken by a third[arty tool (RedGate), I have fond the versions for both servers and they are both the same.

I have also tried...

Thank you for your reply! I want to do some work on the database then restart the mirroring.

Thank you for your help, I will have to create a trigger as I don't have any audit on the jobs.

Thank you all for your recommendations.

In SQL Server Configuration manager, TCP/IP is enabled.

ALZDBA (9/11/2013)

---

tt-615680 (9/11/2013)

---

Dear All,

When I tried to create a Linked Server I get the following error message would you please let me know what would cause the issue please?

Named Pipes...

To resolve the issue I simply had to find out what the Primary file was called and I eventually found out that the name of the Primary file was called...

Thank you for your reply! Yes, the Reports runs but hungs for a very long time but eventually gets the data but my question is why would the Stored Procedure...

Thank you for your reply!

I now changed the expression to =CountDistinct(Fields!columnname.Value) but I get the following results:

Year ...

Thank you for your reply!

I set the lock time out to be set to 1800, by running the following script, but I still got the same error. I also tried...

Msg 1204, Level 19, State 4, Procedure "procedure name", Line 8

The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when...

I have tried both, but still nothing.

I did not say that I am not typing noting, I said the name of the Server is already there; hence why I said it is the Default Server.

As I said earlier, when I try to connect to the Server X from my local machine it works fine! But when I try and connect from the actual Server...