Antares66,

I understood the contention business. The update trigger action in theory could lead to an infinite loop. With my situation, how would you move this to the SPs...

Andy,

That is one amazing code. It works great. For mromm, I knew how to add getdate() to the default but I also knew that I had to write...

1) SQL Server 2000 with SP1.

2) At first I had 1 table with 270 columns and I got error 20068. I broke the table into 2 tables (240 and...

Is there an perfomance issue with respect to read and write to the view from an external app? It seems that every time you write to the view, SQL...

What are the limitations a view has that a table doesn't? I know that it does perform a join between tables so you can treat as one. Can...

The software application (C++) that logs data to the database was written by another group. Splitting the table will definitely impact their code. SQL Server doc. shows that...

Isn't it better to use functions instead of stored proc. in this case?

I am running into the same problem. According to Microsoft support site, the machine that you are performing the backup must be part of a domain. If that...