When free space of a drive falls below a threshold, the performance will degrade.

One of its reasonings is that Windows uses hard disk to save something temporarily. My experiences...

Did you check ProgramName in the output of sp_who2?

Or did you try to run SELECT * FROM master..sysprocesses?

I would like to check the disk space on T and U drives first, if I were you.

SQL 2000 desktop version may not be accepted to be installed on Vista. Try SQL 2005 express edition.

Did you check timeout setting?

There are some diferences in syntaxt. SQL Server uses T-Script, which is an extension of ISO92/99. But these syntax may not be accepted in Sybase.

I agree with GilaMonster.

In SQL 2000, we can encrypt/decrypt stored procedures, but not saved data.

In SQL 2005, the function of encrypting data is added. Yes, we can encypt data...

Did you try

sp_configure 'remote access'

Why did you use different functions to convert your criteria?

For example,

SELECT convert(datetime,GETDATE(),1)

UNION

SELECT CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)

returns

2008-02-01 00:00:00.000

2008-02-01 14:13:09.733

Is it your problem?

Regarding to your second question, grouping your results by...

Open your DTS in design mode;

Choose Properties from Package on the menu at your top left;

It is under the logging tab.

Just a question.

If you would like to restart the snapshot, do you really need to do all backups on the subscriber side?

How about considering each instance as a standalone server separated from others? That is what in my mind.

Did you try to add log file in your DTS? If so, you can trace errors in detail.

How about

SELECT top 1 * FROM T1 WHERE name ='cash'

UNION ALL

SELECT TOP 1 * FROM T1 WHERE name = 'credit'

Here is a link related to your question in another forum. May it help.

http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadID=213243&messageID=2183768