One simple approach is to create an alias in the SQL Server client networks using tcp/ip

ALIAS:SERVER1

HOST:10.0.0.10

PORT:1433

The in EM under the security tab create a linked server using the alias as...

Please provide sp_configure results as I want to see max and min server memory values.

First of all, from the UNIX command line isql into the Sybase data server and issue Select @@version, which will let you know the version of Sybase you are running....

Are you asking if you can access a Sybase data server on Solaris from a windows platform?

Why can't you use a trigger?

Is a subquery needed

Select thedate, avg(duration), sum(duration)

From table

Group By thedate

If you have multiple runs a day use:

Convert(DateTime, Convert(VarChar, thedate, 101))

Which converts the date 01/01/2005 09:00:00.00 to 01/01/2005 and then convert it...

You are not being very clear but hers some general ideas. Use sp_who2 to inform you if blocking locks are taking place at run time. The part about logging and trapping errors would...

Are you also trying to use AWE with sp4?

Yes, you can just change the service owner for both in the service window.

Are you going from MS SQL Server to Sybase or vis versa.

What version of Sybase are you using?

If I am not mistaken from your initial comments a reboot did not cause tempdb to be sized at 800M, but it happened during normal operation.  Is there any jobs...

Sounds like you are you trying to kill your own session?

I would think more info is needed:

Table structure including indexes and the SQL ran against it.

As far as maintenanace goes the update stats and running sp_recompile are great but...

Add a count to test for duplicates and more

Select duplicating_value, Count(*)

From table

Group By duplicating_value

Having Count(*) > 1

Results:

KORY 5

MARK 2

While your at it:

Select db_name(dbid) From master.dbo.sysdatabases

Select db_id('databasename')

sp_helpdb

sp_helpdb 'databasename'

These are nice to get use to when resolving system problems.