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!
-
Anyone tried SQLJ stored procedures in ASE 12.5?
We're thinking about installing the SQLJ option for ASE 12.5. (the option that allows Java classes in the database) I'd like to know if anyone has used it and whether or not they find it useful. What are the pros and cons? Is it an expensive option? Any insight is appreciated...- cellis12
- Thread
- Replies: 0
- Forum: Sybase: Adaptive (SQL) Server
-
How can I Rename an ASE Server?
Does anyone have any experience with renaming a Sybase Dataserver? Is it possible? Advisable? Is it as simple as changeing the syservers entry (I suspect not)? I know I can change the interfaces file to address the server however I want, but I'd really like to have the servername changed to...- cellis12
- Thread
- Replies: 1
- Forum: Sybase: Adaptive (SQL) Server
-
Start master in Single-User Mode (11.5) WinNT
I don't think you can put a dataserver into single-user mode. If you mean to put a database into single-user mode you use the sp_dboption command, like so... USE master go EXEC sp_dboption 'your_db_name','single user',true go USE your_db_name go CHECKPOINT go whrere 'your_db_name' is the name...- cellis12
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
-
Foriegn Keys
Remove the quotes from around the constraint name and it should work. Like so... ALTER TABLE dbo.Advisor_Client_Reg ADD CONSTRAINT FK_Advisor_Client_Reg_Advisor FOREIGN KEY("ADVISOR_SEQ_NO") REFERENCES dbo.Advisor("ADVISOR_SEQ_NO") GO Good luck, Chuck- cellis12
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
