Hi

Thank you very much for your help. I have added the replace function in the select that forms part of my cursor

declare cr_test cursor for

select replace(location,char(39),char(34)) from test_table

open cr_test

fetch next...

Hi

Thank you very much for your help. I have added the replace function in the select that forms part of my cursor

declare cr_test cursor for

select replace(location,char(39),char(34)) from test_table

open cr_test

fetch next...

Hi Yelena

Thanks for the reply. I have granted them execute privileges on sp_addlinkedserver and -login. They are able to execute it from QA, however it is not updated in EM.

They...

Thanks. I have monthly DBs, so I use getdate() to determine the correct DB to create the stored proc in.

I have tried it and although the query prints out correctly...

Thank you very much guys.

The application needs to modify database objects and therefore db owner, however we need to track more accurately who's doing what, therefore NT authentication. The whole...

Thanks for your help.

Thanks so much. I've developed a script which generates the view from scratch.

All your help is much appreciated.

Thank you very much.

You've helped tremendously!

Thank you very much! The link had exactly the answers I needed.