I have only supplied the columns used by the cursor and some sample data. Do you require sight of the whole table & indexes

Thanks for the link and an interesting article, but I was looking to move away from a cursor to a more set based approach, not to replace the cursor with...

I agree with the first point the question is badly structured and I clear as to what was being asked. However point two, I'm not so sure about

http://msdn.microsoft.com/en-us/library/cc949109.aspx

states

"There...

The server was renamed months ago, the server has been shut down and restarted twice in Feb, so i would have to go with in this instance that is not...

No response required.

I have talked them into using an SSIS package instead.

Thanks

Ian

I was unable to resolve this.

Ended up reinstalling SQLSever while nobody was looking, and restored the databases.

I was lucky this time, we had a maintenance window, but if anyone knows...

Thanks Jamie.

Trouble is the physical machine has been renamed.

when I try to disable replication I get the following error

SQL Server replication requires the actual server name to make a connection...

Thanks Lynn

I don't think I explained my needs very well.

My problem is not in fixing this ( I am actually looking forward to working with a tally table and Jeff...

My understanding is that manually growing the files can also contribute to physical file fragmentation.

Look to the link for more information.

http://www.mssqltips.com/tip.asp?tip=1481

OK I have found DBCC PINTABLE

and read with great interest the caution staement on BOL.

Does anyone have any advise on using this functionality

Well it is not the most elegant solution I have ever come up with but it is working.

As I said I can cut and paste the data to the cell...