Spot on DC Peterson!

The design of the real package is very similar to my example.

A CommonObject held about 50 fields that were common for any single specific table no matter...

Just as a matter of interest what design would you put in place instead of the example given?

Windows for Warehouses? Shortly after the release of Windows for Workgroups.

Then there was a Geordie version of Windows.

For those of you who don't know what Geordies are, they...

One of the great disillusionments of my career is seeing the backend databases for applications that are making money hand over fist.

I would agree that many of the database designs...

I didn't argue for well tested stored procedures replacing DRI. That was the opinion of Phil Factor.

I strongly believe that whether to use DRI is a design issue and...

Possibly something to do with the time taken to open/close a connection to the database?

What I meant was that, depending on the tool and font, double underscore is not visibly that different from single underscore.

COS(1) produces 0.54

SIN = Opposite/Hypotenuse

COS = Adjacent/Hypotenuse

TAN = Adjacent/Opposite

SIN, COS, TAN functions in SQL server work on radians NOT degrees. As a circle is represented by 2 PI radians...

I would steer well clear of depending on sp double-underscore as a determiner for bespoke stored procedures.

Firstly, a double-underscore isn't obviously different from a single underscore.

Secondly, I feel it...

Take a step backwards.

What is the business problem that you are trying to solve

The way that I do it is to create a standard batch file that contains a bunch of OSQL scripts.

All my objects are generated in scripts which I break down...

In hindsight, no.

With foresight:

Do the update with a begin transaction but commit transaction commented out. If you get an unexpected number of records updated then run the commit.

My...

http://www.sqldts.com/

Look at their book list

The professional Sql server DTS by Wrox is OK but I wouldn't pay full wack for it as it is a little dated now.

If...

If you look in sysindexes and look at any clustered indexes there is a rowcnt field that contains the approximate count for the number of rows in the tables to...

Firstly add the path of the WZZIP.EXE files to the PATH environment variable. Having done so restart MSSQLSERVER and SQLSERVERAGENT. You should now be able to call WZZIP...