Four-part name rule works for Sybase ASE 12.5 version. But it does not work when I used ASE 15. I do not know why.

Gilamonster:

The error message is in the top post. What I changed is only the database name.

The T-Script I used to check database did not only provide informative message, it also caused the whole script failed. The job was terminated and marked as failure.

In VB, we...

First of all, thank you all for your inputs.

All of my databases are very small (less than 1 GB). I checked CPU and memory. Their usages are both in very...

Set a trace profiler?

If you use LiteSpeed, you may consider to use backup/restore tables instead of whole database.

Did you try to enclose endat with single quotes? Just guess.

How did you restore your backup from SQL 2000 to SQL 2005? Did you re-populate full text catalog after restore?

Please check what should do in full text catalog in SQL...

jagadishrashmi:

Thank you very much. It is exactly what I would like to get.

If you have a LiteSpeed backup, you can restore the table directly.

Jeffrey:

I know someone set it incorrectly. I know I have to change it (to virtual IP). What I would like to do is collect input what impact I may come...

Richard M (3/10/2009)

---

If you have the users connect to the node specific IP address, you are not doing anything to "help" in case of a failover, as a manual...

Thank you so much for your input.

I cannot say I agree with you. If the cluster fails over, and its IP is changed, the IP used by the SQL instance...

Steve:

I got it. There are couple ways getting the created date.

1. Using Scripting object;

2. In the Windows, add the column.

In my memory, there is a place (table) in SQL 2000,...

Jamie:

Thank you for your reply. You are right. A further question is:

Can we find the information inside SQL Server instance?

The reason why I ask is the setup log file has...