That's because you haven't defined a foreign key constraint.

John

Unless you already had something set up to track changes on your tables, there is no way of doing what you require. For the future, create triggers on those...

I've seen this happen before where the location for the SQL Server Agent log file doesn't have the right permissions on it or doesn't exist.

John

Jeevan

Search on the internet for introductory tutorials for SSIS, then work...

Jeevan

You can write scripts to do this in T-SQL, but file manipulation isn't what T-SQL is designed for, so you're probably best creating a SSIS package to back up the...

Hugo Kornelis (10/21/2010)

An application that does not use triggers, is not involved in transactional replication or merge...

As far as I know, xp_delete_file and others like it are undocumented, not deprecated. That means you should take care when using them since they could be deprecated or...

Use maintenance plans. I think the task you need is called Maintenance Cleanup.

John

I think I would start by removing the cursor from the trigger and instead insert the data as one set into the timetable table. You'll get performance problems when...

Something nobody's mentioned is foreign key constraints. If another table has a dependency on the table you are deleting from, and your foreign keys don't have cascading deletes, you'll...

Please will you provide some sample data in the form of INSERT statements, and show us what you've already tried? You'll find that more people will be willing to...

Ah, so this is an interview question!

(1) Create the table and use the SELECT statement to add the data into it.

(2) "name" is the name of the column you supplied...

I take it your comma key is missing or your Parse button doesn't work?

Anyway, I corrected your code and here are your options:

(1) Create a new table and select filtered...

Please can we have table DDL and sample data in the form of INSERT statements. Then we'll be able to help you.

Thanks

John

Chris

Yes, that's how I'd do it.

John