"You'll want to update SSRS as well"

Thanks, is this a separate process to the usual SQL upgrade? If so, can you provide a URL for guidance please.

I'm getting hassled (rightly...

J drive is the drive that the ISO is mounted to.

I also tried copying the relevant folder to the local C drive and reissuing the command. Still no good.

I've come...

It was nothing amazing (code wise) but just that it understood the exact requirements and seemed to spit it out on the fly

public void Main()
{

  ...

I can only take the senders word for it. They claim not to know how the files got these new characters and I'm assuming it is nothing at our end...

Awesome thanks

Perfect thanks.

And now I have that sorted I realise there is a fundamental flaw in my logic.

What I'm trying to do here is get the years/months returned as 3.3 for...

• This reply was modified 4 years, 1 month ago by  Jay@Work.

ok it is solved and posted here for any interest.

Seems it comes down to my inexperience with cursors. I'd normally avoid them due to the bad press but at times...

I have a count variable incrementing and printing out. I have a log for every catch and every try. Nothing is unexpected except the number of items (rows) created in...

I'm not seeing errors and have logging action in all the catch and try blocks but only errors that occur at the top level are being logged.

I'm guessing that those...

Thanks but my OP was asking abut the debugging feature in VS and if anyone had run into the same errors

Thanks I have 20+ years experience. The individual bits run fine.

I have 67 rows go into a cursor (yeah yeah I know) and it only creates 31 rows. Everytime!

The stored...

With VS running as admin and with your credentials passed with the connection string it does it no problem (at least should).

Profiler won't help me as the SP runs fine...

Perfect thanks anthony.green and anand929

Apologies for the delay in replying... priorities shifted!

ok so now I can go down the preferred route. I have contacted the vendors whose DBs live on the sql server and...

This works prefectly thanks!

declare @ram_id varchar(50),
@tsql nvarchar(1000)
set @tsql = 'select @ram_id = service_ref from OPENQUERY([remoteserver],''select Service_Ref from [remotedb].[dbo].[Service_Request] where service_request_number = ''''2'''''')'
--PRINT @tsql;

exec sp_executesql @tsql, N'@ram_id varchar(50)...