First time I have used 2005. Trying to follow the article but am stuck at the first hurdle.

'Data Transformation Services' does not appear in my list of templates. See screen...

I also get a similar message when trying to create a new database in Enterprise manager:

Dialogue box:

Microsoft SQL-DMO (ODBC SQL State:42000)

Error 7404: The server could not load DCOM.

However after clicking...

This is a failing job, not a stored procedure. The error message in the Event Viewer is:

Event Type:Warning

Event Source:SQLSERVERAGENT

Event Category:Job Engine

Event ID:208

Date:30/01/2006

Time:16:20:39

User:N/A

Computer:ANTEC

Description:

SQL Server Scheduled Job 'test2' (0x33EE095F4BC451479C4903CDEE9B0D74) - Status:...

Just put my Amazon order in for "The DBA's Bluffers Guide"

Hmmm, I know the answer to some of those questions! How much does a senior DBA earn in Central London.

Can anyone tell me a called package throws up this message. But it does not throw up a message if I run it directly.

I have tried trying to identify where the...

I am using xp_smtp_sendmail for email so this is probably not the problem

I have Access 97, 2000 and XP on the development server and confirm that Access 97 can not read an Access 2000 or XP db.

But ... you are right and...

Yes that's what I concluded I should do. However it does mean when moving the DTS package from one Server to another I have to move the template access db....

This is not a regular thing. Only when I have a major release and want to replicate the production environment exactly.

You have both been very helpful, thanks.

Jim P, many thanks for your help. I thought I was missing something when surfing for the command line syntax. No wonder that Microsoft doesn't attempt to explain.

I was really...

Frank, thanks for the link - will certainly help my understanding.

Also looked through scripts and found two which seemed to apply:

DBCC Reindex all tables and CreateDBReindex (see links below). The...

Thanks for that. Alpha sort is fine, I will get my Oracle colleagues to change the datepart of the file name from ddmmyy to yymmdd

Steve, agree that scripting in Enterprise Manager or QA best way to learn how to create tables. But in this case I am using a table variable.

Thanks Frank, that's it.