The great thing about an X-box is that you can chip it, upgrade the hard disk and get a fairly decent linux install on it for £99!

I think the hand...

Absolutely not.

SQL 6.5 is a totally different architecture to SQL 7 and onwards.

SQL 6.5 is nearer to SyBase on UNIX than it is to SQL 7 on Windows.

You can connect...

I suspect that you can't have an autogrowing file but there is a registry setting that allows you to specify the number of logs you keep.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer] "NumErrorLogs"=dword:00000010

The problem with having...

They don't even have to be SQL Servers!

In your line

[Sales]*[Cdisc]/100 AS [Set Disc], [GP]-[Set Disc] AS [Adj GP Pre Rebate]

I don't think that you can define [Set Disc] and use it in one statement.

Try

[Sales]*[Cdisc]/100 AS [Set Disc],...

In your transformations there is an "options" tab. There is an exception file tab. If you have a file name filled in either remove it or make sure...

I would second the motion to increase the frequency of off-site backups.

I tend to look at a backup on a disk as insurance against cock-ups.

Backup on a tape is insurance...

Firstly, is your 80 column table normalised? If you can have a greatly varied set of update routines then it sort of suggests that the table design could...

Running the GUI profiler will absolutely cane your server. The command line utility has a much lower overhead.

OBJECTPROPERTY and OBJECT_ID

I could be wrong, it has been known before.

I read somewhere about user defined functions that they have to be evaluated on a row by row basis. ...

If calling a function results in row by row processing wouldn't it be better to resort to the old fashioned

IF EXISTS (SELECT 1 FROM dbo.SysObjects WHERE Type='U' AND Name='Customers')

Thanks, I've seen the option and it produces a /~Z string but not the individual parameters.

As BOL says that the user name and password options can be encrypted I was...

Make large cup of non-decaff coffee

I would put check backups first closely followed by check disk space and current server activity.

I have my...

http://support.microsoft.com/?kbid=815495

I have been running the 818 hotfix for over a year now with no problems.

I thought SP3 was replaced with SP3a in any case and therefore you cannot download SP3.

The...