Managed to solve it using a static cursor and using using a XLOCK locking hint for the select.

The core of my problem I have posted as a different topic but wouldn't mind understanding the reason behind codes working differently in various versions. In my both environments the...

Doesn't really work. This is a funny situation here. While it works perfectly with SQL 7.0 and Personal/Desktop Edition of SQL 2000 the same code doesn't seem to work in...

Checked on the permission issues. User has permission to execute the procedure from where this cursor is being used and the user also has permission to perform dml statements.

Chose the DTS way writing an ActiveX task and Paul's script worked right away.

Anybody got ideas on how not to produce a file when there are no records at all...

Thanks Guys,

Was lot of help from your suggestions.

Regards,

Kaushik

Ok. Here's how I understand this to be done when using DTS.

Create two connections one sqlserver and one Text File(destination) and connect with a tansformation task. While creating the...