Jason Miller (3/17/2009)

---

I don't see software as a commodity happening during my life / career. It very well may happen, but I think I'll be dead and buried for...

Glad we could help, and that it turned out well. Good job on that.

steve dassin (3/16/2009)

---

Gift Peddie (3/15/2009)

---

Science is a b****, expediency is a w*****. It's not easy to sleep with science. But sql sells itself to even the lowest bidder. It's been...

At Busch Gardens in Tampa, there are signs all over the place that you can't ride if you have high blood pressure or any sort of history of heart conditions....

Take a look at these two articles and the discussions on them. Lots of data on auditing, including some options that may not have occured to you.

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

I think it's inevitable that software will be a commodity. On the other hand, chairs are a commodity, but Laz-y-Boy is still in business. That makes it hard...

Here's one way to work with this kind of thing. This solution assumes you have a Numbers table, and that you are working in SQL 2005 (as per the...

If I understand you correctly, it will look something like this:

create trigger Table1_PrintDate on dbo.Table1

on update

as

insert into dbo.Table2 (KeyValue, Print_Date)

select i.KeyValue, i.Print_Date

from inserted i

inner join deleted d

on i.KeyValue = d.KeyValue

and...

Not really. The reason indexes can't enforce (or even contain) too many bytes of data is structural, and critical to database performance.

You can make either triggers (probably a bad...

Yes, I have been the first DBA for two different companies.

I recommend getting backups and whatever other maintenance you need, automated first. If that means working a weekend, since...

You're welcome.

Gaby Abed (3/16/2009)

---

"In...

If you can, please post the execution plan. I'd also be interested to see the trigger. It's definitely a point to look at, especially if it's got to...

My last two jobs:

First one: One Friday afternoon, everyone in the building was told to pack up their desks and go home, and was told we'd be called if we...

The reason you're getting the column names where you don't want them is you have to put those outside the NullIf, or you need to modify the NullIf comparison.

Try this...