DUH!!! @BigTemp needs to be initialized in the trigger -- I gave it a value of ' ' and the trigger works. If I do not give it an initial value, the...
Thank-you all for your help! I will continue looking at this. SQl is 2k sp4. The word 'Description' does turn blue in QA, that's why I was looking...
I am unable to set the value for the field named "description" in the insert statement, but I can use the update statement to set it's value in QA....
- happiness begins where selfishness ends - don't let making a living prevent you from making a life - the best thing a father can do for his...
Very nice sayings.... especially touching: ------------------ If someone comes into your life and becomes a part of you but for some reason s/he...
Ahhhh, thank-you! Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." --Dale Dauten
Thank-you Mirko, I rechecked the code I copied & found that it was not exactly what I was using, but a previous version. Both month and year queries...
Thank-you, Jain, I am testing 'between' now. Dinesh, the query will be used across years, and I do use multiple years when testing. That was just a...
I have a database in SQL2k that I need to run a summary query against for my users to access from an intranet ASP page. It is a very simple query,...
Thank-you, thank-you very much... <img src='/community/emoticons/emotion-5.gif' alt=';)' /><br /><br />Karen<br /><br />"There are two documents in...
Hi Derrick, It would be nice if the error messages when trying to install the sp would indicate that you are installing the wrong version... but that...
That's it, Luis. I will apply the sp ASAP. Thanks! Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." --Dale Dauten
Thanks, Derrick. I can only do what I can within this job's boundries. <img src='/community/emoticons/emotion-6.gif' alt=':(' /> I would love to...
Thanks, I have tried numerous time to install the SP3 or 3a, but it never installs. This SQL server has SP3, but I am unable to apply the sp to the...
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Desktop Engine on Windows NT...
HW - Too much info is better then too little! Sorry to make you read soooo much! The available memory is an issue at this moment - I think that the...
Hi Luis, Yes, both have same sp. Configuration? Do you mean the hw, or do you mean sql server? Karen "There are two documents in your in-box:...
I am hoping there is a simple answer to this and that I am just not seeing it right now. <br /><br />I want to write a select statement that gives me...
Thomas - sorry to not have answered earlier, I did not get notice that I had a response. 2 instances were not by my design, but the design of the...
There are 2 instances of SQL 2000 on a server. The main instance is fine, the other has occasional problems. Generally what I do is check the...
Separate names with a comma.
