Recent content by jeannelc

That's it -- I wasn't sure how I could pass the company/post identifyer to the view to filter the records. Thanks! Jeanne Clotfelter Database Analyst IT Computer Technologies Kentucky State Police

I am developing a Personnel system for our State Police in SQL Server 7.0 with a Visual Basic 6 front end. We have over 20 posts and labs that will be responsible for entering background information on existing employees. Once these data are in, the posts will have no access to the database...

Thanks, The problem was with net send -- it wasn't working properly. I restarted messenger service and all is well Jeanne Clotfelter Database Analyst IT Computer Technologies Kentucky State Police

HELP!! I'm running SQL Server 7.0. I am trying to send an alert via net send (since for many reasons I cannot use email). I have one set up on my development server that works fine, but I can't duplicate it on my production server. The problem seems to be with getting the alert to fire in...

Recursive trigger is off -- always was off -- this was the first thing I checked. I also tried disabling the other triggers. This did not alter the problem in any way. All other triggers and constraints fire properly. This is the only one that causes any problems.

I have a table in SQL Server 7.0 that has a series of constraints and triggers attached that were created via Enterprise Manager. Each one is run separately, there is no explicit nesting. There are 2 check constraints and 5 triggers. The table also contains 8 foreign keys mapped to other...