David Webb (6/8/2009)

---

Why not put everyone in the same DB and key everything on customer?

If you have a lot of customers, the management overhead of the design you are proposing...

Reddy B (6/8/2009)

---

So, I am thinking of Dynamically passing the DB name and builing the SQL on the fly inside the SP and executing.

My question is, Is it a...

Hmm, took a look at Access, I forgot that they went to these fixed-character input masks back on the 90's, so I think that I was wrong before. I...

Oh yeah, what's the mask that you are using?

I haven't done an Access form in years, but there should be a way to tell it to left-justify, even with the mask. Or, might be collapsible mask characters,...

OK, this is a little bit hard to test with out your table. Try this:

'INSERT INTO LOG_TABLE (TABLE_NAME,Activity, YourXMLcolumn) SELECT ''' + @TABLE_NAME + ''', ''DELETE'''

+ ', ...

GilaMonster (6/8/2009)

---

RBarryYoung (6/8/2009)

---

Well the first thing that *I* do when asked this is...

Hmm, probably needs this extra comma:

'INSERT INTO LOG_TABLE (TABLE_NAME,Activity) SELECT ''' + @TABLE_NAME + ''', ''DELETE'''

+ ', (SELECT * FROM deleted FOR XML PATH, TYPE)'

-- ^

Pusedocursor is a name that some people (including me) use for the SQL Server (and Sybase too, I believe) trick of being able...

Florian Reischl (6/8/2009)

---

RBarryYoung (6/8/2009)

---

Huh. Something must be wrong with...

GilaMonster (6/8/2009)

---

Tom Brown (6/8/2009)

---

I never did computers at University (Chemical Engineering dept didn't seem to have a use for them back in 1984) So this Big 'O' notation is completely...

GilaMonster (6/8/2009)

---

Lynn Pettis (6/8/2009)

---

I must agree with you on this one, Gail. Even though I don't remember much about it, I do remember having it covered in both CS...

Huh. Something must be wrong with my fonts, everything...

Well the first thing that *I* do when asked this is to make...

This also may have been parameter sniffing. I believe that inline-TVF's are treated as table expressions (like Views and CTEs) and thus would not be susceptible to parameter-sniffing.