Don't forget you need suitable permissions on the SQL2000 box to do this.

You may have read/write access to tables but DDL statements such as CREATE, ALTER and DROP may not...

I'm not suggesting we should be just database geeks or stand Canute like before the .NET tide.

I'm facing a situation where I have inheritted a mission critical system that was...

C:\WINNT\system32\os2 ?????????

Look in the C:\WINNT\system32\os2\DLL folder and see a DLL called doscalls.dll

Write out a million times "I must not be cynical".

You know morale is low when the company does a...

CREATE TABLE dbo.Product (

ID Int Identity (1,1) NOT NULL,

ProductName VARCHAR(50) NOT NULL ,

...etc

)

The parameters of identity are the start value of the sequence and the increment.

You can...

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')