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

Jim

It appears it's the Check Database Integrity task that's failing. Can you show us the error message for that, please?

John

Also, for the failure to open the specific database, is the database you're moving the default database for the user you're connecting as? You need to change this to...

Also, don't back up to the same disks that your databases are on, if you can avoid it. If you lose the disk, you've lost the backup as well...

Lowell, I think you're confusing bits with bytes.

Chris, is Byte 0 the eight most significant (highest value) bits, or the eight least significant? I think you need an "OR"...