I believe so, but the only way to know for sure is to test it.

If your primary key is subject to change in the way you mention, you may consider...

Well, I don't know why it's working for me but not for you. Please will you run this and post the results:

SELECT

name

,OBJECT_NAME(parent_object_id) AS fk_table

,create_date

,modify_date

FROM

sys.foreign_keys

John

A stored procedure would probably be a good idea. You'll need to use dynamic SQL if it's going to run against different tables, so make sure you understand the...

OS error 32 means the file is already in use by another process. Could it be anti-virus software, or another SQL Server instance on the same computer? You...

I could give you a step-by-step guide, but you should be able to use a search engine to find something like that yourself. Is there a particular bit you...

Please will you post the statement you're trying to run?

Thanks

John

Use the task scheduler in Windows to run the command through sqlcmd.

John

Not quite. FK_Companies_Users is the name of the foreign key constraint, so you need to change that - you can't have two objects with the same name. [>Modified...

It worked when I tried it, but then I'm not using SQL Server Express. It's very fiddly and prone to error if you try to do stuff like this...

a.penasco (3/7/2012)

---

I haven't used triggers to do this. I just built it on the diagram of the database. As I said before, i know very little of programming, so I...

Please will you post DDL for the two tables, as well as (or including) the DDL for the foreign key constraints?

Thanks

John

Also, I don't think anyone's mentioned that you can have many unique indexes on a table, but only one primary key constraint.

John

Most people here will be loath to do your homework for you if you don't show any evidence of having attempted to do so yourself. I find that search...

I can think of two. Is this for homework, or an interview?

John

Ravi

I take it function1 is a function? sp_recompile only acts on stored procedures and triggers.

John