Ken, I'm not sure that I can picture the sequence of events you are considering. Are you saying that you would analyse the existing SQL Server data and then...

Hmmm - tough one. Is there some way that you can start maintaining a "Transfer to SQL Server?" flag against the Oracle data. You will know from the...

Rather than using straight DTS, have you thought about adding the Oracle server as a 'linked server' and using straight T-SQL to accomplish the data transfer?

What is the relationship between tables a and b - is it on event?

So, in English terms, table a is an 'Account Events' table and table b is an 'Event...

"Also you may want to consider an extra field on the row to say completed."

Expanding on Eric's idea, why not create an extra calculated field on the table = number...

Try unregistering the DLL, type:

regsvr32 '[enter full dll file path and name]' /u

from a DOS prompt and then reboot and try deleting it again.

Phil

I use a Cisco VPN connection over the internet fairly frequently and have no problems with EM/QA over that (except that it trashes my local network connections).

Phil

Yuk. I'm assuming that you have tried (or perhaps you do not want to try!) performing a SELECT of all the fields into local variables and then checking them...

This sounds a bit suspect to me. Can you provide a bit more detail about what you are going to do with the number? If I was filling...

If you are able to reproduce this error in Query Analyser, the message text will be more helpful (the meaningless variable placeholders will be replaced by the actual constraint and...

The alternative to

where field like '%word' is

where RIGHT(field,4) = 'word'

LEFT(field,4) gets the first four characters of field, not the final four.

Regards

Phil

Is this the sort of thing?

declare @col varchar(10), @SQLText varchar(255)

select @col = col

from t1

where id = 2

set @SQLText = 'select ' + @col + ' from f1'

exec (@SQLText)

It's possible to use xp_cmdshell to run commands outside of SQL Server - so this may be of help. I'm not quite sure what you mean by automating a...

So can you reproduce the error - I'm guessing not? But if you can, try stepping through the stored proc in debug mode and see whether that gets you...

Hi Karen

Not sure if this can be achieved directly through a view.

Here's an example of how you can get file info into SQL Server though:

declare @SQLText char(21), @app char(1)

set @app...