Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Script to genrerate index, constraints and trigger recreation codes
Thanks for taking time to help. Actually I am fixing things as you suggested but you probably know too, it is a PAIN .. Kevin- meilan
- Post #6
- Forum: Sybase: Adaptive (SQL) Server
-
Script to genrerate index, constraints and trigger recreation codes
-- Dear Gyllr - IActually I feel much pain now using the approch I decided earlier. You mentioned the " an alternative solution is to bcp out the data, re sequence the out file (i use perl to do this), drop the constraints/index, bcp in, re-index, apply constraints..." Can you please...- meilan
- Post #3
- Forum: Sybase: Adaptive (SQL) Server
-
Script to genrerate index, constraints and trigger recreation codes
Gurus I have a small database which has sever identity gap problems. I have read many articles about fixing the problem. Since I don't have sa right, so most of the scripts I can not use. This is what I proposed to do. Giving a identity column in table A, drop all the indexes, constraints and...- meilan
- Thread
- Replies: 5
- Forum: Sybase: Adaptive (SQL) Server
-
How to aviod dead lock while loading data simultaneously?
Deal gurus We have a database gets loaded from five different sources simultaneously. They are hitting almost same sets of tables. How do I avoid dead locks? Any ideas? tips? If you have faced the same problems before, please help. Thanks in advance- meilan
- Thread
- Replies: 1
- Forum: Sybase: Adaptive (SQL) Server
