Thanks !!!

I dunno ... the servers are now closer together. Is your SQL Server's NIC card set to 100 MB/Full Duplex ? Is the switch port that your SQL Server is...

A test cluster is a wondweful thing. It took me a year to get one and it has been a 'true' blessing to have. Enjoy the luxury !!!

The error: [SQLSTATE 42000] (Error 22029) is kind of generic and kind of not. It may be a login/authentication error. You may want to check the system event logs on...

That looks like the list. One caveat is when changing the MSSQLSERVER and SQLSERVERAGENT you need to use EM. It seems that it does some registry 'stuff' that the Computer...

DBCC TSWSQLXP ???

I think that I may need a bit of education on this one ...

They should be run on a regular basis, just as you would in Oracle (daily, weekly). Basically most tasks that you set up for maintenance in Oracle to keep your...

My guess is that you are logged on as a domain user. This user account is not in the local administrators group of your SQL Server.

... it has taken me a bit of time to get back to this thread ...

 ...I have been busy putting aluminum foil up on the walls, windows, ceiling and floor...

Yes Phil it will work. However if you are going to be working with Sybase, especially older versions (pre 12.5) you really should get used to 'mucking' with the system...

Are you logging on to the SQL Server directly or are you logging onto a PC or another server  before you attempt to connect via EM ?

The short and simple answer is to leave it alone. SQL Server will use all CPUs on the server for processing.

The long answer is that the affinity mask controls...

SET COLD_REALITY_MODE ON

"What" have "they" taken away from you ? Just one thing. Our "illusion". Anthony Hopkins in the movie Instinct provides an excellent education on this subject.

SET COLD_REALITY_MODE...

There are so many questions to ask in order to begin to perform a high level analysis of the situation. It's a project in and of itself to gather all...

Sorry Andrew ... it was a late night for me and I forgot my 'swami' headdress today