Rambler (10/29/2010)

---

Hi. I have a table that has a column which contains names of all databases on the server.

How can I find out transaction log name for every database in...

There are loads of threads on how to do this, if you'd care to search for them. You need to do something like this (not tested):

WITH MyWords AS (

SELECT

ROW_NUMBER()...

Doug

Please supply table DDL and sample data, and then we will be able to provide a tested solution.

Thanks

John

Why not just do it like this:

SELECT * FROM employees

WHERE emp_city = @city

AND emp_department = @department

AND emp_name = @name

I recommend that you read this:

http://www.sommarskog.se/dynamic_sql.html

John

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...