Sorry, that's my bad, as SOUNDEX wouldn't work here anyway.

Basically I'm trying to find a way to get away...

I don't know how FT reacts to the blob types like nvarchar(max) which you have in the table, but I do know that the inclusion of these columns in any...

IN SSMS you need to go to Tools -> Options -> Scripting and set Script FUllText Indexes to True. Then when you generate the table script it will include...

sknox (4/9/2012)

---

That was a bad example. Let's get down to the key (no pun intended) area of contention: enforcement of RI. Would an object defined by the following statements be...

It would also be helpful to have the table definitions and the creation statement for the FT Index.

You probably want to get rid of the index hint on...

I'm not a Full-Text search guy, but SQL Server caches data in memory the first time it is accessed so it could be as simple as the data not being...

Changing the ISOLATION LEVEL doesn't affect the any other SET options that I am aware of.

The issue could be that the servers or the databases in dev and production are...

sknox (4/9/2012)

---

Sean Lange (4/6/2012)

---

sknox (4/6/2012)

---

NO.

Any column in a table is a...

Why not populate the lookup tables in the dev box from the production box instead of using linked servers to test. It isn't really a valid test if linked...

You have to drop and re-create the column, which really means you need to drop and re-create the table. You do something like this:

Create TABLE new_table_with_identity(columns...)

SET IDENTITY_INSERT new_table_with_identity ON

Insert...

lsuersoy (4/9/2012)

---

Hi ,

A trigger that has been added by someone else before, also I've done on, modify, I get the following error.

The error is as follows:

Attempt to retrieve data...

lukebaker (4/9/2012)

---

I building a c# windows application and trying to use the trigger to put the old data into the traininghist table. The error im recieving from visual studio is...

Stefan Krzywicki (4/8/2012)

---

Perry Whittle (4/8/2012)

---

Ok...

Sean Lange (4/6/2012)

---

Hugo Kornelis (4/6/2012)

---

Sean Lange (4/6/2012)

---

Basically you can simulate a foreign key via triggers but it is NOT actually a foreign key. In that case it is more of...

Okay a couple of semi-technical questions:

What do you all run to backup your home systems?

I may need to buy a new laptop soon. I use it for work and...