True. I've heard that before too....

My thoughts exactly!

pupa

David Benoit (8/12/2010)

---

Ray K (8/12/2010)

---

David Benoit (8/12/2010)

---

Ray K (1/12/2010)

---

This is more curiosity than anything else . . .

In perusing these forums, I'm noticing a great deal of geographic diversity (which...

mmmmm

The statement you provided will delete from table1 only.

Brandie Tarvin (8/6/2010)

---

John Rowan (8/6/2010)

---

I've been using it so long, I can't pinpoint where it...

I've been using it so long, I can't pinpoint where it was. Was it...

You should delete all rows from one table, then all rows from the next, and so forth until you've cleaned out your tables. If you are nervous, do it...

There is a property that you can set up on foreign keys that will allow for cascading deletes which is off by default.

But to make sure, I'd have to delete...

Ah, your ClientID column needs cast.

INSERT INTO ClientAlias(ClientAlias,ClientID,defaultalias,enrolled)

SELECT Clients.Name + ' (' + CAST(Clients.ClientID as varchar) + ')' as ClientAlias,

Clients.ClientID,

...

My bad.....replace the & with +......

INSERT INTO ClientAlias(ClientAlias,ClientID,defaultalias,enrolled)

SELECT Clients.Name + ' (' + Clients.ClientID + ')' as ClientAlias,

Clients.ClientID,

...

Well, the first step is deleting data is identifying which data you want to delete. When you have to delete related data from several entities, you need to write...

Right, but nowhere in your code do you reference the target databases (outside of your print statement). Your DELETE statement needs to reference the target database name using the...

It's because you are connected to your master DB. Build out your SQL statement to reference your table with databasename.schemaname.tablename.