Windows Auth seems to be a bit slower to me too - no a lot just enough to irritate. And there is an issue that you can't have a linked...

I do something like this with all tables to be allocated compound ID's listed in one table giving the "identity" number to allocate

Table controlling ID's is

CREATE TABLE [SYS_SEQGENERATOR] (

[TABLENAME]...

The main problem with log growth with Reindex will be when you reindex a clustered index as the index and data pages are the same so moving pages in the...

I don't think Excel driver allows for rows to be deleted from it - see http://support.microsoft.com/default.aspx?scid=kb;EN-US;257819

Surely holding the date/time in a varchar column should also grate ....

Word 2003 supports an XML file format - default is still to use a Word XP/2000 .doc format though. The spec for the format has been made public domain

This error occurs when you are using Windows Authentication (your "Server side" connect string) when the user connecting is not authenticated with the domain scenarios I have seen this in...

You also need to watch for authentication failures accroos the boxes - what authentication are you using - is it Windows Authentication? and how are the Linked servers set to...

I would only Unicode the fields that need it - and there has to be some business case to say they do - the doubling of data space is an...

You probably can't decrypt but the chances are you can find which package it is by running it - many options really - it depends hwo many DTS jobs you...

It has to be true ... an ordinary index is essentially a set of pointers to where the data can be found, a clustered index IS the data (i.e. the...

Make sure you haven't left anything that displays a message in any scripts in the job - e.g. a MsgBox in ActiveX script etc - try running the job interactively...

Check the steps in your package to make sure they haven't got timeout values that could be timing out

Grajee - named pipes is not only for when clinet and server are on same machine (though it is most efficient in this mode) - actually it is a crude...

Also beware international settings '1/1/2005' is fine - but what if you want 1st Feb - is it '1/2/2005' or '2/1/2005' - that depneds on reginal settings etc - I...