My guess is your client PC (your machine) is Win XP and it has used it's sometimes useful caching of credentials to hold the domain and user you mapped to...

Assuming you are on SQL2000 the answer is "rather poorly". By careful construction you can make the XML match your schema (using EXPLICIT option of FOR XML - beware this...

My guess is the optimiser is being too clever for your own good here ... as it knows bit can have only two values it assumes it will not be...

I have checked on a "Standard" edition copy of SQL and this sp does exist (it should be in sp's under master database) - you might want to check if...

Another thing for speed - on a MS LAN it is significantly faster to map a drive letter to where you are copying from and copy via that (i.e NOT...

I have also used John Franco's method - it is worth pointing out though that you cannot simplify this to

select cast(cast(getdate() as integer) as datetime)

even though...

Kathy - beware your fix only works if the insert into the initial table is a single row insert - if multi rows are inserted it may faile again -...

I think your problem is probably a timeout trying to open a database in the EM tree

Once you get EM open use Tools/Options and first check the Server Registration Info...

Yes - charity it is Amit - the appeal for Niger would be good

A fairly simple "poor mans" way (i.e. no need for 3rd party tools) of ensuring you pick up the changes is to script all theobjects of both existing live and...

You might find it easier to use the "Information.Schema" views to get your structure e.g.

SELECT

TABLE_NAME [Table Name],

ORDINAL_POSITION [ID],

COLUMN_NAME [Column Name],

DATA_TYPE [Data Type],

CHARACTER_MAXIMUM_LENGTH [Size]

FROM

INFORMATION_SCHEMA.COLUMNS

WHERE

TABLE_NAME='Customers'

DTS itself runs on the CLIENT machine - so e.g. if from your PC you open up SQL Enterprise manager and run one of the DTS jobs on any server...

Not sure what you are trying to do - but if you are looking for a way to backup SQL DTS jobs and even restore them to different servers etc...

For info - this is a problem with the "query analyser" front end as it splits up the string back from SQL Server - now if you avail yourself of...

This article is really too simplistic. As others have pointed out the idea of refreshing the development DB nightly is a non runner with true development as it means any...