There's a report you can get on schema changes. Deleting a table is a schema change.

Right-click on the database in Management Studio, and select Reports, then select Schema Changes....

I've had a couple of good uses for CLR.

One is similar to something already mentioned, it returns drive data about remote drives. I use this to test...

There's a great article on how to do that kind of thing at http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/.

glee777 (1/22/2010)

---

... I am trying to run a SQL on a table to see what changes were made to the system.

Can I use one that's on my system in a...

I haven't been active on SSC much for the last few days, and probably won't be for a few more, because of my new job and getting settled in to...

I'm not sure what you mean by "embraces". Did you mean "embarass"? "Embrace" means to hug or contain. "Embarass" means to make some look bad.

XML indexes work by creating a relational model of the data and storing that in the index.

In other words, they do a behind-the-scenes transformation into relational structure. Because they...

You probably could use XML, but it'll almost certainly end up with worse performance than a purely relational table.

Why not a table that lists permissions and rows? Could be...

Is there a slight difference in the database name this time around? Either that, or the replace command was issued without you noticing it, would be my guesses.

That's talking about exactly what I already mentioned: Stored procedures called by other stored procedures. (That's the SQL version of it...

It takes the place of the table name in the "for each table" proc. Comparable in the "for each db" proc.

I guess I'm not clear on what you mean by subroutines here. One stored procedure can call others, which is how I'm used to thinking of subroutines - code...

Just don't run a script like that on any column that might intentionally include XML.

And hope nobody has a password with brackets in it.

That's why I recommend actual regex functions....

I'd be inclined to recommend using CLR regex functions for that.

And I'd use them on inputs, instead of scanning the whole database every hour.

Steve Jones - Editor (1/14/2010)

---

I actually have an offer from a Toshiba employee, not in the computer or laptop area, to escalate. I did leave a message with the corporate...