Try this one:

exec master..xp_getfiledetails 'c:\autoexec.bat'

Alternate Name                   Size        Creation Date Creation Time Last Written Date Last Written Time Last Accessed Date Last Accessed Time Attributes 

-------------------------------- -----------...

Are you sure that you need to spread the load like this? 1500 users per se isn't that much. From the SQL Server point of view, it's not excessive. However,...

Did you notice that it was two years to the day, even?

/Kenneth

Then check the db compat level. If it's < 70 you'll see this error.

/Kenneth

In what way 'does it not work' for others than you? Errors? Messages?

Who owns the proc? You or dbo?

In any case 'others' must have execute granted to them on the...

No there isn't.

afaik there is no immediate way to generate 'real' excelfiles from T-SQL. There is a sort of workaround where you (using xp_cmdshell) when naming the output file use...

Would this work or produce the same error? (alter is copied from first post)

use tempdb

go

create table dbo.EstDealDetail ( FundNo tinyint not null )

go

insert dbo.EstDealDetail select 1

go

ALTER TABLE dbo.EstDealDetail...

This seems strange. It works perfectly fine for me. Has to be something else than the syntax, it's just fine. Have you tried that exact statement in QA?

/Kenneth

Why do you want an identity column added?

'TheDate' is your natural key it seems. Why not use that as PK?

PS. The error you're getting is exactly for the reasons...

The only way for you to know for sure is to try it out on your data.

Check the plan for your existing IN variant, and compare it with your alternate...

Thinking about it, this seems to be a perfect job for BCP, and just skip DTS altogether. If the job is just to load the table from a file, then...

It's no problem at all to use LIKE in a join, just be careful which side is LIKE'd with which.

It should be <longest value> LIKE <short value> + '%'

About the physical implementations of cursors.. Well it apparently depends.. However, I do think that one shouldn't be too surprised if there would be more locks taken and more tempspace...

So you have added an identity column as primary key in table 1 (the source table)?

Did it not have a natural key before that?

If not, the identity alone won't protect...

Yes, that's a major PITA. I don't know of any 'inline' way to do that. The problem is that the only way to be certain the remote server is accessible,...