Viewing 8 posts - 1 through 8 (of 8 total)
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...
December 19, 2002 at 11:07 pm
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...
December 18, 2002 at 10:50 pm
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...
October 8, 2002 at 11:09 pm
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...
October 4, 2002 at 9:42 am
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...
October 3, 2002 at 9:48 am
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...
October 2, 2002 at 8:13 pm
Isn't it better to use functions instead of stored proc. in this case?
September 28, 2002 at 11:39 am
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...
June 4, 2002 at 9:20 pm
Viewing 8 posts - 1 through 8 (of 8 total)