I don't see how we can...

Your addition of the column probably timed out because the database needed to expand to hold the new column and it took too long. A rollback of the transaction...

Ken at work (4/12/2012)

---

I have a table with only two fields (columns).

strInitials - nvarchar(3)

Emp_No - int - Primary Key

However, I wish the strInitials to be unique, i.e. not repeated in...

I would look at the two temporary tables #TYear and #LYear and how they are created. Most specifically the countryCode columns.

Can you provide a second table with the expected results based on the sample data you provided?

By the way, thank you for posting the DDL and sample data, that will...

Mick Opalak (4/12/2012)

---

But if the network were at fault, wouldn't it cause all of the mirrors to fail over? We have other principals/mirrors set up on other servers, using...

If you really want help, help us. Please post the CREATE TABLE statement(s) for the table(s) involved, sample data as a series of INSERT INTO statements for the table(s),...

If you are going to modify the recovery model, don't go to the simple recovery model, you will break the log chain. Instead, change to BULK_LOGGED recovery model during...

Looks like you are using row or page compression on one or more tables in the database you developed on the Developer Edition. You need to go into those...

Okay. How busy or stable is your network? You may want to adjust your timeout. At a previous employer where I had setup mirroring, we set the...

tt-615680 (4/12/2012)

---

Dear All,

I have a stored procedure and I keep getting the following error message:

Msg 468, Level 16, State 9, Procedure "procedurename", Line 129

Cannot resolve the collation conflict between "Latin1_General_CI_AS"...

What is the timeout period for the mirroring for the databases, is it set to the default?

DDL - Data Defintion Language. In this case...

Sean Lange (4/12/2012)

---

That is entirely too vague to give a concrete answer. It is however a good interview question because it should immediately start you asking questions. What is this...

Actually, after running the code, it looks like it does what you want.