Oleg Netchaev (5/21/2010)

---

I was just trying to point out that nonclustered index might be not an option in this specific case if table variable is used. This is because I...

I really thought you could. Sorry about that.

Would it be practical...

Maa421 (5/21/2010)

---

At the risk of asking another dumb question: Do you know if I have to install the CU's for the clients as well as the server? That is...

Using a synonym to point to the correct database seems a natural solution.

Of course 🙂

jcrawf02 (5/21/2010)

---

Paul White NZ (5/21/2010)

---

This...

So, it looks very much as if the transaction never really 'got off the ground' so to speak, and is now in an odd sort of state. My guess...

The date format used depends on a number of settings (see Books Online Date and Time Data Types and Functions (Transact-SQL) for the details).

There isn't a default date format for...

The only way I can think of to do this is to change the date and time on...

Before you initiate fail-over, it might make sense to check a few things to give you some confidence that the ROLLBACK is truly 'stuck' and/or that recovery is not going...

Well you can, it just has to be unique and created at declaration time:

DECLARE...

This is SQL Server 2000, right? What is the exact version please? Is the VisitorSources table a heap with non-clustered indexes? The reason I ask is that...

What do you mean 'fixed'? :unsure:

calvo (5/20/2010)

---

Since these errors occurr simultaneously, I cannot catch the first one. I would like to capture the first more meaningful error but I can't find a way to do...

This coming Monday (24^th), Jan...